3730562 - Data flow metadata retrieval fails with 'FUNCTION object_schema_name is not supported' when using Azure Synapse SQL endpoint

An error occurs when attempting to pull a table from a schema using an Azure Synapse SQL (serverless) endpoint in a data flow. Error message: "Get metadata request could not be performed due to an error returned by DS-Lite (MDS): FUNCTION object_schema_name is not supported. Statement(s) could not be prepared." 

SAP Datasphere

object_schema_name, FUNCTION object_schema_name is not supported, DS-Lite, Get metadata request could not be performed, Statement(s) could not be prepared, Datasphere data flow, Azure Synapse SQL, serverless endpoint, metadata retrieval error, table pull failure, connector not supported, Azure SQL Database, Microsoft SQL Server connection, SDI DP Agent, data federation , KBA , DS-DI-DF , Data Flows , Problem