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

Properties retained after the switch

Properties retained after the switch

When you replace the source or target connection type in existing mappings or mapping tasks that use the Snowflake V1 connection or the Snowflake ODBC connection with the Snowflake Data Cloud connection, you have the option to retain the configured advanced properties and the field mappings.
The following table lists the configured advanced source, lookup, and target properties from the Snowflake ODBC connection that are retained in Snowflake Data Cloud mappings:
Properties
Snowflake ODBC properties retained in Snowflake Data Cloud
Source
  • Pre SQL
  • Post SQL
Target
  • Pre SQL
  • Post SQL
  • Truncate target
  • Forward rejected rows
  • Update override
The following table lists the configured advanced source, lookup, and target properties from Snowflake V1 retained in Snowflake Data Cloud mappings:
Properties
Snowflake V1 properties retained in 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

0 COMMENTS

We’d like to hear from you!