Share Data Products from SAP® Business Data Cloud to Snowflake¶

SAP® Snowflake¶

As part of the provisioning process for a new SAP® Snowflake account, a catalog integration named SAP_BDC_INTEGRATION is automatically created in the SAP® Snowflake account and enrolled with SAP® Business Data Cloud. You can use this catalog integration to share data from SAP® Business Data Cloud or optionally create an additional catalog integration as described in the following section.

SAP® Business Data Cloud Connect for Snowflake¶

For existing Snowflake accounts that integrate with SAP® Business Data Cloud Connect for Snowflake, users need to first create and enroll a catalog integration prior to sharing data from SAP® Business Data Cloud to Snowflake.

To create and review the catalog integration, run the following command:

1. Create a Catalog Integration and enroll 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 Link from SAP BDC>'
      ACCESS_DELEGATION_MODE = VENDED_CREDENTIALS
    )
    ENABLED = TRUE
    COMMENT = 'My SAP BDC catalog integration';

Copy

1. Verify the catalog integration was created successfully>

   SHOW CATALOG INTEGRATIONS;
   

   Copy

Which should produce results similar to:

MY_SAP_BDC_CATALOG_INT     CATALOG CATALOG true    2025-12-10 18:27:45.181 -0800

In SAP® BDC, Choose Data Products to share with Snowflake¶

In order to search for and share data products with Snowflake, the user must use the central SAP Business Data Cloud catalog and have a global role that grants them the following privileges: - BDC Data Packages (read) - To access SAP Business Data Cloud. - Catalog Asset (read) - To access the catalog and view objects in the Assets and Data Products collections. - Cloud Data Product (share) - To share data products to target systems.

Users with these privileges can share data products from the SAP Business Data Cloud catalog with the desired SAP Snowflake account to make them available for consumption to specific roles in that account.

To share data products with Snowflake:

1. In the central SAP Business Data Cloud catalog, select data products to share with an SAP Snowflake account

2. From Catalog & Marketplace, search for (or use filters) to find the data products to be shared

3. From the search results, click the Share button in the data product to be shared (for example customer) to open the Manage Share Access dialog

4. In the Overview section, learn more about the data product by reviewing its details and available objects.

5. Under Target System:

   1. Choose the Snowflake account with the enrolled catalog integration to share with (if there is more than one).

   2. Click the Update button

A message appears letting you know that the share process has started. After the process finishes, a notification appears letting you know the result.

Create a Catalog Linked Database for shared Data Products¶

If you are using SAP® Snowflake, you can create a catalog linked database for shared Data Products.

1. List shares available from SAP® Business Data Cloud for the enrolled catalog integration:

   SELECT SYSTEM$SAP_BDC_LIST_SHARES('MY_SAP_BDC_CATALOG_INT');
   

   Copy

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:customer:v:1",
 "usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:entryviewjournalentry:v:1"]

Each element represents a shared Data Product. The highlighted text is an example of the name of the Data Product shared from SAP® Business Data Cloud to Snowflake with the enrolled catalog integration MY_SAP_BDC_CATALOG_INT.

1. Create a catalog linked database for the shared data products:

   CREATE OR REPLACE DATABASE CUSTOMER
      LINKED_CATALOG = (
        CATALOG = MY_SAP_BDC_CATALOG_INT,
        CATALOG_NAME = 'shares/usid:0c7785a5-951f-4f3c-9f9f-9df3a5524d84:ns:sap.s4com:r:customer:v:1',
        ALLOWED_WRITE_OPERATIONS = NONE
      );
   

   Copy

   Which should produce results similar to:

   Database CUSTOMER successfully created.
   

2. Confirm link status

SELECT SYSTEM$CATALOG_LINK_STATUS('CUSTOMER');

Copy

Which should produce results similar to:

{"failureDetails":[],"executionState":"RUNNING","lastLinkAttemptStartTime":"2025-12-17T21:13:29.611Z"}

In this example, we only created a single catalog linked database CUSTOMER. You can create additional catalog linked databases depending on Data Products shared with the enrolled catalog integration in the Snowflake account.

Next steps¶

After sharing data products, you can Explore Data from SAP® Business Data Cloud the data that has been shared with Snowflake.