When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse data lake as CSV files. A database with external tables is created automatically in the Serverless SQL pool providing access to the data in the CSV files. You can then connect to the serverless SQL pool and use SQL to query the data. The tables in the serverless pool are in a raw state. … [Read more...] about Dataverse Metadata in Synapse
Dataverse
Synapse Link for Dataverse – Option Sets
On November 23 Microsft announced that DES (Data Export Services) will be deprecated and will reach end of life in November 2022. Microsoft is recommending that customers use Azure Synapse Link for Dataverse instead. DES has been around for a number of years and generally works well pushing Dataverse data to SQL Azure or to on-premise SQL Server using a data gateway. Azure … [Read more...] about Synapse Link for Dataverse – Option Sets
