Created data flow to extract data from Synapse. Says I don't have proper access. Any suggestions?

Richard Adams 0 Reputation points
2023-06-20T02:00:28.14+00:00

What worked:
(1) created linked services to Azure Blob Storage and Azure Synapse Analytics
(2) created datasets for the source and the sink.
(3) created a pipeline using the ingest feature to read data from the Synapse source, stage in the blob storage, and copy the data to the Synapse sink.

What did not work:
created a data flow to read data from the Synapse source, stage in the blob storage, and copy the data to the Synapse sink. Validation worked fine. I dragged and dropped the data flow onto the pipeline canvas. Validated ok but died on debug.

Why this is confusing:
The error was "user does not have access to perform this action". However: (1) I have Contributor access and (2) my access was sufficient when I used the ingest feature.

Additional Info:
To test the access level thing, I changed the linked services from an account with contributor access to the admin. The error now changed to "please create a master key".

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,064 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,172 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,211 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 31,196 Reputation points Microsoft Employee
    2023-06-21T00:46:46.56+00:00

    Hello Richard Adams,

    Welcome to the MS Q&A platform.

    Are you using polybase here? If yes, a one-time action needed to create master key to make polybase work at database level.

    Please see the below document:
    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/load-data-from-azure-blob-storage-using-copy#create-external-tables-for-the-sample-data

    I hope this helps.

    1 person found this answer helpful.
    0 comments No comments

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.