Perform Prerequisites for Sharing Warehouse Tables with Oracle Cloud Infrastructure Object Storage (Preview)

Sharing warehouse tables with Object Storage first requires you to perform prerequisite steps in the Oracle Cloud Infrastructure Console, before moving on to creating a connection in Oracle Fusion Data Intelligence to access and share data and metadata files in your object storage buckets.

1. In Oracle Cloud Infrastructure Console, create a data bucket for the Oracle Object Storage Service Targets connector as the destination to access the shared warehouse tables.
   You can either use the same bucket for Delta, Iceberg, and Change Data formats or have three separate buckets; one for Delta format, second for Iceberg format, and a third for Change Data.

   See Creating an Object Storage Bucket.

2. Define this policy for Oracle Fusion Data Intelligence's resource principal (fawbeyondpublish) in the root compartment of your tenancy to enable Oracle Fusion Data Intelligence to create, update, and delete objects in your object storage bucket:

   allow any-user
      to { BUCKET_INSPECT, BUCKET_READ, OBJECT_INSPECT, OBJECT_READ,
           OBJECT_OVERWRITE, OBJECT_CREATE, OBJECT_DELETE }
      in tenancy
      where all {
           request.principal.type = 'fawbeyondpublish',
           target.compartment.id = request.principal.compartment.id,
           target.bucket.name='BUCKET_NAME_CREATED_BY_CUSTOMER'
      }
   

   Note:

   The only element of this policy that you should modify is to replace 'YOUR_TARGET_BUCKET_NAME' with the name of your bucket created in step 1. Don't change any other elements in the policy.

   You can use the same bucket for Delta, Iceberg, and Change Data format, but if you have three separate buckets (one for Delta format, second for Iceberg format, and a third for Change Data, duplicate the above policy, one per bucket name. Don't modify any parts of the policies other than the unique bucket names.

   See Managing Policies for more information.