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.