The following error appears within the Snowflake logs:
Invalid clustering keys or table [table_name] is not clustered.
Snowflake: Logging within Snowflake
The Fivetran connector to the Snowflake warehouse has the option to use cluster keys to improve query performance. This is outlined in our Documentation:
It is not a requirement and the connector will work as normal if there are no cluster keys set for tables. The errors you are seeing occur in relation to when our queries check for cluster keys on tables and result in query failures.
In this case, there are no cluster keys on the tables which results in the error you are seeing.
For more details on these queries related to cluster keys:
- they are performed to understand the reasons for slow performance and suggest appropriate changes to the end user if applicable.
- they only fail if there is no clustering key on a given table.
- they are only performed once a day, and should not be generating any extra costs.
- we haven't considered disabling these because the information whether partitioning is present and what it applies to is important for the application to function.