Snowflake Data Cloud Connector

Back Next

Mappings in SQL ELT mode for Snowflake Data Cloud

You can create mappings in SQL ELT mode to read data from your Snowflake cloud data warehouse or from Snowflake, Amazon S3, or Microsoft Azure Data Lake Storage Gen2 in your cloud ecosystem, load it to your Snowflake cloud data warehouse, and perform all of the data transformation within Snowflake.

To create a mapping in SQL ELT mode, you create a mapping, and then select

Mapping - SQL ELT

as the mapping type. You're then prompted to choose a Snowflake target connection. If your organization doesn't have any Snowflake connections, you're prompted to create one. Before you create mappings in SQL ELT mode, be sure to complete the prerequisites. For more information, see Prepare for SQL ELT.

After you choose the target connection, the Mapping Designer opens. When you create a mapping, a Source transformation and a Target transformation are already on the canvas for you to configure.

Part 3: SQL ELT with Snowflake Data Cloud Connector

Sources in mappings in SQL ELT mode

Targets in mappings in SQL ELT mode

Transformations in mappings in SQL ELT mode

Functions in mappings in SQL ELT mode

Operators in mappings in SQL ELT mode

Rules and guidelines in mappings in SQL ELT mode

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities