Before writing data to Snowflake target tables,

database ingestion

jobs first write the data to an internal staging area that has the stage name you specified in the associated

database 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

database ingestion

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

Database ingestion

incremental load jobs and combined initial and incremental load jobs generate a recovery table named INFORMATICA_CDC_RECOVERY on the target to store internal service information that prevents jobs restarted after a failure from propagating previously processed data again. This recovery table is generated in the same schema as the target tables.