When connecting to Synapse Serverless as an ODX data source using CDS SQL Server provider, the Synch and Transfer tasks, Preview and transfer to MDW work as expected.
This article describes an issue when using a Business Unit data source.
You are attempting to connect to Synapse Serverless as a Business Unit data source using a SQL Server provider. When synchronizing, you receive the following error:
FUNCTION 'OBJECT_SCHEMA_NAME' is not supported.
Module: .Net SqlClient Data Provider
Also, if the source view is modified (e.g. exclude some fields), the existing table in the Business Unit is not updated properly.
The problem is due to extracting Synonyms. By default, it is turned ON in data source settings.
Go to SQL Server data source settings
Click on "Data Extraction Settings"
Uncheck "Extract synonyms".
Sync and Preview should now work without error.
Also, if you remove some fields from the source view, it will reflect those changes in your data source and staging table as well.
Another workaround is to use ADO.Net SqlClient provider for your data source. You may see a minor error when previewing rows in Data Selection, but transfer to stage (Deploy and Execute) works OK.
Also, if you remove some fields from the source view, the next "Synchronize Data Source" will reflect those changes in your data source and staging table as well.