We have added a new test in the Snowflake destination setup form to verify CREATE SCHEMA and CREATE TEMPORARY TABLES permissions. When you set up your Snowflake destination, the new test will automatically validate these permissions.
We have reduced the sync duration of append-only tables. During internal performance testing, we observed a reduction in sync time for destinations with large table sizes. We are gradually rolling out this change to all our existing customers.
We now support key pair authentication to connect to your Snowflake warehouse.
We now support Snowflake on Google Cloud Platform. For more information, see Snowflake's website.
Snowflake does not allow the following ANSI reserved keywords to be column names when they are capitalized:
To ensure a valid column name, Fivetran converts the keyword to lowercase and encases it in double quotes (for example,
"localtime"). When you query these columns, be sure to use the converted column name.