Migrating a connector from previous versions using the Data Integration REST API

Migrating a connector from previous versions using the Data Integration REST API

Snowflake

Snowflake

The following table lists the configured advanced source, lookup, and target properties from Snowflake V1 mappings that you can retain when you migrate to Snowflake Data Cloud:
Transformations
Snowflake V1 properties retained after migration to Snowflake Data Cloud
Source
  • Database
  • Schema
  • Warehouse
  • Role
  • Pre SQL
  • Post SQL
  • Table name
  • SQL override
  • Tracing level
Lookup
  • Database
  • Schema
  • Warehouse
  • Role
Target
  • Database
  • Schema
  • Warehouse
  • Role
  • Pre SQL
  • Post SQL
  • Batch row size
  • Number of local staging files
  • Truncate target table
  • Additional runtime properties
  • Table name
  • Rejected file path
  • Success file directory
  • Error file directory
  • Forward rejected rows
Consider the following rules before you migrate the Snowflake V1 connection referenced in an existing mapping to the Snowflake Data Cloud connection:
  • If the existing mapping contains multiple objects, the relationship between these objects is not preserved after you switch to the new connection.

0 COMMENTS

We’d like to hear from you!