Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Chirag_
Partner - Contributor III
Partner - Contributor III

Error Using Snowflake DML Import Bridge in Talend Data Catalog

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)

Chirag__0-1741245918402.png

 

Script 

Chirag__1-1741246165109.png

 

 

Labels (1)
1 Reply
mchapman
Employee
Employee

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...