dbt
Can dbt show data dependency to non dbt table?
I'm am a big fan of the data lineage graph generated by dbt.
However, this only shows the relationships between tables & views created by dbt. Is there a way to show the dependencies to "original" tables in the database?
Say, if my dbt model creates a view of called open_orders as
SELECT * FROM orders WHERE status='Open'
I'd like to have the data lineage graph show that open_orders depends on orders.
Solution
You could use DBT Sources for that. If you create a source of your orders table, it will appear in the data lineage.
- Write dbt test for positive values
- Safe selecting non-existent column in SQL (or dbt)
- Extracting ref and source tables from a dbt model
- Declare var in other macro to be used in a different macro for DBT
- Is it a good practice to use update_timestamp for incremental loading in DBT with insert_overwrite strategy?
- How can I run python code after a DBT run (or a specific model) is completed?
- datetime2 insertion in postgresql
- Manipulate string in DBT's macro with Jinja2
- dbt lineage issue with dbt build and tests
- for loop that iterates over a list using dbt
- change column names using a dbt macro
- I want to use the condition union if exists with a table referred with {{this}} in snowflake SQL
- Create a Sql Statement IN DBT macro and use the query in the dbt model
- Is changing date partitionning granularity a breaking change?
- Disable elementary from DBT CLI when running dbt test
- How to get the dependencies of a model in dbt in terms of a table
- Extract JSON array from object (redshift)
- How to replace strings in a column if exist in a list with dbt jinja?
- Set Spark configuration when running python in dbt for BigQuery
- Return specific column from Snowflake `show tables` command
- Cosmos DbtDag running model can not find environment variables used in macros
- Where to find dbt macros when wishing to edit it
- installation pip install dbt-postgres
- Disable DBT models using code or config (not commands)
- Does dbt 0.21.0 on_schema_change requires --full-refresh?
- Whats the best way to design an event table where different event items are provided each time the event updated
- azure pipeline variable to hold return value of DBT core macro
- How to label a dbt project so that I can query the INFORMATION_SCHEMA for all jobs created by this project?
- DBT conflicts in resource naming across different GCP projects
- how to pass a variable from one macro to another in pre_hook