Is there anyway to automatically retrieve source table and source column names of a dataset?

Matillion ETL
1

I'm documenting our Snowflake tables where we want to write down source table and source column names for each DWH table. Is it possible to automate this task using API or some other way?

For instance,

Table_Warehouse in Snowflake is made of Table_A and Table_B by left join. So how do I get the names of source columns for respective target columns using some kind of automation?

0694G00000QeGowQAF_0D54G0000996lVqSAI
0694G00000QeGowQAF_0D54G0000996lVqSAI923×458 3.66 KB

2

@NeelamMacwan​ - if you are looking for table names and structure in Snowflake you can refer to the information schema present under each database by quering the [tables] or [views] view.

https://docs.snowflake.com/en/sql-reference/info-schema

If you are looking for dependencies and extract table / data lineage, you can refer the to Snowflake Database share > ACCOUNT_USAGE > OBJECT_DEPENDENCIES view

https://docs.snowflake.com/en/sql-reference/account-usage/object_dependencies

3

Thank you so much, @ramalingam​ .

I'll have a look.

Neelam