Share via

Lineage not shown after Snowflake metadata is scanned to Purview

Sikou Koïta 20 Reputation points
2024-01-22T15:56:07.35+00:00

Hello Community, I'd like to contact you as part of our POC on integrating Snowflale data into Purview. However, we have encountered a specific problem and we think your expertise could help us solve it. The problem is : Lineage not created when scanning Snowflake in Purview. I was able to test with tables and stored procedures (JavaScript and SQL) : 1

2

4

5

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,065 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Debarchan Sarkar - MSFT 1,131 Reputation points Microsoft Employee
    2024-01-26T05:15:22.59+00:00

    Lineage not appearing after scanning Snowflake with Microsoft Purview could be due to several possible reasons. Here are some troubleshooting tips you might want to consider:

    1. Incomplete Scanning: Ensure the scan has completed successfully. Check the scan history for any errors or warnings that might have occurred during the process.
    2. Scope of Scan: Ensure the scope of your scan includes the assets for which you want to create lineage. If a view was created by tables from different databases, you must scan all databases simultaneously using the names in the semicolon (;) list.
    3. Check Account Identifier and Credentials: Check your account identifier in the source registration step. Don't include https:// part at the front. Also, ensure that the user specified in Microsoft Purview has the necessary access rights to both the warehouse and the database you're trying to scan.
    4. Case Sensitivity: Make sure the warehouse name and database name are in capital case on the scan setup page.
    5. Ingestion Process: After the scan, the metadata gathered is ingested into the data map. This process could take time depending on the volume of data. You'll need to wait for the ingestion process to finish before you can see the lineage information.
    6. Check Lineage Support: Not all Snowflake resources support lineage. For example, Stored procedures lineage is supported for Snowflake Scripting (SQL) and JavaScript languages, and generated based on the procedure definition.

    If none of these steps resolve your issue, it would be best to contact Microsoft Support for further assistance. They have more tools and resources available to help troubleshoot this kind of problem.

    0 comments