My career as a DBT lineage graph

For my presentation at Copenhagen’s DBT Meetup, I created a DBT project to show my career as a DBT lineage graph. I had just learnt about exposures, and wanted to experiment with minimal requirements.

How it was made

I copied a table in Redshift to the desired source names for staging; the entire lineage is calling the same table, as I only wanted the lineage graph, so the column names being the same was not an issue.

Once I had staging layers, I created intermediate layers by select * in the order I wanted the lineage output.

This was sufficient to create an exposure that referenced the desired end nodes of the graph.