Skip to main content

Grant SAP Business Data Cloud (BDC) recipients access to Delta Sharing data shares

This page explains how to share data assets with your SAP Business Data Cloud (BDC) recipient.

Requirements

  • A connection exists between your Databricks workspace and the desired SAP BDC account. See Create and manage the SAP Business Data Cloud (BDC) connector.

  • You have a share object with data assets to share with your SAP BDC recipient. See Create and manage shares for Delta Sharing.

    • Any data asset you share must have a primary key or identity column. You can add a primary key constraint before sharing the table or define a primary key in the CSN schema when sharing to SAP BDC.
    note

    You cannot share tables with history.

  • You meet one of the following requirements:

    • You are the share owner and have the USE RECIPIENT privilege.
    • You have the USE RECIPIENT, USE SHARE, and SET SHARE PERMISSION privileges.

Share Delta Sharing data shares with SAP BDC recipients

To share data assets with an SAP BDC recipient, do the following

  1. In your Databricks workspace, click Data icon. Catalog.

  2. At the top of the Catalog pane, click the Gear icon. gear icon and select Delta Sharing.

    Alternatively, from the Quick access page, click the Delta Sharing > button.

  3. On the Shared by me tab, click Recipients.

  4. Select the desired SAP BDC recipient. This recipient is automatically created after the connection with SAP BDC is established.

  5. Click Grant share in the upper-right corner.

  6. Select which shares the SAP BDC recipient should have access to.

  7. Click Grant.

  8. Run the notebook that uses the SAP BDC SDK to describe the share in Core Schema Notation so SAP BDC users can read it. To learn more about notebooks on Databricks, see Basic editing in Databricks notebooks.

    Publish data share to SAP BDC notebook

    Open notebook in new tab

Additional resources