CREATE CATALOG INTEGRATION (SAP® Business Data Cloud)

Creates a new catalog integration in the account or replaces an existing catalog integration for SAP® Business Data Cloud to interact with SAP® Data Products managed in the SAP® Business Data Cloud object store.

See also:

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

Syntax

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>' ]
Copy

Where:

restConfigParams ::=

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

Parameters

name

String that specifies the identifier (name) for the catalog integration; must be unique in your account.

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

Specifies that the catalog source is SAP® Business Data Cloud.

TABLE_FORMAT = DELTA

Specifies DELTA as the table format supplied by the catalog.

ENABLED = { TRUE | FALSE }

Specifies whether the catalog integration is available to use for Iceberg tables.

  • TRUE allows users to create new Iceberg tables that reference this integration.

  • FALSE prevents users from creating new Iceberg tables that reference this integration.

REFRESH_INTERVAL_SECONDS = <value>

Specifies the number of seconds that Snowflake waits between attempts to poll SAP® Business Data Cloud catalog for metadata updates for automated refresh.

Values: 30 to 86400, inclusive

Default: 30 seconds

COMMENT = 'string_literal'

String (literal) that specifies a comment for the integration.

Default: No value

REST configuration parameters (restConfigParams)

ACCESS_DELEGATION_MODE = VENDED_CREDENTIALS

Specifies the access delegation mode to use for accessing table files from SAP® Business Data Cloud. The only option supported is VENDED_CREDENTIALS.

SAP_BDC_INVITATION_LINK = VENDED_CREDENTIALS

Specifies the Invitation Link obtained from SAP 4 Me as documented in Provisioning SAP Business Data Cloud Connect

Access control requirements

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

Privilege

Object

Notes

CREATE INTEGRATION

Account

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.

Examples

The following example creates catalog integration and enroll 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'
  ;
Copy
Language: English