Snowflake Known Issues and Limitations

When adding Snowflake connections:

• Do not use the default warehouse for Snowflake Source connections.
• The password for the Snowflake user cannot contain special characters.

When publishing to Snowflake destination tables:

• Publishing will fail if fields have been removed since the last publish. Before publishing, you must either update the destination Snowflake table to match the updated schema or delete the destination table. If you delete the destination table before publishing, Publish recreates the table with the updated schema.
• Publishing the Source Records by Entity Dataset to Snowflake fails, starting with the October 28, 2022 release. Two internally-used fields have been added to the Source Records by Entity dataset and the Apply Clustering step output: appliedRules and ruleClusterId. If you have previously published the Source Records by Entity dataset to Snowflake, you will receive an error when you attempt to re-publish the dataset due to the addition of these fields. Before publishing, either update the destination Snowflake table to add these fields or delete the destination table.