SAP Knowledge Base Article - Public

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

Symptom

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." 

Environment

SAP Datasphere

Reproducing the Issue

  1. Configure a data flow to connect to an Azure Synapse serverless SQL endpoint.
  2. Attempt to browse or pull a table from a schema.
  3. Observe the error: "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."

Cause

The SQL metadata function object_schema_name is not supported in DS-Lite, causing metadata retrieval to fail. Azure Synapse SQL endpoints are not currently supported in SAP Datasphere/Data Intelligence; only Microsoft Azure SQL Database is supported via the Microsoft SQL Server connection type.

Resolution

  • Connect to a supported source: use Microsoft Azure SQL Database or Microsoft SQL Server connection type and re-run the data flow. 
  • If Azure Synapse SQL endpoint connectivity is required, submit an enhancement request and track it through the SAP Influence portal

See Also

Keywords

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

Product

SAP Datasphere all versions