Before writing data to Snowflake target tables,

application ingestion

jobs write the data to an internal staging area. You must specify the staging directory when you configure the

application ingestion

task.

When you define a connection for a Snowflake target, you must set the

Additional JDBC URL Parameters

field to

database=

target_database_name

. Otherwise, when you try to define the target in the

application ingestion

task wizard, an error message indicating that the list of schemas cannot be retrieved appears.

Incremental load jobs generate a recovery table named INFORMATICA_CDC_RECOVERY on the target to store internal service information. The data in the recovery table prevents the jobs that are restarted after a failure from propagating previously processed data again. The recovery table is generated in the schema that contains the target tables.

Snowflake targets cannot modify the scale of NUMBER fields. Additionally, Snowflake targets do not support changing the data type of an existing field to a different data type.