Forum Discussion

jamesgiop's avatar
jamesgiop
Copper Contributor
Jan 19, 2025

Failed to ingest relationship with type dataset_process_inputs (Snowflake)

Hi All,


Having the above issue when scanning snowflake but

A - Only recently (perhaps since the start of the year)

B - Only for around 5/2000 objects within snowflake.


From the database side, it appears as if Purview is not using the database name within the query for a small subset of relationships between objects (a mix of tables, views and SP's) in two different databases.

 

Any ideas why this could be happening? I've removed some detail from the query below such as our snowflake instance but this is the output in Purview's error logs: 

 

Failed to ingest relationship with type dataset_process_inputs between the following two assets due to invalid data payload to data map: 
asset with type snowflake_table and qualified name 'snowflake://******eu-west-1.snowflakecomputing.com/databases/STAGE/schemas/FULFIL/tables/SUBSCRIPTION', 
and asset with type snowflake_view_query and qualified name 'snowflake://******.eu-west-1.snowflakecomputing.com/databases/STAGE/schemas/FULFIL/views/ACTIVE_SUBSCRIPTION_PRODUCT_VW/query'. 
Please contact support for help.

No RepliesBe the first to reply

Resources