Set Up SAP® BDC Connect for Snowflake Zerocopy Connector

Note

The Zerocopy Connector is subject to the SAP® BDC Connect for Snowflake Terms.

The steps to share Data Products from SAP® BDC to SAP® Snowflake accounts and existing Snowflake accounts that use the SAP® BDC Connect for Snowflake are exactly the same.

This topic describes how to create and manage a Zerocopy Connector for SAP® BDC Connect for Snowflake on the Snowflake side. For the SAP® side setup, see SAP® Snowflake or SAP® BDC Connect for Snowflake.

For the privileges required for each operation, see SAP® BDC Connect for Snowflake Zerocopy Connector — Security and Privileges.

Prerequisites

Before creating a Zerocopy Connector:

  • An ORGADMIN must accept the SAP® BDC Connect for Snowflake Terms. This only needs to be done once per Snowflake organization. Terms of Service cannot be self-revoked — contact Snowflake support and legal to revoke them.

    To accept the SAP® BDC Connect for Snowflake Terms in Snowsight:

    1. Sign in to Snowflake as a user with the ORGADMIN role.
    2. In the navigation menu, select Admin » Terms.
    3. In the Snowflake Marketplace section, next to SAP® BDC Connect for Snowflake Terms, select Review.
    4. Select Acknowledge & Continue.

  • Complete the SAP® side setup described in SAP® Snowflake or SAP® BDC Connect for Snowflake.

  • The role used to create the connector must have CREATE ZEROCOPY CONNECTOR on the target schema. By default, the owner role of a schema has this privilege.

Create a Database and Schema

A Zerocopy Connector is a schema-level object. Before creating one, ensure you have a target database and schema, or create new ones. For reference, see CREATE DATABASE and CREATE SCHEMA.

CREATE DATABASE IF NOT EXISTS my_db;

CREATE SCHEMA IF NOT EXISTS my_db.my_schema;

Create a Zerocopy Connector

A Zerocopy Connector is a schema-level object. You can specify a fully qualified name (<db>.<schema>.<connector>), a partially qualified name, or a plain name when the database and schema are set in the current session context.

CREATE [ OR REPLACE ] ZEROCOPY CONNECTOR [ IF NOT EXISTS ] <name>
  PARTNER = SAP_BDC;
CREATE ZEROCOPY CONNECTOR IF NOT EXISTS my_db.my_schema.my_sap_connector
  PARTNER = SAP_BDC;

After creation, the connector is in NEW state. No connection is established until you run ALTER ... CONNECT.

Enroll with SAP® BDC

Note

The connector must be in NEW, CONNECT_ERROR, or DISCONNECTED state. See for details.

ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  CONNECT WITH CONFIG = (
    INVITATION_LINK = '<Invitation Link from SAP BDC>'
  );

The connector immediately enters CONNECTING state while the connection is established asynchronously. Use DESC ZEROCOPY CONNECTOR to check the current state.

Verify Connector State

Use DESCRIBE to check the current state of a connector:

DESC ZEROCOPY CONNECTOR my_db.my_schema.my_sap_connector;

Output

ColumnDescription
nameName of the Zerocopy Connector.
partnerThe data partner (e.g., SAP_BDC).
configThe configuration of the data partner. For SAP® BDC, this contains the SAP® BDC Connector Endpoint.
statusCurrent connector state. See .
connection_errorError message if the connector is in CONNECT_ERROR or DISCONNECT_ERROR state; otherwise empty.
catalog_linked_databasesMounted catalog-linked databases that are visible to the current role.
share_backWhether sharing data from Snowflake to SAP® BDC is enabled for this connector.
sharesSnowflake data shares that are associated with this connector.
database_nameDatabase in which the connector resides.
schema_nameSchema in which the connector resides.
ownerRole that owns the connector.
owner_role_typeType of the owner role.
commentOptional comment set on the connector.
created_onTimestamp when the connector was created.
updated_onTimestamp when the connector was last updated.

To list all connectors visible to the current role:

SHOW ZEROCOPY CONNECTORS IN SCHEMA my_db.my_schema;

SHOW ZEROCOPY CONNECTORS IN DATABASE my_db;

SHOW ZEROCOPY CONNECTORS IN ACCOUNT;

Set Properties

You can set optional properties on a connector using ALTER ... SET:

-- Set a comment
ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  SET COMMENT = 'SAP BDC connector for sales data products';

-- Enabling share back allows publishing data from Snowflake to SAP BDC
ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  SET SHARE_BACK = TRUE;

To unset a property and restore its default value:

ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  UNSET COMMENT;

ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  UNSET SHARE_BACK;

Disconnect the Connector

Note

All catalog-linked databases created from the connector must be dropped before disconnecting. Share-back must be disabled before disconnecting. The connector must be in CONNECTED or DISCONNECT_ERROR state.

ALTER ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector
  DISCONNECT;

The connector immediately enters DISCONNECTING state while the connection is dropped asynchronously. When successful, it transitions to DISCONNECTED.

Drop the Connector

You can only drop a connector that is in NEW, CONNECT_ERROR, DISCONNECT_ERROR, or DISCONNECTED state. Zerocopy Connectors do not support UNDROP.

DROP ZEROCOPY CONNECTOR IF EXISTS my_db.my_schema.my_sap_connector;

Next Steps

Once the connector is in CONNECTED state, you can: