DatabaseSchema¶

{
  "$id": "https://open-metadata.org/schema/entity/data/databaseSchema.json",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "title": "Database Schema",
  "$comment": "@om-entity-type",
  "description": "This schema defines the Database Schema entity. A `Database Schema` is collection of tables, views, stored procedures, and other database objects.",
  "type": "object",
  "javaType": "org.openmetadata.schema.entity.data.DatabaseSchema",
  "javaInterfaces": ["org.openmetadata.schema.EntityInterface"],

  "definitions": {},

  "properties": {
    "id": {
      "description": "Unique identifier that identifies this schema instance.",
      "$ref": "../../type/basic.json#/definitions/uuid"
    },
    "name": {
      "description": "Name that identifies the schema.",
      "$ref": "../../type/basic.json#/definitions/entityName"
    },
    "fullyQualifiedName": {
      "description": "Name that uniquely identifies a schema in the format 'ServiceName.DatabaseName.SchemaName'.",
      "$ref": "../../type/basic.json#/definitions/fullyQualifiedEntityName"
    },
    "displayName": {
      "description": "Display Name that identifies this schema.",
      "type": "string"
    },
    "description": {
      "description": "Description of the schema instance.",
      "$ref": "../../type/basic.json#/definitions/markdown"
    },
    "dataProducts": {
      "description": "List of data products this entity is part of.",
      "$ref": "../../type/entityReferenceList.json"
    },
    "version": {
      "description": "Metadata version of the entity.",
      "$ref": "../../type/entityHistory.json#/definitions/entityVersion"
    },
    "updatedAt": {
      "description": "Last update time corresponding to the new version of the entity in Unix epoch time milliseconds.",
      "$ref": "../../type/basic.json#/definitions/timestamp"
    },
    "updatedBy": {
      "description": "User who made the update.",
      "type": "string"
    },
    "impersonatedBy": {
      "description": "Bot user that performed the action on behalf of the actual user.",
      "$ref": "../../type/basic.json#/definitions/impersonatedBy"
    },
    "href": {
      "description": "Link to the resource corresponding to this entity.",
      "$ref": "../../type/basic.json#/definitions/href"
    },
    "owners": {
      "description": "Owner of this schema.",
      "$ref": "../../type/entityReferenceList.json"
    },
    "service": {
      "description": "Link to the database cluster/service where this schema is hosted in.",
      "$ref": "../../type/entityReference.json"
    },
    "serviceType": {
      "description": "Service type where this schema is hosted in.",
      "$ref": "../services/databaseService.json#/definitions/databaseServiceType"
    },
    "database": {
      "description": "Reference to Database that contains this table.",
      "$ref": "../../type/entityReference.json"
    },
    "tables": {
      "description": "References to tables in the schema.",
      "$ref": "../../type/entityReferenceList.json"
    },
    "usageSummary": {
      "description": "Latest usage information for this database.",
      "$ref": "../../type/usageDetails.json",
      "default": null
    },
    "tags": {
      "description": "Tags for this Database Schema Service.",
      "type": "array",
      "items": {
        "$ref": "../../type/tagLabel.json"
      },
      "default": []
    },
    "changeDescription": {
      "description": "Change that lead to this version of the entity.",
      "$ref": "../../type/entityHistory.json#/definitions/changeDescription"
    },
    "incrementalChangeDescription": {
      "description": "Change that lead to this version of the entity.",
      "$ref": "../../type/entityHistory.json#/definitions/changeDescription"
    },
    "deleted": {
      "description": "When `true` indicates the entity has been soft deleted.",
      "type": "boolean",
      "default": false
    },
    "retentionPeriod": {
      "description": "Retention period of the data in the database schema. Period is expressed as duration in ISO 8601 format in UTC. Example - `P23DT23H`. When not set, the retention period is inherited from the parent database, if it exists.",
      "$ref": "../../type/basic.json#/definitions/duration"
    },
    "extension": {
      "description": "Entity extension data with custom attributes added to the entity.",
      "$ref": "../../type/basic.json#/definitions/entityExtension"
    },
    "sourceUrl": {
      "description": "Source URL of database schema.",
      "$ref": "../../type/basic.json#/definitions/sourceUrl"
    },
    "domains": {
      "description": "Domains the Database Schema belongs to. When not set, the Schema inherits the domain from the database it belongs to.",
      "$ref": "../../type/entityReferenceList.json"
    },
    "votes": {
      "description": "Votes on the entity.",
      "$ref": "../../type/votes.json"
    },
    "lifeCycle": {
      "description": "Life Cycle properties of the entity",
      "$ref": "../../type/lifeCycle.json"
    },
    "followers": {
      "description": "Followers of this entity.",
      "$ref": "../../type/entityReferenceList.json"
    },
    "certification": {
      "$ref": "../../type/assetCertification.json"
    },
    "sourceHash": {
      "description": "Source hash of the entity",
      "type": "string",
      "minLength": 1,
      "maxLength": 32
    },
    "databaseSchemaProfilerConfig": {
      "type": "object",
      "javaType": "org.openmetadata.schema.type.DatabaseSchemaProfilerConfig",
      "description": "This schema defines the type for Schema profile config.",
      "properties": {
        "profileSample": {
          "description": "Percentage of data or no. of rows we want to execute the profiler and tests on",
          "type": "number",
          "default": null
        },
        "profileSampleType": {
          "$ref": "./table.json#/definitions/profileSampleType"
        },
        "sampleDataCount": {
          "description": "Number of row of sample data to be generated",
          "type": "integer",
          "default": 50,
          "title": "Sample Data Rows Count"
        },
        "samplingMethodType": {
          "$ref": "./table.json#/definitions/samplingMethodType"
        },
        "sampleDataStorageConfig": {
          "title": "Storage Config for Sample Data",
          "$ref": "../services/connections/connectionBasicType.json#/definitions/sampleDataStorageConfig"
        },
        "randomizedSample": {
          "description": "Whether to randomize the sample data or not.",
          "type": "boolean",
          "default": true
        }
      }
    },
    "entityStatus": {
      "description": "Status of the DatabaseSchema.",
      "$ref": "../../type/status.json"
    }
  },

  "required": ["id", "name", "database", "service"],
  "additionalProperties": false
}

