Snowflake Data Cloud Connector

Back Next

Configuring SQL ELT optimization

To optimize a mapping, add the mapping to a task, and then configure SQL ELT optimization in the

mapping

task.

Create a

mapping

task.

In the

SQL ELT Optimization

section on the

Runtime Options

tab, set the SQL ELT optimization value to

Full

To Source

If full SQL ELT optimization is not available, select how Data Integration handles SQL ELT optimization in the

SQL ELT Optimization Fallback Option

menu:

Partial SQL ELT. Default. Data Integration pushes as much transformation logic as possible to the source and target database. The task processes any transformation logic that it can't push to a database. You can use Partial SQL ELT only when you read from and write to Snowflake.

Non SQL ELT. The task runs without SQL ELT optimization.

Fail Task. Data Integration fails the task.

The fallback options are not applicable to mappings in advanced mode.

When you run the mapping task, the transformation logic is pushed to the configured database. To verify that the mapping was optimized, you can check the session log for the job. In

Monitor

, view the log for jobs.

SQL ELT optimization for mapping tasks

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal