Hi all, Quick question about the dbt ingestion: I ...
# ingestion
w
Hi all, Quick question about the dbt ingestion: I do I get the compiled view definition? When I look at my dbt models in the UI, on the tab View Definition I see elements like
ref {{}}
and my teammates would like to see our snowflake table name (database.schema.table_name). Can you help me on this?
g
I don’t think we’re currently capturing the compiled SQL. If you click the lineage view, you should be able to see the corresponding snowflake tables - is that what you’re looking for?
w
Well it doesn't appear that way, when I click on the corresponding snowflake view or table I'm automatically redirected to the dbt view definition. I've recorded a video to show you this
m
The page you are seeing is the "combined entity page" for the dbt and Snowflake combo. The "Composed Of" section on the right allows you to click to the specific Snowflake table and see it without the dbt information overlaid.
w
The "Composed of" section only links to a dataset, not a view or a table so it's not possible to see the view/table SQL definition