CREATE CATALOG INTEGRATION (SAP® Business Data Cloud)

在账户中创建新的目录集成，或替换现有的目录集成，以便使 SAP® Business Data Cloud 能够与 SAP® Business Data Cloud 对象存储中管理的 SAP® 数据产品进行交互。

See also:

ALTER CATALOG INTEGRATION , DROP CATALOG INTEGRATION , SHOW CATALOG INTEGRATIONS, DESCRIBE CATALOG INTEGRATION

语法

CREATE [ OR REPLACE ] CATALOG INTEGRATION [ IF NOT EXISTS ] <name>
  CATALOG_SOURCE = SAP_BDC
  TABLE_FORMAT = DELTA
  REST_CONFIG = (
    restConfigParams
  )
  ENABLED = { TRUE | FALSE }
  [ REFRESH_INTERVAL_SECONDS = <value> ]
  [ COMMENT = '<string_literal>' ]

其中：

restConfigParams ::=

SAP_BDC_INVITATION_LINK = '<Invitation Link from SAP BDC>'
[ ACCESS_DELEGATION_MODE = { VENDED_CREDENTIALS } ]

参数

name

用于指定目录集成的标识符（名称）的字符串；在账户中必须唯一。

In addition, the identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (for example, "My object"). Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

CATALOG_SOURCE = SAP_BDC

指定目录源为 SAP® Business Data Cloud。

TABLE_FORMAT = DELTA

将 DELTA 指定为目录提供的表格式。

ENABLED = { TRUE | FALSE }

指定目录集成是否可用于 Iceberg 表。

  • TRUE allows users to create new Iceberg tables that reference this integration.
  • FALSE prevents users from creating new Iceberg tables that reference this integration.

The value is case-insensitive.

The default is TRUE.

REFRESH_INTERVAL_SECONDS = <value>

指定 Snowflake 在自动刷新时，两次轮询 SAP® Business Data Cloud 目录以获取元数据更新之间的等待秒数。

值：30 到 86,400（含）

默认值：30 秒

COMMENT = 'string_literal'

字符串（字面量），用于指定集成注释。

默认：无值

REST 配置参数 (restConfigParams)

ACCESS_DELEGATION_MODE = { VENDED_CREDENTIALS }

指定从 SAP® Business Data Cloud 访问表文件时使用的访问委派模式。唯一支持的选项是 VENDED_CREDENTIALS。

SAP_BDC_INVITATION_LINK = { VENDED_CREDENTIALS }

Specifies the Invitation Link obtained from SAP 4 Me (https://me.sap.com/) as documented in Provisioning SAP Business Data Cloud Connect (https://help.sap.com/docs/business-data-cloud/administering-sap-business-data-cloud/provision-sap-business-data-cloud-connector-for-supported-external-systems)

访问控制要求

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

权限对象备注
CREATE INTEGRATION账户Only the ACCOUNTADMIN role has this privilege by default. The privilege can be granted to additional roles as needed.

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.

示例

The following example creates a catalog integration and enrolls it with SAP® Business Data Cloud.

CREATE OR REPLACE CATALOG INTEGRATION MY_SAP_BDC_CATALOG_INT
  CATALOG_SOURCE = SAP_BDC
  TABLE_FORMAT = DELTA
  REST_CONFIG = (
    SAP_BDC_INVITATION_LINK = '<Invitation URL from SAP BDC>'
    ACCESS_DELEGATION_MODE = VENDED_CREDENTIALS
  )
  ENABLED = TRUE
  COMMENT = 'My SAP BDC catalog integration'
  ;