You can configure Okta SSO authentication by specifying the authentication details in the JDBC URL parameters of the Snowflake connection.

You can configure an SQL override to override the default SQL query used to extract data from the Snowflake source. Specify the SQL override in the Snowflake data object read operation properties.

You can choose to compress the files before writing to Snowflake tables and optimize the write performance. In the advanced properties. You can set the compression parameter to On or Off in the

Additional Write Runtime Parameters

field in the Snowflake data object write operation advanced properties.

The Data Integration Service uses the Snowflake Spark Connector APIs to run Snowflake mappings on the Spark engine.

You can read data from and write data to Snowflake that is enabled for staging data in Azure or Amazon.