Error Using Snowflake DML Import Bridge in Talend Data Catalog

Chirag_ — Thu, 06 Mar 2025 07:31:16 GMT

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

Re: Error Using Snowflake DML Import Bridge in Talend Data Catalog

mchapman — Tue, 01 Apr 2025 14:01:01 GMT

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/MIRSqlScriptSnowflakeImport.htm

topic Error Using Snowflake DML Import Bridge in Talend Data Catalog in Talend Data Catalog

Error Using Snowflake DML Import Bridge in Talend Data Catalog

Re: Error Using Snowflake DML Import Bridge in Talend Data Catalog