# \#lineage

**URL:** https://discourse.getdbt.com/tag/lineage/16.md

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

---

## [Visualise overall dataflow on system level (with DAG?)](https://discourse.getdbt.com/t/visualise-overall-dataflow-on-system-level-with-dag/20460)

<div class="topic-metadata">

**Author:** [@elva](https://discourse.getdbt.com/u/elva)\
**Replies:** 1\
**Last updated:** [December 2, 2025, 11:40am UTC](https://discourse.getdbt.com/t/visualise-overall-dataflow-on-system-level-with-dag/20460 "2025-12-02T11:40:28Z")

</div>

Hi everyone, I’m new to dbt and it’s my first post here. Hope that I don’t raise stupid question. My question is: Is it possible to modify DAG to show the upper lever instead of table level? Our business stakeholders j…

---

## [dbt lineage issue with dbt build and tests](https://discourse.getdbt.com/t/dbt-lineage-issue-with-dbt-build-and-tests/14455)

<div class="topic-metadata">

**Author:** [@Ruba\_AT](https://discourse.getdbt.com/u/Ruba_AT)\
**Replies:** 4\
**Last updated:** [July 25, 2024, 7:43am UTC](https://discourse.getdbt.com/t/dbt-lineage-issue-with-dbt-build-and-tests/14455 "2024-07-25T07:43:34Z")

</div>

The problem I’m having I’m having a problem with dbt lineage… When I run locally this command dbt build --select +model\_x it builds 25 models with version 1.7.4 when I updated my dbt to 1.8.2 the dbt build failed and i…

---

## [Best practice with multiple regions & external tables in BigQuery](https://discourse.getdbt.com/t/best-practice-with-multiple-regions-external-tables-in-bigquery/14132)

<div class="topic-metadata">

**Author:** [@simonl07](https://discourse.getdbt.com/u/simonl07)\
**Replies:** 0\
**Last updated:** [July 8, 2024, 10:00pm UTC](https://discourse.getdbt.com/t/best-practice-with-multiple-regions-external-tables-in-bigquery/14132 "2024-07-08T22:00:42Z")

</div>

The problem I’m having I’m looking for some advice on the best way to manage sources / staging models from multiple regions in BigQuery while the primary analytics models are in us-west1 in BigQuery The context of why I…

---

## [Combining dbt\_utils.get\_relations\_by\_pattern with dbt\_utils.union\_relations breaks lineage in Redshift](https://discourse.getdbt.com/t/combining-dbt-utils-get-relations-by-pattern-with-dbt-utils-union-relations-breaks-lineage-in-redshift/13394)

<div class="topic-metadata">

**Author:** [@malte.hoefers](https://discourse.getdbt.com/u/malte.hoefers)\
**Replies:** 2\
**Last updated:** [May 16, 2024, 1:02pm UTC](https://discourse.getdbt.com/t/combining-dbt-utils-get-relations-by-pattern-with-dbt-utils-union-relations-breaks-lineage-in-redshift/13394 "2024-05-16T13:02:22Z")

</div>

The problem I’m having We have a few models, that select from a longer list of other models and combine them with a “union all”. Thus we found the two macros in dbt\_utils, that in combination makes the modeling much more…

---

## [Building a snowflake UDF in a macro with forced lineage via hooks](https://discourse.getdbt.com/t/building-a-snowflake-udf-in-a-macro-with-forced-lineage-via-hooks/7824)

<div class="topic-metadata">

**Author:** [@janine.rawnsley](https://discourse.getdbt.com/u/janine.rawnsley)\
**Replies:** 1\
**Last updated:** [April 13, 2023, 4:51pm UTC](https://discourse.getdbt.com/t/building-a-snowflake-udf-in-a-macro-with-forced-lineage-via-hooks/7824 "2023-04-13T16:51:07Z")

</div>

The problem I’m having I’m getting a cyclical compile issue in this scenario: MacroB builds a snowflake UDF. The UDF itself references ModelA. ModelA has a posthook to call MacroB, since ModelA has to exist in order f…

---

## [Custom node colouring for analysis and test nodes in lineage graph](https://discourse.getdbt.com/t/custom-node-colouring-for-analysis-and-test-nodes-in-lineage-graph/7797)

<div class="topic-metadata">

**Author:** [@III](https://discourse.getdbt.com/u/III)\
**Replies:** 1\
**Last updated:** [April 12, 2023, 10:22am UTC](https://discourse.getdbt.com/t/custom-node-colouring-for-analysis-and-test-nodes-in-lineage-graph/7797 "2023-04-12T10:22:39Z")

</div>

Question Is it possible to have node colouring on specific analysis and test nodes within the data catalog? Referring to custom node colour documentation, only examples using models are used.

---

## [Creating a separate database for datasets created by Python pipelines](https://discourse.getdbt.com/t/creating-a-separate-database-for-datasets-created-by-python-pipelines/4891)

<div class="topic-metadata">

**Author:** [@nancy.chelaru](https://discourse.getdbt.com/u/nancy.chelaru)\
**Replies:** 2\
**Last updated:** [September 8, 2022, 8:31pm UTC](https://discourse.getdbt.com/t/creating-a-separate-database-for-datasets-created-by-python-pipelines/4891 "2022-09-08T20:31:48Z")

</div>

Hello! Please let me know if this is the wrong category for post this! A bit of background on our current database set up. We have a staging database for preparing datasets from external provider databases, a developme…