I’m trying to use the dbt-external-tables package with my Snowflake account, through dbt Cloud. This should create raw tables for me, using S3 as the source. Below is my source configuration: version: 2 sources: - name: dc305_animals database: "{{env_var('DBT_DB_NAME')}}" schema: _raw …

If Terraform created the database/schema as “dev”.“_raw” then you either get Terraform to drop the quotes, always use uppercase, or always use quoted identifiers and lowercase names in Snowflake Note: @Mark Estey originally posted this reply in Slack . It might not have transferred perfectly.

dbt-external-tables FAILS interacting with Snowflake

Help

system Closed April 24, 2025, 12:23am 20

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
dbt-external-tables CAN'T FIND external stage Help snowflake , dbt-cloud	3	94	April 21, 2025
dbt_packages - dbt_external_tables Help snowflake , dbt-cloud	3	4523	October 25, 2022
unable to connect to specified database (snowflake) Help	4	16137	August 20, 2023
Accessing external tables in snowflake from dbt Help external-tables , snowflake , dbt-cloud	0	299	August 29, 2024
Problem with configurations Help	4	3490	April 16, 2024

dbt-external-tables FAILS interacting with Snowflake

Related topics