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.
On the
Target
tab, perform the following steps to configure the target properties:
In the
Connection
field, select theSnowflake Data Cloud connection.
In the
Target Type
field, select the type of the target object.
In the
Object
field, select the required target object.
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.
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.
Configure the applicable advanced target properties for the CDC mode.
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.
ASK INFAPreview
