Why Does Fivetran Require the CREATE SCHEMA Privilege in Snowflake?

Question

Why does Fivetran require the CREATE SCHEMA privilege in Snowflake?

Environment

Destination: Snowflake

Answer

We require the CREATE_SCHEMA privilege to:

• Create destination schemas and tables, including when syncing schema changes from the source.
• Create the destination schema during the initial sync using the configured prefix and source schema name.
• Create temporary test schemas to verify permissions and confirm that the destination is ready for syncing.

If you remove the privilege, your connection may continue to sync until we perform one of these operations. At that point, you may encounter an error.