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

Snowflake Data Cloud transformations

Snowflake Data Cloud transformations

Add transformations to the mapping to represent the operations that you want to perform on data.
You can add the following transformations and define the transformation details in a mapping:
Source transformation
Add a Source transformation to read data from Snowflake or other data sources. You can read from a single or from multiple Snowflake tables. You can also use a query or parameter as the source type to read from Snowflake.
You can use one or more Source transformations in a mapping. When you use a single transformation to read from multiple tables, you can use a join. If you use two Source transformations in a mapping, use a Joiner transformation to join the data.
Target transformation
Add a Target transformation to write data to Snowflake. You can use one or more Target transformations in a mapping. When you configure a target transformation, you an use a single Snowflake target object. You can use a new or an existing Snowflake target object. You can also use parameters to define the target connection and target object when you run the mapping task.
Lookup transformation
Add a Lookup transformation to retrieve data based on a specified lookup condition. The lookup object can be a single object or query. You can also parameterize the lookup objects and connections.
For more information about the objects and the properties that you can configure for each of these transformations in a mapping
or in a mapping in advanced mode
, see the Source, Target, and Lookup chapters.
You can also add other transformations to the mapping to transform the data.
For more information about configuring transformations, see
Transformations
in the
Data Integration
documentation.

0 COMMENTS

We’d like to hear from you!