Can dbt show data dependency to non dbt table?

user_17194313 0
Viewed 434

I'm am a big fan of the data lineage graph generated by dbt.

enter image description here

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.

dbt
1 Answers

You could use DBT Sources for that. If you create a source of your orders table, it will appear in the data lineage.

user_70418710
Related