
Hi,
We're testing Azure Synapse Link with the goal of replacing DES.
Azure Synapse Link successfully created all external tables in our Serverless SQL workspace except for 4 tables:
OptionsetMetadata
StateMetadata
StatusMetadata
TargetMetadata
The Data Lake directory folder for those tables is: dataverse-organisation-uid/OptionsetMetadata/
In this same folder, there are 5 CSV files :
In our SQL Serverless Lake database, we only have an external table GlobalOptionsetMetadata.
Where are the other 4 tables?
We also reconfigured everything by deleting Azure Synapse Link (along with all Datalake CSV files etc. as mentioned in the Microsoft document) and then recreating Azure Synapse Link.
The 4 external tables are still not present!
I think that Azure Synapse Link creation process forgot to create the 4 other tables:
Our Synapse Workspace is in North Europe.
Regards,
Denis