I ended up adding privileges for the role on the external stage. I didn’t need this explicitly in the dbt Development environment or the Snowflake UI because my own personal user also had higher level permissions from other roles.
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
dbt-external-tables FAILS interacting with Snowflake | 19 | 120 | April 17, 2025 | |
dbt run-operation stage_external_sources causes an error | 0 | 389 | November 20, 2024 | |
dbt_packages - dbt_external_tables | 3 | 4467 | October 25, 2022 | |
Accessing external tables in snowflake from dbt | 0 | 283 | August 29, 2024 | |
dbt External Tables - can I use the same external table with different path? | 0 | 1482 | June 6, 2023 |