You can now stage your data in Google Cloud Storage (GCS) if your Snowflake data warehouse is deployed on Google Cloud Platform (GCP) for improved performance. Grant the
FIVETRAN_ROLE the CREATE INTEGRATION permission using the following query:
GRANT CREATE INTEGRATION ON ACCOUNT TO ROLE FIVETRAN_ROLE;
You can now use the following encryption algorithms for Key-pair authentication:
We have added a new optional field Role to the Snowflake destination setup form. If you want Fivetran to use a role other than your default role, enter the role’s name during the destination setup in the Role field. See our setup instructions for more information.
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.