POST /v1/databaseSchemas

from metadata.sdk import configure
from metadata.sdk.entities import DatabaseSchemas
from metadata.generated.schema.api.data.createDatabaseSchema import CreateDatabaseSchemaRequest

configure(
    host="https://your-company.getcollate.io/api",
    jwt_token="your-jwt-token"
)

request = CreateDatabaseSchemaRequest(
    name="public",
    displayName="Public Schema",
    database="snowflake_prod.analytics",
    description="Main public schema for analytics tables",
    retentionPeriod="P365D"
)

schema = DatabaseSchemas.create(request)
print(f"Created: {schema.fullyQualifiedName.root}")

import org.openmetadata.schema.entity.data.DatabaseSchema;
import org.openmetadata.sdk.fluent.builders.DatabaseSchemaBuilder;

DatabaseSchema schema = new DatabaseSchemaBuilder(client)
    .name("public")
    .databaseFQN("snowflake_prod.analytics")
    .create();

curl -X POST "{base_url}/api/v1/databaseSchemas" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "information_schema",
    "database": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service"
  }'

{
  "id": "f681432b-e66c-4096-a1cd-7771358c5323",
  "name": "information_schema",
  "fullyQualifiedName": "Glue.default.information_schema",
  "description": "This **mock** database contains tables related to the Glue service",
  "version": 0.1,
  "updatedAt": 1769982658171,
  "updatedBy": "admin",
  "href": "http://localhost:8585/api/v1/databaseSchemas/f681432b-e66c-4096-a1cd-7771358c5323",
  "owners": [],
  "service": {
    "id": "0fab117a-4c58-4ebb-9d42-beab0768fa8e",
    "type": "databaseService",
    "name": "Glue",
    "fullyQualifiedName": "Glue",
    "displayName": "Glue",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/services/databaseServices/0fab117a-4c58-4ebb-9d42-beab0768fa8e"
  },
  "serviceType": "Glue",
  "database": {
    "id": "9655ba5b-b8d7-419c-98f4-16b976692ad8",
    "type": "database",
    "name": "default",
    "fullyQualifiedName": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service",
    "displayName": "default",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/databases/9655ba5b-b8d7-419c-98f4-16b976692ad8"
  },
  "tags": [],
  "deleted": false,
  "sourceUrl": "https://www.glue.com/information_schema",
  "domains": [],
  "entityStatus": "Unprocessed"
}

POST

databaseSchemas

POST /v1/databaseSchemas

from metadata.sdk import configure
from metadata.sdk.entities import DatabaseSchemas
from metadata.generated.schema.api.data.createDatabaseSchema import CreateDatabaseSchemaRequest

configure(
    host="https://your-company.getcollate.io/api",
    jwt_token="your-jwt-token"
)

request = CreateDatabaseSchemaRequest(
    name="public",
    displayName="Public Schema",
    database="snowflake_prod.analytics",
    description="Main public schema for analytics tables",
    retentionPeriod="P365D"
)

schema = DatabaseSchemas.create(request)
print(f"Created: {schema.fullyQualifiedName.root}")

import org.openmetadata.schema.entity.data.DatabaseSchema;
import org.openmetadata.sdk.fluent.builders.DatabaseSchemaBuilder;

DatabaseSchema schema = new DatabaseSchemaBuilder(client)
    .name("public")
    .databaseFQN("snowflake_prod.analytics")
    .create();

curl -X POST "{base_url}/api/v1/databaseSchemas" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "information_schema",
    "database": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service"
  }'

{
  "id": "f681432b-e66c-4096-a1cd-7771358c5323",
  "name": "information_schema",
  "fullyQualifiedName": "Glue.default.information_schema",
  "description": "This **mock** database contains tables related to the Glue service",
  "version": 0.1,
  "updatedAt": 1769982658171,
  "updatedBy": "admin",
  "href": "http://localhost:8585/api/v1/databaseSchemas/f681432b-e66c-4096-a1cd-7771358c5323",
  "owners": [],
  "service": {
    "id": "0fab117a-4c58-4ebb-9d42-beab0768fa8e",
    "type": "databaseService",
    "name": "Glue",
    "fullyQualifiedName": "Glue",
    "displayName": "Glue",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/services/databaseServices/0fab117a-4c58-4ebb-9d42-beab0768fa8e"
  },
  "serviceType": "Glue",
  "database": {
    "id": "9655ba5b-b8d7-419c-98f4-16b976692ad8",
    "type": "database",
    "name": "default",
    "fullyQualifiedName": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service",
    "displayName": "default",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/databases/9655ba5b-b8d7-419c-98f4-16b976692ad8"
  },
  "tags": [],
  "deleted": false,
  "sourceUrl": "https://www.glue.com/information_schema",
  "domains": [],
  "entityStatus": "Unprocessed"
}

Create a Database Schema

Create a new database schema within a database.

Body Parameters

string

required

Name of the database schema. Must be unique within the parent database.

string

required

Fully qualified name of the parent Database.

string

Human-readable display name for the schema.

string

Description of the schema in Markdown format.

string

Data retention period in ISO 8601 duration format, for example P365D.

array

Array of owner references (users or teams) to assign to the schema.

Show properties

string

UUID of the owner entity.

string

Type of owner entity, for example user, team.

string

Name of the owner entity.

array

Fully qualified names of the domains to assign for governance purposes.

array

Array of classification tags to apply to the schema.

Show properties

string

required

Fully qualified name of the tag.

string

Type of label, for example Manual, Derived, Propagated.

string

State of the tag, for example Suggested, Confirmed.

object

Custom property values defined by your organization’s metadata schema.

POST /v1/databaseSchemas

