Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Step 2. Configure the target

Step 2. Configure the target

Configure a Target transformation to write changed data from a CDC source to Snowflake.
You can only configure a single Snowflake Data Cloud target transformation in a mapping to write changed data from a CDC source.
  1. On the
    Target
    tab, perform the following steps to configure the target properties:
    1. In the
      Connection
      field, select theSnowflake Data Cloud connection.
    2. In the
      Target Type
      field, select the type of the target object.
    3. In the
      Object
      field, select the required target object.
    4. In the
      Operation
      field, select
      Insert
      or
      Data Driven
      .
      Update, upsert, and delete target operations are not applicable. Ensure that the target tables do not have a primary key defined in Snowflake.
    5. If you select
      Data Driven Condition
      , specify the
      DD_INSERT
      condition.
      Ensure that the target tables do not have a primary key defined in Snowflake.
    6. Configure the applicable advanced target properties for the CDC mode.
  2. On the
    Field Mapping
    tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names.
    If you define a column as required in the Snowflake target table, map a column in the CDC source to the required column in the Snowflake target in the mapping.

0 COMMENTS

We’d like to hear from you!