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

Configuring a mapping task to read from a CDC source

Configuring a mapping task to read from a CDC source

You can use Snowflake Data Cloud Connector to capture changed data from a CDC source and write the changed data to a Snowflake target.
Add the CDC source in the mapping, and then run the associated mapping task to write the changed data to the Snowflake target. You can also configure multiple pipelines in a single mapping to write the captured changed data to a Snowflake target.
When you configure a mapping to write changed data from a CDC source to Snowflake, you can configure the following advanced properties in the Snowflake Target transformation:
  • Database
  • Schema
  • Warehouse
  • Role
  • Pre SQL
  • Post SQL
  • Truncate target table
  • Table name
  • Update override

0 COMMENTS

We’d like to hear from you!