The most secure method for protecting your data in Synapse is through the use of Azure AD. To query data stored in the data lake through a Synapse Serverless endpoint, the AD account must possess the necessary permissions for both […]
It looks like the rights of the SQL Admin user in the database created by Synapse Link for Database have recently been changed. Prior to 2023, the SQL Admin user account has able to query all the external tables created […]
I previously wrote a couple of blog posts (post1 and post2) suggesting two different ways to access your Dataverse metadata in Synapse. Both of these techniques are now redundant as Microsoft announced in May 2022 that the Dataverse metadata is […]
Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse […]
Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here On November 23 Microsft announced that DES (Data Export Services) will be deprecated and will […]