Data Lineage in Snowflake

Priyanka Duggal 1 Reputation point
2023-04-03T12:46:00.81+00:00

Unable to see data lineage for snowflake. Please help in case I need to take care of anything such as permissions

User's image

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
{count} votes

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
    2023-04-04T07:00:42.3366667+00:00

    Priyanka Duggal - Thanks for the question and using MS Q&A platform.

    To view data lineage for Snowflake in Microsoft Purview, you need to ensure that you have the necessary permissions. You can check the credential you set up in Microsoft Purview. The user you specify must have a default role with the necessary access rights to both the warehouse and the database you're trying to scan. See Required permissions for scan. You can also use the QUERY_HISTORY_BY_USER table function to identify what role is being used by the connection. Setting up a dedicated Microsoft Purview user will make troubleshooting easier. For more details, refer to Connect to and manage Snowflake in Microsoft Purview.

    Hope this helps. Do let us know if you any further queries.


  2. Sikou Koïta 20 Reputation points
    2024-01-17T17:28:44.36+00:00

    Hello @PRADEEPCHEEKATLA-MSFT , I have the same problem with my data. I've scanned everything but I can't see my stored procedures and in the lineage section, there are no links. Thanks in advance

    0 comments No comments