Unable to get Azure Purview Lineage extraction working

Hicham 46 Reputation points
2022-04-26T14:03:08.733+00:00

In order to get the Lineage Extraction (preview) feature working when running a scan, I had been informed that I need to execute the ''Prerequisites for setting up scan with Lineage extraction" from the following document under ''Lineage(Preview)'': https://learn.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#lineagepreview

![196644-scan-probleem.png][1]

Only, when running the query, I keep getting the following error message. Does anyone happen to have any idea what this is due to? I assume I need to put the name of my purview account in the next query. So the query:

Create user

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator
    2022-04-26T20:24:17.637+00:00

    Hi, @Hicham Thanks for the ask and for using the Microsoft Q&A platform.
    As we understand the ask here is you are trying to create a user with a purview account based on the documentation provided and you are facing an issue.

    As per the error message "connections established with Active Directory accounts can create other Active Directory users" I want to check if your Azure SQL database has Azure active directory permissions.

    I have created it with AAD and it worked fine.
    196686-image.png

    From the scan please select MSI as mentioned in the document
    196687-image.png

    Please let me know if you find any issues.

    Regards
    Geetha


1 additional answer

Sort by: Most helpful
  1. Priyanka Duggal 1 Reputation point
    2023-04-03T12:14:42.14+00:00

    I have similar issue . I am unable to view lineage for my snowflake account.

    User's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.