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.
Read Synapse Data - Azure Dataflow
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 48%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E3%3C/text%3E%3C/svg%3E)
39861377
141
Reputation points
Hi, I'm trying to read data from a synapse table but it's throwing me an error. I've used this method before but never faced such issue.
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
-
Vinodh247-1375 44,806 Reputation points Volunteer Moderator2023-04-16T06:24:10.96+00:00 The error has nothing to do with synapse or dataflow, the error is related to database master key, following the above answer from @Bhargava-MSFT will solve the issue.
-
39861377 141 Reputation points
2023-04-18T06:15:33.2966667+00:00 @Bhargava-MSFT @Vinodh247-1375 Why is it that I'm able to see the data in dataset preview and also perform write operations, but not able to read the data? Is it a necessary step to create master key?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator2023-04-19T23:29:06.8266667+00:00 Hello 39861377, I believe, in the dataset preview the master key may not required(But I haven't test this yet). But as per your error message, please create master key in the DB and see if it fixes your issue. Please test this and let us know if you still have any issues.
-
39861377 141 Reputation points
2023-04-20T04:45:24.82+00:00 Hi @Bhargava-MSFT I used the following command to generate the master key and it solved the issue. Thanks
ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = ''; -
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2023-04-20T18:54:02.3966667+00:00 Hello 39861377, Glad to know that you resolved the issue. I have updated the answer to re-create the database master key(as this resolved your issue). Please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more