Question
Fivetran is attempting to create a schema in our snowflake data warehouse.
CREATE SCHEMA "FIVETRAN_TESTING_SCHEMA_760403B1-4878-4EC2-9FB0-BC11D5C81FAB"
Environment
Destination: Snowflake
Answer
This is the expected behavior if the sync fails due to a Snowflake permissions issue such as "Insufficient privileges to operate on database <database_name>". In these circumstances, Fivetran attempts to create a schema called FIVETRAN_TESTING_SCHEMA. This is a temporary schema in order to test for sufficient permissions (e.g. create schema
). Once the permission issue is resolved Fivetran will no longer attempt to create the FIVETRAN_TESTING_SCHEMA.