Schema

Schema in data catalogs are constructs to organize data.

Catalogs are logical containers for schema, which are also referred to as databases. Schema can contain tables, which contain structured data, and volumes, which contain unstructured data.

A default schema is created in all standard catalogs created in the Master Catalog. To create additional schema, see Create a Schema.

You can manage permissions to control who has access to your schema. For more information, see Schema Permissions.

Master catalog's default catalog, which is called 'default', contains a reserved schema named oci_ai_models. If you have the requisite permissions on OCI Generative AI models in the region, the model is displayed in the oci_ai_models schema and you can drag and drop the models onto a notebook to auto-generate code for batch inference. For more information, see OCI Generative AI (Pretrained Foundation Models).

Note:

You can't change the name of a schema in a standard catalog.

Create a Schema

You can create schema in catalogs you own or are shared with you.

  1. Navigate to the catalog you want to create a schema for.
  2. On the Schema tab, click Create schema icon Create Schema.
  3. Provide a name and description for your schema and click Create.

View Schema Details

You can view schema information and resources from the schema Details tab.

  1. On the home page, click Master Catalog.
  2. Navigate to your schema, then click the Details tab.

    Schema page with Details tab highlighted and details displayed

  3. Click Details.

Edit a Schema Description

You can edit the description for a schema to provide an updated summary of its contents.

  1. On the Home page, click Master Catalog.
  2. Next to the schema you want to change the description for, click Actions three dot icon Actions and click Edit Description.
  3. Provide a new description. Click Save.

Delete a Schema

You can delete schema and all their metadata and AI Data Platform-managed data when they are no longer needed.

Deleting a schema also deletes all metadata and AI Data Platform-managed data in managed tables and managed volume associated with that schema. Make sure you backup or move any data you want to retain to another location before deleting a schema.
  1. On the Home page, click Master catalog.
  2. Next to the schema you want to delete, click Actions three dot icon Actions and click Delete.
  3. Select Yes, force delete all associated data and metadata.

    Delete schema prompt is displayed with Yes, force delete all associated data and metadata selected and highlighted

  4. Click Delete.