Share Warehouse Tables with External Data Stores (Preview)
You can share the warehouse data with external data stores alongside Oracle Autonomous AI Lakehouse in Oracle Fusion Data Intelligence. This enables you to enhance your analytics by combining data from Oracle Fusion Data Intelligence with data from your external data stores.
If you've an analytics stack built on these external data stores, such as data lakes or third-party data warehouses, you can integrate this with the curated data from Oracle Fusion Data Intelligence to improve your analytics.
This capability shares data simultaneously with both Oracle Fusion Data Intelligence and the external data store, supporting full or incremental data. Currently, the external target data store that you can share with is Oracle Cloud Infrastructure Object Storage. For Object Storage, this process shares data in the DELTA or ICEBERG table formats and parquet file formats.
- Perform the applicable prerequisite steps.
- Create a connection to the target data store using Manage Connections tile in Data Configuration tile.
- Use the Data Share tile to select the desired warehouse tables and the target connection.
When you share the selected warehouse tables, the Data Share process prepares the data and based on the setup for target data stores, it then pushes the data to the target data bucket in your tenancy. The first time you share, the process loads complete data from the Oracle Fusion Data Intelligence warehouse for the selected datasets into the target data buckets. It automatically refreshes the subsequent incremental and frequently refreshed data on all the configured targets. To share the frequently refreshed data to external data stores, you must use Frequent Data Refresh V2 capability and enable Data Share for Frequent Data Refresh in the Pipeline Features section under the Preview Features tab on the Enable Features page. You can add or remove datasets or targets and issue the publish command at any time. After sharing the warehouse tables, you can remove individual tables using the Remove action for the applicable table or remove tables in bulk using the Delete Connections button that gets enabled after you select multiple tables. These options remove the selected warehouse tables from the previously specified targets.
Note:
Deletion of modules can update the data share definition. For example, if you delete functional areas, data augmentations, custom applications, target data model upgrade, or deploy and undeploy custom applications, the system deletes the tables that you had selected for these modules from the data share process.