You can configure a lookup operation on a Snowflake table. You can also enable lookup caching for a lookup operation to increase the lookup performance. The Data Integration Service caches the lookup source and runs the query on the rows in the cache.

You can parameterize the Snowflake connection, and data object read and write operation properties.

You can configure key range partitioning for Snowflake data objects in a read or write operation. The Data Integration Service distributes the data based on the port or set of ports that you define as the partition key.

You can specify a table name in the advanced target properties to override the table name in the Snowflake connection properties.