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.
- With dbt. How do I use a jinja macro in a yaml file
- How to deploy SQL views to snowflake using config object?
- How to list (and count) all the models?
- Overriding dbt snapshot table generation
- How do I run SQL model in dbt multiple times by looping through variables?
- dbt keeps returning database error for invalid field even after removing the field
- How to run dbt unit tests with csv files as input and output
- Validate specific date format in dbt
- Can we have intellisense on dbt's yml?
- How to run multi-tag selector
- Explode values in dbt
- dbt external tables not being executed
- Incremental load logic failed in DBT for Initial load
- DBT Test Response: Compilation Error macro 'dbt_macro__test' takes no keyword argument 'model'
- Accessing query results from DBT in python script
- Create procedures in dbt
- DBT run model only once
- How to get the rows that failed the test cases?
- How do I run DBT models from a Python script or program?
- How to add a Jinja function to .sqlfluff config
- 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