{"id":2906,"date":"2021-01-24T22:38:43","date_gmt":"2021-01-25T06:38:43","guid":{"rendered":"https:\/\/www.gudusoft.com\/?page_id=2906"},"modified":"2021-03-24T00:57:44","modified_gmt":"2021-03-24T08:57:44","slug":"snowflake-data-lineage","status":"publish","type":"page","link":"https:\/\/www.gudusoft.com\/fr\/snowflake-data-lineage\/","title":{"rendered":"Automated data lineage of Snowflake database"},"content":{"rendered":"

SQLFlow including the grabit tool<\/a> connect to snowflake database and get the lineage for all the objects in the database. It will\u00a0 analyse the Sql, DDL,procedures, functions. All snowflake specific SQL statements are supoprted including: create stage, copy into, create file format and etc.<\/h4>\n<\/div>

This diagram shows the dataflow in a snowflake database. It originated from an AWS s3 data source, then copied into the snowflake database by using create\u00a0 stage, create file format and copy into snowflake commands, then saves to a temporary table by using the create temporary table statement, and finally, the data is aggregated into the view which the BI and other systems will use.<\/p>\n<\/div>

\"snowflake<\/a><\/span><\/div>
<\/div><\/div><\/div>