Data Studio in Autonomous Database (ADB) using delta sharing protocol

 

Introduction:

Data sharing lets you give the same data to multiple people. It helps you work with partners and create new partnerships. Oracle Data Sharing uses a standard method called the open delta sharing protocol. It has an easy-to-use API for sharing data. The data is shared in a format called Parquet. In this blog we will discuss and perform a quick demo using delta sharing.

Goals of the Open Delta Sharing Protocol

1. Share data without needing to copy it to another system.
2. Allow producers to control the data's state and version.
3. Serve as an open, cross-platform solution.
4. Support a variety of clients, including Power BI, Tableau, Apache Spark, pandas, and Java.
5. Offer flexibility to use preferred tools for BI, machine learning, and AI applications.
6. Ensure strong security, auditing, and governance.
7. Scale efficiently to handle massive data sets.

Pre-requisites to Enable Delta Sharing

1. Set up a user to manage data shares and their recipients.
2. Set up an Object Storage bucket for storing shared data.
3. Generate an OCI credential and link it to the Object Storage bucket.
4. Create, fill, and publish a data share.
5. Establish and authorize a data share recipient.
6. Create a data share consumer and access the data as a recipient.

Steps to Create a Provide Share

1. Login to ATP Database worksheet

2. Run following script to create user and grant roles

3. Log out from ADMIN user and login as share_provider

4. Create one object storage bucket to save the file and generate the RSA keys.

5. Define a Cloud Location and Create an OCI Credential

On the Database Actions | Launchpad page, click the Data Studio tab and then click the Data Load tab.

6. Load data and Make sure you are still logged in as the share_provider user. Click Oracle Database Actions | Launchpad in the banner to display the Database Actions Launchpad page.

Click the Data Studio tab, and then click the DATA SHARE tab.

7. Consume the Data Share

8. Create an External Table over the Shared Table

Expand the TRAINING_SHARE data share node to display the objects in it. Drag and drop the CUSTOMER_CONTACT shared table to add it to the data link job.

Click the Run Statement icon in the Toolbar. The query result is displayed in the Query Result tab.

Note: Few screenshots are taken from the Oracle Live Lab Tenancy.