You can run Snowflake mappings in the Databricks environment.

You can use Snowflake objects as dynamic sources and targets in a mapping.

You can create a Snowflake target using the

Create Target

option.

You can configure a target schema strategy for a Snowflake target in a mapping. You can choose from the available options to either retain the existing target schema or create a target if it does not exist. You can also specify the target schema strategy options as a parameter value.

You can specify a rejected file name and path in the Snowflake advanced target properties which the Data Integration Service uses to write records that are rejected while writing to the target.

When the ODBC provider type in the Snowflake ODBC connection is Snowflake, you can configure pushdown optimization to push the transformation logic to the Snowflake database.

You can read or write data of Decimal data type of 38-bit precision and scale by configuring the

EnableSDKDecimal38

custom flag in the Data Integration Service properties.