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

Previewing SQL ELT query

Previewing SQL ELT query

Before you run a mapping that is configured for SQL ELT optimization or a mapping in SQL ELT mode, you can preview SQL queries in the SQL ELT Query panel in the Mapping Designer.
After you configure a mapping and run the preview,
Data Integration
creates and runs a temporary SQL ELT preview mapping task. When the job completes,
Data Integration
displays the SQL queries to be executed and any warnings in the
SQL ELT Query
panel. The warning messages help you understand which transformations in the configured mapping are not applicable for SQL ELT optimization. If SQL ELT query preview fails,
Data Integration
lists any queries generated up to the point of failure. You can edit the mapping and fix the required transformations before you run the mapping for SQL ELT optimization.
You can also view the temporary job created under
My Jobs
and download the session log to view the queries generated.
For more information about how to preview SQL ELT query, see "SQL ELT query preview" in
Mappings
in the Data Integration documentation.

0 COMMENTS

We’d like to hear from you!