Share and Consume Data with Data Marketplace in Autonomous AI Database

Use Data Marketplace in Data Studio to discover, publish, share, load, link, and query datasets for Oracle Autonomous AI Database. Data Marketplace lets data producers publish datasets as marketplace listings and lets consumers find datasets available to them based on listing configuration and their access profile. A dataset is a unit of shared data in Autonomous AI Database Marketplace. Producers can create datasets that include tables and views, and a listing is a published set of tables made available for consumption through the marketplace.

Data Marketplace is part of the Data Studio suite of tools. It is intended for data scientists and business users who need to access curated datasets, integrate shared data with existing database data, and use Data Studio AI capabilities such as language detection, sentiment analysis, and key phrase extraction.

This topic provides an entry point for understanding when and how to use Data Marketplace with Autonomous AI Database. For complete reference, see the Data Studio documentation.

When to use Data Marketplace

Use Data Marketplace when you want to make datasets discoverable and reusable across Autonomous AI Database users, databases, compartments, tenancies, pools, or explicitly authorized database instances.

For example, use it to:

• Publish datasets as a producer so intended consumers can discover and consume selected database tables through marketplace listings. Producers can configure metadata such as namespace, dataset name, description, owner email address, documentation URL, tags, sharing target, sample data, and statistics.
• Discover datasets as a consumer by browsing or searching available marketplace listings. Consumers can review listing details, owner information, tags, descriptions, links, sample data, and profile statistics before using the data.
• Load or link shared data from a marketplace listing. From a listing, consumers can open Data Load or Data Link and create external tables derived from selected dataset tables.
• Analyze marketplace data by opening the associated table in the Data Analysis tool, where users can query the dataset and create analytic views where applicable.
• Automate marketplace operations with the DBMS_DATAMART package, which supports operations such as registering objects, requesting access, granting access, revoking access, unregistering listings, listing datasets, and updating registrations.

Use other Autonomous AI Database data-sharing or data-movement mechanisms when you do not need marketplace discovery, listing metadata, sample-data preview, profile statistics, or producer-consumer workflows.

How Data Marketplace works with Autonomous AI Database

Data Marketplace runs from Database Actions for Autonomous AI Database. Database Actions is bundled with each Autonomous AI Database instance and provides development tools, data tools, administration, monitoring, and download features. Data Studio tools are available from the Database Actions Launchpad.

A producer publishes a table as a marketplace listing. The listing can include a namespace, name, description, owner email address, link, tags, sample data, and statistics. The producer also chooses who can access the registered table, such as users in the same tenancy, compartment, region, pool, or specific Autonomous AI Database instances identified by OCID, depending on the available configuration.

A consumer opens Data Marketplace, selects a listing, reviews the details, sample data, and profile statistics, and then uses the listing with Data Load, Data Link, or Data Analysis. Data Load and Data Link let the consumer create external tables from selected dataset tables, while Query opens the associated table in Data Analysis.

For non-ADMIN users, access to Database Actions tools depends on the database roles and permissions granted by an administrator. Autonomous AI Database hides Database Actions cards for non-ADMIN users who do not have the required permissions. Data Marketplace also requires Marketplace read access, and other built-in Data Studio tools require the DWROLE role.

Before you begin

Before using Data Marketplace, verify that you have the required access and configuration.

• To view marketplace listings, an ADMIN user must enable Data Marketplace read access for the user, or access must be enabled from the Marketplace tab in Data Studio Settings. If Data Marketplace is not enabled, the Marketplace page is empty.
• To publish datasets, an ADMIN user must grant the required Cloud Link registration access. If the required registration access is not granted, the publish operation raises an exception.
• Use Data Studio Settings to configure Marketplace options, including restricted listings, publish scope, read access, SMTP configuration for data sharing, and provider identity information.
• To use AI-generated marketplace descriptions and tags, configure an AI profile in Data Studio Settings. The AI profile can be used to generate Marketplace dataset descriptions and tags.

See Access Data Marketplace Tool for prerequisites and steps to open the Data Marketplace page from Data Studio.

Open Data Marketplace

To open Data Marketplace:

1. Open Database Actions for your Autonomous AI Database.
2. Select the Data Studio tab.
3. Select Data Marketplace.
4. Use the Datasets tab to browse shared datasets, or use My Published Datasets to view datasets that you have published.
5. Search or filter marketplace datasets by name or tag, select a dataset card to review details, and then choose whether to load, link, or query the dataset.

What you can do in Data Marketplace

• Datasets: Browse datasets shared with you and open dataset cards to review listing details, sample data, and profile statistics.
• My Published Datasets: View datasets you have published and unregister listings when needed.
• Search Marketplace: Search for datasets by name or browse by dataset tags.

• Publish Table: Publish a table as a marketplace listing, configure listing metadata, select the target audience, and preview the listing before publishing.

  See Publish Listings to Marketplace for information about producer workflow for publishing a table, configuring listing metadata, choosing the sharing target, and previewing the listing.

• Sample Data and Profile: Let consumers preview dataset columns and review statistical profile information such as row count, column count, minimum, maximum, distinct, null values, and histogram-based summaries.

  See Consume Dataset to learn more about sample data and profile statistics.

• Data Load and Data Link: Open Data Load or Data Link from a listing and create external tables from selected dataset tables.

  See Consume Dataset to learn more about using Data Load and Data Link with a dataset.

• Query: Open the associated table in Data Analysis to query the data and create analytic views where applicable.

  See Consume Dataset for guidance with analyzing data with a dataset.

• DBMS_DATAMART APIs: Register datasets, request access, grant or revoke access, unregister listings, list datasets, get stock image URLs, get reserved namespaces, and update registrations.

  See DBMS_DATAMART Package Reference for reference.