Snowflake Troubleshooting
Learn how to troubleshoot common issues with Snowflake destinations.
Data Integrity
Errors, Warnings, and Alerts
- Error: Cannot Rename Column That Belongs to a Clustering Key
- Error: Duplicate Row Detected During DML Action
- Error: Could Not Connect to Snowflake Backend
- Error: JWT Token Is Invalid
- Error: Role Specified in the Connect String Does Not Exist or Not Authorized
- Error:
FIVETRAN_TESTING_TABLEDoes Not Exist or Not Authorized - Error: Insufficient Privileges to Operate on Database
- Error: Insufficient Privileges To Operate on Schema
FIVETRAN_TESTING_SCHEMA - Error: Invalid Clustering Keys or Table Is Not Clustered
- Error: Invalid Identifier in Snowflake
- Error: Invalid Private Key
- Error: Statement Reached Its Statement or Warehouse Timeout and Was Canceled
- Error: String is too long to be compared using collation
- Error: Token Expired
- Error: Unable to Access Existing Tables
- Error: Validate Passphrase: It Seems Your Private Key Is Not in Correct Format
- Error: You Must Specify
AUTO_RESUME = TRUE - Unable to Query
ORDERTables in Snowflake
FAQ
- Does Fivetran Use Internal or External Staging for My Snowflake Destination?
- Does Snowflake Truncate, Round, or Error When Number Precision Is Exceeded?
- Why Do Snowflake Schema Names Use Different Casing?
- Why Does Fivetran Require the CREATE SCHEMA Privilege in Snowflake?
- Why Is Fivetran Creating Schema
FIVETRAN_TESTING_SCHEMA? - Why Is There Increase in Fail-Safe Backup Storage When Copying Data to the Destination?
How To
Setup and Configuration
- Can I Create a Snowflake Destination Schema in Advance for Fivetran Syncs?
- Can I use Snowflake's Dynamic Data Masking Feature With Fivetran?
- Can I use Snowflake's Row Access Policies with Fivetran?
- Save Button Remains Disabled When Switching to Key-Pair Authentication in Snowflake
- What Are the Recommended Snowflake Parameter Settings?
- What Is the Optimal Snowflake Configuration?