Database Schemas

A Database Schema is a container within a Database. It holds Tables and sits between Database and Table in the hierarchy.

Entity schema follows the OpenMetadata Standard.

Entity Hierarchy

Database Schemas sit between Databases and Tables in the hierarchy:

DatabaseService
└── Database
    └── DatabaseSchema (this page)
        └── Table

When you set an owner or domain on a Database Schema, it is inherited by all child tables. Schemas also inherit from their parent database.

Method	Endpoint	Description
`PUT`	`/v1/databaseSchemas`	Create or update a database schema
`POST`	`/v1/databaseSchemas`	Create a database schema (POST variant)
`GET`	`/v1/databaseSchemas`	List database schemas
`GET`	`/v1/databaseSchemas/{id}`	Get by ID
`GET`	`/v1/databaseSchemas/name/{fqn}`	Get by FQN
`PATCH`	`/v1/databaseSchemas/{id}`	Update by ID
`PATCH`	`/v1/databaseSchemas/name/{fqn}`	Update by name
`DELETE`	`/v1/databaseSchemas/{id}`	Delete by ID
`DELETE`	`/v1/databaseSchemas/name/{fqn}`	Delete by name
`PUT`	`/v1/databaseSchemas/restore`	Restore soft-deleted schema
`GET`	`/v1/databaseSchemas/{id}/versions`	List versions
`GET`	`/v1/databaseSchemas/{id}/versions/{version}`	Get specific version
`GET`	`/v1/databaseSchemas/name/{fqn}/export`	Export to CSV
`GET`	`/v1/databaseSchemas/name/{fqn}/exportAsync`	Export to CSV (async)
`PUT`	`/v1/databaseSchemas/name/{fqn}/import`	Import from CSV
`PUT`	`/v1/databaseSchemas/name/{fqn}/importAsync`	Import from CSV (async)
`PUT`	`/v1/databaseSchemas/{id}/followers`	Add follower
`DELETE`	`/v1/databaseSchemas/{id}/followers/{userId}`	Remove follower
`PUT`	`/v1/databaseSchemas/{id}/vote`	Add/update vote
`GET`	`/v1/databaseSchemas/{id}/profilerConfig`	Get profiler config
`PUT`	`/v1/databaseSchemas/{id}/profilerConfig`	Set profiler config
`DELETE`	`/v1/databaseSchemas/{id}/profilerConfig`	Delete profiler config