Error: Could Not Connect to Snowflake Backend

Issue

Quickstart data models fail. The following error appears:

Runtime Error: Database error while listing schemas in database "fivetran" Database Error 250001: Could not connect to Snowflake backend after 0 attempt(s). Aborting.

Environment

• Transformations: Quickstart data models
• Destination: Snowflake

Resolution

To resolve this issue, utilize our Transformations for dbt Core integration to facilitate your connection to Snowflake using a custom hostname.

Cause

For our Quickstart data models, the account parameter is hardcoded in the profiles.yml file. As a result, you can't connect to the database using a custom hostname. This issue occurs when you use a third-party service to configure a custom hostname instead of the default Snowflake account name.