Error: Allow Fivetran to Create Schemas

Issue

I want to create schemas exclusively using Terraform. However, while setting up my destination, the following error appears:

Allow Fivetran to create schemas.

Environment

Destination: Snowflake

Resolution

To resolve this issue, you must grant the CREATE SCHEMA privilege to the authenticating Snowflake user before setting up the destination in Fivetran. However, once you have successfully set up your destination and we have completed our setup tests, you can revoke the CREATE SCHEMA privilege.

Cause

This issue occurs when the authenticating user has not been granted the CREATE SCHEMA privilege which we require to set up and test your destination. For more information, see our Snowflake setup guide.