Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikkies,
I'm trying to extract data lineage from Snowflake DML operations into Talend Data Catalog (TDC) using the SnowSQL import bridge. However, SnowSQL doesn't directly export the required file, so we're manually copying and pasting into a .sql
file. This method only partially captures DML scripts, and we can't establish proper lineage.
Has anyone successfully used this bridge ?
Also any success in CREATE STREAM
, CREATE PIPE
, or CREATE TASK
alongside DML? Or should these be treated separately as DDL?
Here's a snippet for reference: (What metadata is imported)
Script
Did you find a resolution to your issue? There is information in the documentation about when to use DDL scripts versus getting the true metadata from the databases tables themselves (scripts can become out of date and not reflect the truth): https://help.qlik.com/talend/en-US/talend-data-catalog/Cloud/Subsystems/Bridges/Content/MIRSqlScript...