Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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: Troubleshooting

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.
  2. Select the configured
    mapping
    .
  3. On the
    Runtime Options
    tab, perform the following tasks:
    1. In the
      SQL ELT Optimization
      section , set the
      SQL ELT optimization
      value to
      Full
      .
    2. In the
      Advanced Session Properties
      section, add the
      Allow SQL ELT across Databases
      session property and enable the session property value.

0 COMMENTS

We’d like to hear from you!