When you create a mapping, you define the Source, Target, and Lookup transformations to represent a Snowflake Data Cloud object. Use the Mapping Designer in Data Integration to add the Source, Target, or Lookup transformations in the mapping canvas and configure the source, target, and lookup properties. To create a mapping, select

Mapping

as the mapping type in the Mapping Designer.

When you run a Snowflake mapping task

based on either a mapping or a mapping in advanced mode

and it completes, you can view the number of processed and failed rows for each source and target in the job details page.

This chapter provides instructions on configuring mappings

and mappings in advanced mode

for Snowflake Data Cloud. You can add mappings

and mappings in advanced mode

to the mapping task and enable SQL ELT optimization in the mapping task. For more information, see SQL ELT optimization for mapping tasks.

You can also create a mapping in SQL ELT mode when your source and target are in the same cloud ecosystem and you want to perform the data transformation entirely within the cloud ecosystem. For more information about mappings in SQL ELT mode, see Mappings in SQL ELT mode for Snowflake Data Cloud.