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

Transformations with Snowflake Data Cloud

Transformations with Snowflake Data Cloud

When you configure SQL ELT optimization, Data Integration tries to push the configured transformation to Snowflake.
You can use full SQL ELT to push the following transformations to Snowflake:
  • Aggregator
  • Expression
  • Filter
  • Hierarchy Processor
  • Joiner
  • Lookup
  • Normalizer
  • Rank
  • Router
  • Sequence Generator
  • SQL
    *
  • Sorter
  • Union
  • Update Strategy
    *
*Doesn't apply to mappings in advanced mode.
Router transformation is applicable only for source SQL ELT
and Hierarchy Processor transformation is applicable only to mappings in advanced mode
.
For more information about configuring transformations, see
Transformations
in the Data Integration documentation.

0 COMMENTS

We’d like to hear from you!