Categories:: System functions (System Information)

SYSTEM$SAP_BDC_LIST_SHARES¶

列出通过已注册的目录集成由 SAP® Business Data Cloud 共享的数据产品。

See also:: CREATE CATALOG INTEGRATION (SAP® Business Data Cloud)

语法

SYSTEM$SAP_BDC_LIST_SHARES( '<catalog_integration_name>' )

实参

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

返回一个 JSON 格式的字符串数组，其中列出了通过已注册目录集成由 SAP® Business Data Cloud 共享的数据产品。

JSON 格式化字符串具有以下结构：

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

访问控制要求

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

权限	对象	备注
USAGE	集成（目录）

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.

示例

列出当前通过已注册目录集成从 SAP® BDC 共享到 Snowflake 的数据产品。请注意，当共享新的数据产品时，它们会自动出现在返回值中。当之前共享的数据产品被取消共享时，它们会自动从返回值中移除。

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

其产生的结果应类似于：

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