Skip to main content
PATCH
/
v1
/
instances
/
{instance}
/
databases
/
{database}
/
catalog
cURL
curl --request PATCH \
  --url https://api.example.com/v1/instances/{instance}/databases/{database}/catalog \
  --header 'Content-Type: application/json' \
  --data '
{
  "name": "<string>",
  "schemas": [
    {
      "name": "<string>",
      "tables": [
        {
          "name": "<string>",
          "columns": {
            "columns": [
              {
                "name": "<string>",
                "semanticType": "<string>",
                "labels": {},
                "classification": "<string>",
                "objectSchema": {
                  "type": "TYPE_UNSPECIFIED",
                  "structKind": {
                    "properties": {}
                  },
                  "arrayKind": {
                    "kind": "<unknown>"
                  },
                  "semanticType": "<string>"
                }
              }
            ]
          },
          "objectSchema": {
            "type": "TYPE_UNSPECIFIED",
            "structKind": {
              "properties": {}
            },
            "arrayKind": {
              "kind": "<unknown>"
            },
            "semanticType": "<string>"
          },
          "classification": "<string>"
        }
      ]
    }
  ]
}
'
{
  "name": "<string>",
  "schemas": [
    {
      "name": "<string>",
      "tables": [
        {
          "name": "<string>",
          "columns": {
            "columns": [
              {
                "name": "<string>",
                "semanticType": "<string>",
                "labels": {},
                "classification": "<string>",
                "objectSchema": {
                  "type": "TYPE_UNSPECIFIED",
                  "structKind": {
                    "properties": {}
                  },
                  "arrayKind": {
                    "kind": "<unknown>"
                  },
                  "semanticType": "<string>"
                }
              }
            ]
          },
          "objectSchema": {
            "type": "TYPE_UNSPECIFIED",
            "structKind": {
              "properties": {}
            },
            "arrayKind": {
              "kind": "<unknown>"
            },
            "semanticType": "<string>"
          },
          "classification": "<string>"
        }
      ]
    }
  ]
}

Path Parameters

instance
string
required

The instance id.

database
string
required

The database id.

Query Parameters

allowMissing
boolean

If set to true, and the database catalog is not found, a new database catalog will be created. In this situation, update_mask is ignored.

Body

application/json

Catalog metadata for a database including schemas, tables, and columns.

name
string

The name of the database catalog. Format: instances/{instance}/databases/{database}/catalog

schemas
object[]

The schemas in the database.

Response

OK

Catalog metadata for a database including schemas, tables, and columns.

name
string

The name of the database catalog. Format: instances/{instance}/databases/{database}/catalog

schemas
object[]

The schemas in the database.