{
  "@context": {
    "@vocab": "https://open-metadata.org/schema/",
    "om": "https://open-metadata.org/schema/",
    "rdfs": "http://www.w3.org/2000/01/rdf-schema#",
    "xsd": "http://www.w3.org/2001/XMLSchema#",
    "dcat": "http://www.w3.org/ns/dcat#",

    "DatabaseSchema": {
      "@id": "om:DatabaseSchema",
      "@type": ["om:DataAsset", "dcat:Catalog"]
    },
    "id": {
      "@id": "om:id",
      "@type": "xsd:string"
    },
    "name": {
      "@id": "om:name",
      "@type": "xsd:string"
    },
    "fullyQualifiedName": {
      "@id": "om:fullyQualifiedName",
      "@type": "xsd:string"
    },
    "displayName": {
      "@id": "om:displayName",
      "@type": "xsd:string"
    },
    "description": {
      "@id": "om:description",
      "@type": "xsd:string"
    },
    "database": {
      "@id": "om:belongsToDatabase",
      "@type": "@id"
    },
    "service": {
      "@id": "om:belongsToService",
      "@type": "@id"
    },
    "serviceType": {
      "@id": "om:hasServiceType",
      "@type": "xsd:string"
    },
    "tables": {
      "@id": "om:hasTable",
      "@type": "@id",
      "@container": "@set"
    },
    "owners": {
      "@id": "om:hasOwners",
      "@type": "@id",
      "@container": "@set"
    },
    "domains": {
      "@id": "om:hasDomains",
      "@type": "@id",
      "@container": "@set"
    },
    "tags": {
      "@id": "om:hasTag",
      "@type": "@id",
      "@container": "@set"
    },
    "dataProducts": {
      "@id": "om:hasDataProducts",
      "@type": "@id",
      "@container": "@set"
    },
    "followers": {
      "@id": "om:hasFollowers",
      "@type": "@id",
      "@container": "@set"
    },
    "deleted": {
      "@id": "om:isDeleted",
      "@type": "xsd:boolean"
    },
    "retentionPeriod": {
      "@id": "om:retentionPeriod",
      "@type": "xsd:duration"
    },
    "usageSummary": {
      "@id": "om:hasUsageSummary",
      "@type": "@json"
    },
    "databaseSchemaProfilerConfig": {
      "@id": "om:hasProfilerConfig",
      "@type": "@json"
    },
    "version": {
      "@id": "om:version",
      "@type": "xsd:decimal"
    },
    "updatedAt": {
      "@id": "om:updatedAt",
      "@type": "xsd:long"
    },
    "updatedBy": {
      "@id": "om:updatedBy",
      "@type": "xsd:string"
    },
    "votes": {
      "@id": "om:hasVotes",
      "@type": "@json"
    },
    "lifeCycle": {
      "@id": "om:hasLifeCycle",
      "@type": "@json"
    },
    "certification": {
      "@id": "om:hasCertification",
      "@type": "@json"
    },
    "entityStatus": {
      "@id": "om:hasEntityStatus",
      "@type": "@json"
    }
  }
}

{
  "@context": "https://open-metadata.org/context/dataAsset.jsonld",
  "@type": "DatabaseSchema",
  "@id": "https://example.com/data/schemas/public",

  "id": "c3d4e5f6-a7b8-4c9d-0e1f-2a3b4c5d6e7f",
  "name": "public",
  "fullyQualifiedName": "postgres_prod.ecommerce.public",
  "displayName": "Public Schema",
  "description": "Main application schema containing customer, order, and product tables",
  "deleted": false,
  "retentionPeriod": "P2555D",

  "database": {
    "@id": "https://example.com/data/databases/ecommerce",
    "@type": "Database",
    "id": "b2c3d4e5-f6a7-4b8c-9d0e-1f2a3b4c5d6e",
    "name": "ecommerce",
    "type": "database"
  },

  "service": {
    "@id": "https://example.com/services/postgres_prod",
    "@type": "DatabaseService",
    "id": "a1b2c3d4-e5f6-4a7b-8c9d-0e1f2a3b4c5d",
    "name": "postgres_prod",
    "type": "databaseService"
  },
  "serviceType": "Postgres",

  "tables": [
    {
      "@id": "https://example.com/data/tables/customers",
      "@type": "Table",
      "id": "d4e5f6a7-b8c9-4d0e-1f2a-3b4c5d6e7f8a",
      "name": "customers",
      "type": "table"
    },
    {
      "@id": "https://example.com/data/tables/orders",
      "@type": "Table",
      "id": "e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b",
      "name": "orders",
      "type": "table"
    }
  ],

  "owners": [
    {
      "@id": "https://example.com/teams/ecommerce",
      "@type": "Team",
      "id": "e5f6a7b8-c9d0-4e1f-2a3b-4c5d6e7f8a9b",
      "name": "ecommerce",
      "displayName": "E-commerce Team",
      "type": "team"
    }
  ],

  "domains": [
    {
      "@id": "https://example.com/domains/sales",
      "@type": "Domain",
      "id": "f6a7b8c9-d0e1-4f2a-3b4c-5d6e7f8a9b0c",
      "name": "Sales",
      "type": "domain"
    }
  ],

  "tags": [
    {
      "tagFQN": "Tier.Gold",
      "source": "Classification",
      "labelType": "Manual",
      "state": "Confirmed"
    }
  ],

  "followers": [],
  "dataProducts": [],

  "usageSummary": {
    "dailyStats": {
      "count": 250,
      "percentileRank": 90.0
    },
    "weeklyStats": {
      "count": 1750,
      "percentileRank": 88.0
    },
    "monthlyStats": {
      "count": 7500,
      "percentileRank": 85.0
    },
    "date": "2024-01-03"
  },

  "databaseSchemaProfilerConfig": {
    "profileSample": 50,
    "profileSampleType": "PERCENTAGE",
    "sampleDataCount": 50,
    "randomizedSample": true
  },

  "votes": {
    "upVotes": 8,
    "downVotes": 0,
    "upVoters": [],
    "downVoters": []
  },

  "version": 1.3,
  "updatedAt": 1704240000000,
  "updatedBy": "jane.doe"
}