from metadata.sdk import configure
from metadata.sdk.entities import DatabaseSchemas
from metadata.generated.schema.api.data.createDatabaseSchema import CreateDatabaseSchemaRequest

configure(
    host="https://your-company.getcollate.io/api",
    jwt_token="your-jwt-token"
)

request = CreateDatabaseSchemaRequest(
    name="public",
    displayName="Public Schema",
    database="snowflake_prod.analytics",
    description="Main public schema for analytics tables",
    retentionPeriod="P365D"
)

schema = DatabaseSchemas.create(request)
print(f"Created: {schema.fullyQualifiedName.root}")

import org.openmetadata.schema.entity.data.DatabaseSchema;
import org.openmetadata.sdk.fluent.builders.DatabaseSchemaBuilder;

DatabaseSchema schema = new DatabaseSchemaBuilder(client)
    .name("public")
    .databaseFQN("snowflake_prod.analytics")
    .create();

curl -X POST "{base_url}/api/v1/databaseSchemas" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "information_schema",
    "database": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service"
  }'

{
  "id": "f681432b-e66c-4096-a1cd-7771358c5323",
  "name": "information_schema",
  "fullyQualifiedName": "Glue.default.information_schema",
  "description": "This **mock** database contains tables related to the Glue service",
  "version": 0.1,
  "updatedAt": 1769982658171,
  "updatedBy": "admin",
  "href": "http://localhost:8585/api/v1/databaseSchemas/f681432b-e66c-4096-a1cd-7771358c5323",
  "owners": [],
  "service": {
    "id": "0fab117a-4c58-4ebb-9d42-beab0768fa8e",
    "type": "databaseService",
    "name": "Glue",
    "fullyQualifiedName": "Glue",
    "displayName": "Glue",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/services/databaseServices/0fab117a-4c58-4ebb-9d42-beab0768fa8e"
  },
  "serviceType": "Glue",
  "database": {
    "id": "9655ba5b-b8d7-419c-98f4-16b976692ad8",
    "type": "database",
    "name": "default",
    "fullyQualifiedName": "Glue.default",
    "description": "This **mock** database contains tables related to the Glue service",
    "displayName": "default",
    "deleted": false,
    "href": "http://localhost:8585/api/v1/databases/9655ba5b-b8d7-419c-98f4-16b976692ad8"
  },
  "tags": [],
  "deleted": false,
  "sourceUrl": "https://www.glue.com/information_schema",
  "domains": [],
  "entityStatus": "Unprocessed"
}

Returns

Returns the created database schema object with all specified properties and system-generated fields.

Response

string

Unique identifier for the database schema (UUID format).

string

Schema name.

string

Fully qualified name in format service.database.schema.

string

Human-readable display name.

string

Description of the schema in Markdown format.

object

Reference to the parent database.

Show properties

string

UUID of the database.

string

Type of entity (always database).

string

Name of the database.

string

Fully qualified name of the database.

object

Reference to the parent database service.

Show properties

string

UUID of the database service.

string

Type of entity (always databaseService).

string

Name of the database service.

string

Type of database service, for example Snowflake, BigQuery, PostgreSQL.

string

Data retention period in ISO 8601 duration format.

array

List of owners assigned to the schema.

Show properties

string

UUID of the owner entity.

string

Type of owner entity, for example user, team.

string

Name of the owner entity.

array

Domain assignments for the schema.

array

Classification tags applied to the schema.

Show properties

string

Fully qualified name of the tag.

string

Type of label, for example Manual, Derived, Propagated.

string

State of the tag, for example Suggested, Confirmed.

object

Custom property values defined by your organization’s metadata schema.

number

Version number for the entity (starts at 0.1).

Create or Update (PUT)

Use PUT /v1/databaseSchemas instead of POST to perform an upsert. If a database schema with the same fullyQualifiedName already exists, it will be updated; otherwise, a new schema is created. The request body is the same as POST.

curl -X PUT "{base_url}/api/v1/databaseSchemas" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '{ ... same body as POST ... }'

Note: PUT will not return a 409 conflict error if the entity already exists — it will update the existing entity instead. However, for certain fields (such as description, tags, owners, and custom properties), PUT preserves an already-populated value instead of overwriting it with an empty or omitted one — the exact behavior depends on the field and the calling user or bot’s permissions, not a blanket rule. See Entity Update Behavior for the full preserve/merge rules. Use PATCH to intentionally replace an existing value.

Bulk Create or Update (PUT)

Use PUT /v1/databaseSchemas/bulk to create or update multiple database schemas in a single request. The request body is an array of create request objects.

curl -X PUT "{base_url}/api/v1/databaseSchemas/bulk" \
  -H "Authorization: Bearer {access_token}" \
  -H "Content-Type: application/json" \
  -d '[
    { "name": "schema_one", "database": "service.db" },
    { "name": "schema_two", "database": "service.db" }
  ]'

Error Handling

Code	Error Type	Description
`400`	`BAD_REQUEST`	Invalid request body or missing required fields
`401`	`UNAUTHORIZED`	Invalid or missing authentication token
`403`	`FORBIDDEN`	User lacks permission to create database schemas
`409`	`ENTITY_ALREADY_EXISTS`	Schema with same name already exists in database (POST only)

API Reference

SDK

API

Data Assets

AI Assets

Discovery

Lineage

Data Contracts

Teams & Users

Data Governance

Data Quality

Alerts

Incidents

Billing

Query Runner

Context Plugins

Standards

Create a Database Schema

Create a Database Schema

Body Parameters

Returns

Response

Create or Update (PUT)

Bulk Create or Update (PUT)

Error Handling