# \#external-tables

**URL:** https://discourse.getdbt.com/tag/external-tables/26.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [custom handling of external location\_root for databricks external tables](https://discourse.getdbt.com/t/custom-handling-of-external-location-root-for-databricks-external-tables/20479)

<div class="topic-metadata">

**Author:** [@constantin-op](https://discourse.getdbt.com/u/constantin-op)\
**Replies:** 0\
**Last updated:** [December 5, 2025, 4:53pm UTC](https://discourse.getdbt.com/t/custom-handling-of-external-location-root-for-databricks-external-tables/20479 "2025-12-05T16:53:34Z")

</div>

The problem I’m having I’m trying to create some dbt models for tables in databricks with external location to: azurepath/prefix.table/data The context of why I’m trying to do this In my dbt\_project.yml there is the loc…

---

## [dbt-external-tables with Snowflake S3 stage - what will it do?](https://discourse.getdbt.com/t/dbt-external-tables-with-snowflake-s3-stage-what-will-it-do/19871)

<div class="topic-metadata">

**Author:** [@anentropic](https://discourse.getdbt.com/u/anentropic)\
**Replies:** 5\
**Last updated:** [July 21, 2025, 2:39pm UTC](https://discourse.getdbt.com/t/dbt-external-tables-with-snowflake-s3-stage-what-will-it-do/19871 "2025-07-21T14:39:19Z")

</div>

The problem I’m having I’m looking for more detail of what this package actually does, specifically if I just define an external stage as a source. Let’s say I define this source: - name: people\_csv\_unpartition…

---

## [Snowpipe Config to reorder columns](https://discourse.getdbt.com/t/snowpipe-config-to-reorder-columns/16995)

<div class="topic-metadata">

**Author:** [@jiohjeong98](https://discourse.getdbt.com/u/jiohjeong98)\
**Replies:** 0\
**Last updated:** [November 15, 2024, 10:38pm UTC](https://discourse.getdbt.com/t/snowpipe-config-to-reorder-columns/16995 "2024-11-15T22:38:12Z")

</div>

The problem I’m having After i create snowflake stage and create pipe and table using external-tables package like this name: external: location: “@STAGE” file\_format: “(type = csv record\_delimiter = ‘\\n’ field\_del…

---

## [Accessing external tables in snowflake from dbt](https://discourse.getdbt.com/t/accessing-external-tables-in-snowflake-from-dbt/15208)

<div class="topic-metadata">

**Author:** [@skhan](https://discourse.getdbt.com/u/skhan)\
**Replies:** 0\
**Last updated:** [August 29, 2024, 3:56pm UTC](https://discourse.getdbt.com/t/accessing-external-tables-in-snowflake-from-dbt/15208 "2024-08-29T15:56:50Z")

</div>

The problem I’m having If I create external tables in snowflake via snowsight, can I access the external tables using dbt source object just like how dbt source pulls data from any table/view. The context of why I’m try…

---

## [external source macro syntax error](https://discourse.getdbt.com/t/external-source-macro-syntax-error/10642)

<div class="topic-metadata">

**Author:** [@zxl10311](https://discourse.getdbt.com/u/zxl10311)\
**Replies:** 0\
**Last updated:** [November 5, 2023, 2:05am UTC](https://discourse.getdbt.com/t/external-source-macro-syntax-error/10642 "2023-11-05T02:05:55Z")

</div>

The problem I’m having When running dbt run-operation dbt\_external\_tables.stage\_external\_sources command to create a table in BQ from csv file stored at gcp cloud storage, got below error: \[debug\] \[MainThread\]: BigQuer…

---

## [store model output in external location](https://discourse.getdbt.com/t/store-model-output-in-external-location/10406)

<div class="topic-metadata">

**Author:** [@david.backx](https://discourse.getdbt.com/u/david.backx)\
**Replies:** 0\
**Last updated:** [October 18, 2023, 5:54pm UTC](https://discourse.getdbt.com/t/store-model-output-in-external-location/10406 "2023-10-18T17:54:41Z")

</div>

The problem I’m having I want the output of my model to be stored in my azure blob storage. I can now store it in a local folder but I want the output of my model to go straight to the azure blob storage as a csv file. S…

---

## [Accessing external schemas in Redshift](https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795)

<div class="topic-metadata">

**Author:** [@plotnikov.sseu](https://discourse.getdbt.com/u/plotnikov.sseu)\
**Replies:** 1\
**Last updated:** [September 23, 2022, 3:55am UTC](https://discourse.getdbt.com/t/accessing-external-schemas-in-redshift/4795 "2022-09-23T03:55:38Z")

</div>

All of my raw sources are located in external schemas that I fetch into Redshift. Redshift schema called information\_schema does not store metadata on those sources. My dbt macros that get use of table metadata (like get…

---

## [Custom materialization to load from external table into Snowflake](https://discourse.getdbt.com/t/custom-materialization-to-load-from-external-table-into-snowflake/967)

<div class="topic-metadata">

**Author:** [@sudhirnune](https://discourse.getdbt.com/u/sudhirnune)\
**Replies:** 5\
**Last updated:** [December 7, 2020, 10:09am UTC](https://discourse.getdbt.com/t/custom-materialization-to-load-from-external-table-into-snowflake/967 "2020-12-07T10:09:22Z")

</div>

Hi All, Did any one test or create a Custom Materialization which uses COPY INTO command to load data from External table to snowflake ? If you have created a Custom Materialization can you please share the details.