ADF Azure SQL DB to Snowflake Lineage purview

Antony.Palackan 1 Reputation point
2022-11-07T12:16:56.493+00:00

I have a scenario to show lineage in Purview between 3 systems (raw files, Azure SQL DB & Snwoflake). I used Azure Data factory to load data between these 3 systems
as shown below.
Raw Files -> Azure SQL DB -> Snowflake

I am able to properly get the lineage from raw files to Azure SQL DB but no lineage from Azure SQL DB to Snowflake even though data load is happening correctly.

Error message is as below:
Snowflake store not supported for lineage reporting

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,010 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
    2022-11-08T22:00:52.147+00:00

    Hello @Antony.Palackan ,
    Thanks for the question and using MS Q&A platform.

    As we understand the ask here is enable linage for Azure SQL DB ( where this DB is used as sinck for ADF ), please do let us know if its not accurate.
    This scenario is as of now not supported as it is called out here : https://learn.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#supported-capabilities

    258474-image.png

    Please feel free to ask this feature in Purview by logging the ask here : https://feedback.azure.com/d365community/forum/82d7bddb-fb24-ec11-b6e6-000d3a4f07b8

    Please do let me if you have any queries.
    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators