Fivetran Creating Schema 'FIVETRAN_TESTING_SCHEMA'

Question

Fivetran is attempting to create the following schema in our Snowflake destination:

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.

In these circumstances, Fivetran attempts to create a schema called FIVETRAN_TESTING_SCHEMA. This is a temporary schema for testing for sufficient permissions (e.g., create schema). Once the permission issue is resolved, Fivetran will no longer attempt to create the schema.