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 cross-database SQL ELT optimization

Configuring cross-database SQL ELT optimization

To push processing logic across different Snowflake databases, configure cross-database SQL ELT optimization in the
mapping
task.
  1. Create a
    mapping
    task.
    1. Select the configured
      mapping
      .
    2. In the
      SQL ELT Optimization
      section on the
      Runtime Options
      tab, set the SQL ELT optimization value to
      Full
      .
  2. To enable push down across databases, in the
    Advanced Options
    on the
    Runtime Options
    tab, select
    Allow SQL ELT across Databases
    as the
    Session Property Value
    and set the
    Session Property Value
    to
    Yes
    .

0 COMMENTS

We’d like to hear from you!