Export query result in SQL on-demand to external storage in Synapse Studio
Currently synapse workspace doesn't support to create a linked service specifically for SQL on-demand. Thus since we were unable to create a dataset for it without linked service, we cannot leverage the copy activity in ADF pipeline to export data in SQL on-demand to storage account.
The current workaround for this issue is to create a linked service as Azure SQL database and manually add SQL on-demand endpoint as the server name.
However we were wondering if it is possible to add a type of linked service specifically for SQL on-demand, or if it is possible to add a note in the public documentation so that everyone is able to know this workaround.
Any suggestions will be appreciated! Thank you in advance!