SYSTEM$SAP_BDC_LIST_SHARES¶

Syntax¶

SYSTEM$SAP_BDC_LIST_SHARES( '<catalog_integration_name>' )

Arguments¶

Required:

catalog_integration_name

Identifier for the catalog integration for Iceberg REST or Snowflake Open Catalog.

Returns¶

Returns a JSON-formatted array of strings that lists the Data Products shared by SAP® Business Data Cloud with the enrolled catalog integration.

The JSON-formatted string has the following structure:

[
  "usid:[guid]:ns:[namespace]:r:[dataproduct1]:v:[version]",
  "usid:[guid]:ns:[namespace]:r:[dataproduct2]:v:[version]",
]

Access control requirements¶

A role used to execute this operation must have the following privileges at a minimum:

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Examples¶

List the Data Products that currently shared from SAP® BDC to Snowflake with an enrolled catalog integration. Note that when new Data Products are shared, they are automatically available in the return value. When previously shared Data Products are unshared, they are automatically removed from the return value.

SELECT SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG('myCatalogIntegration');
SELECT SYSTEM$SAP_BDC_LIST_SHARES('my-sap-bdc-catalog-int');

Which should produce results similar to:

[“usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:cashflow:v:1”,

“usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:generalledgeraccount:v:1”, “usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:salesorder:v:1”, “usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:profitcenter:v:1”]

Where cashflow, generalledgeraccount, salesorder, and profitcenter are the Data Products shared from SAP® BDC to Snowflake with the enrolled catalog integration my-sap-bdc-catalog-int.