Skip to main content
PATCH
/
v1
/
instances
/
{instance}
cURL
curl --request PATCH \
  --url https://api.example.com/v1/instances/{instance} \
  --header 'Content-Type: application/json' \
  --data '
{
  "title": "<string>",
  "engine": "ENGINE_UNSPECIFIED",
  "activation": true,
  "version": "<string>",
  "externalLink": "<string>",
  "dataSources": [
    {
      "id": "<string>",
      "type": "DATA_SOURCE_UNSPECIFIED",
      "username": "<string>",
      "password": "<string>",
      "obfuscatedPassword": "<string>",
      "useSsl": true,
      "sslCa": "<string>",
      "obfuscatedSslCa": "<string>",
      "sslCert": "<string>",
      "obfuscatedSslCert": "<string>",
      "sslKey": "<string>",
      "obfuscatedSslKey": "<string>",
      "verifyTlsCertificate": true,
      "host": "<string>",
      "port": "<string>",
      "database": "<string>",
      "srv": true,
      "authenticationDatabase": "<string>",
      "replicaSet": "<string>",
      "sid": "<string>",
      "serviceName": "<string>",
      "sshHost": "<string>",
      "sshPort": "<string>",
      "sshUser": "<string>",
      "sshPassword": "<string>",
      "obfuscatedSshPassword": "<string>",
      "sshPrivateKey": "<string>",
      "obfuscatedSshPrivateKey": "<string>",
      "authenticationPrivateKey": "<string>",
      "obfuscatedAuthenticationPrivateKey": "<string>",
      "authenticationPrivateKeyPassphrase": "<string>",
      "obfuscatedAuthenticationPrivateKeyPassphrase": "<string>",
      "externalSecret": {
        "secretType": "SECRET_TYPE_UNSPECIFIED",
        "url": "<string>",
        "authType": "AUTH_TYPE_UNSPECIFIED",
        "appRole": {
          "roleId": "<string>",
          "secretId": "<string>",
          "type": "SECRET_TYPE_UNSPECIFIED",
          "mountPath": "<string>"
        },
        "token": "<string>",
        "engineName": "<string>",
        "secretName": "<string>",
        "passwordKeyName": "<string>",
        "skipVaultTlsVerification": true,
        "vaultSslCa": "<string>",
        "obfuscatedVaultSslCa": "<string>",
        "vaultSslCert": "<string>",
        "obfuscatedVaultSslCert": "<string>",
        "vaultSslKey": "<string>",
        "obfuscatedVaultSslKey": "<string>"
      },
      "authenticationType": "AUTHENTICATION_UNSPECIFIED",
      "azureCredential": {
        "tenantId": "<string>",
        "clientId": "<string>",
        "clientSecret": "<string>"
      },
      "awsCredential": {
        "accessKeyId": "<string>",
        "secretAccessKey": "<string>",
        "sessionToken": "<string>",
        "roleArn": "<string>",
        "externalId": "<string>"
      },
      "gcpCredential": {
        "content": "<string>"
      },
      "saslConfig": {
        "krbConfig": {
          "primary": "<string>",
          "instance": "<string>",
          "realm": "<string>",
          "keytab": "<string>",
          "kdcHost": "<string>",
          "kdcPort": "<string>",
          "kdcTransportProtocol": "<string>"
        }
      },
      "additionalAddresses": [
        {
          "host": "<string>",
          "port": "<string>"
        }
      ],
      "directConnection": true,
      "region": "<string>",
      "warehouseId": "<string>",
      "masterName": "<string>",
      "masterUsername": "<string>",
      "masterPassword": "<string>",
      "obfuscatedMasterPassword": "<string>",
      "redisType": "REDIS_TYPE_UNSPECIFIED",
      "cluster": "<string>",
      "extraConnectionParameters": {}
    }
  ],
  "syncInterval": "<string>",
  "maximumConnections": 123,
  "syncDatabases": [
    "<string>"
  ],
  "mysqlLowerCaseTableNames": 123,
  "lastSyncTime": "2023-11-07T05:31:56Z",
  "roles": [
    {
      "name": "<string>",
      "connectionLimit": 123,
      "validUntil": "<string>",
      "attribute": "<string>"
    }
  ],
  "labels": {}
}
'
{
  "title": "<string>",
  "engine": "ENGINE_UNSPECIFIED",
  "activation": true,
  "version": "<string>",
  "externalLink": "<string>",
  "dataSources": [
    {
      "id": "<string>",
      "type": "DATA_SOURCE_UNSPECIFIED",
      "username": "<string>",
      "password": "<string>",
      "obfuscatedPassword": "<string>",
      "useSsl": true,
      "sslCa": "<string>",
      "obfuscatedSslCa": "<string>",
      "sslCert": "<string>",
      "obfuscatedSslCert": "<string>",
      "sslKey": "<string>",
      "obfuscatedSslKey": "<string>",
      "verifyTlsCertificate": true,
      "host": "<string>",
      "port": "<string>",
      "database": "<string>",
      "srv": true,
      "authenticationDatabase": "<string>",
      "replicaSet": "<string>",
      "sid": "<string>",
      "serviceName": "<string>",
      "sshHost": "<string>",
      "sshPort": "<string>",
      "sshUser": "<string>",
      "sshPassword": "<string>",
      "obfuscatedSshPassword": "<string>",
      "sshPrivateKey": "<string>",
      "obfuscatedSshPrivateKey": "<string>",
      "authenticationPrivateKey": "<string>",
      "obfuscatedAuthenticationPrivateKey": "<string>",
      "authenticationPrivateKeyPassphrase": "<string>",
      "obfuscatedAuthenticationPrivateKeyPassphrase": "<string>",
      "externalSecret": {
        "secretType": "SECRET_TYPE_UNSPECIFIED",
        "url": "<string>",
        "authType": "AUTH_TYPE_UNSPECIFIED",
        "appRole": {
          "type": "SECRET_TYPE_UNSPECIFIED",
          "mountPath": "<string>"
        },
        "token": "<string>",
        "engineName": "<string>",
        "secretName": "<string>",
        "passwordKeyName": "<string>",
        "skipVaultTlsVerification": true,
        "vaultSslCa": "<string>",
        "obfuscatedVaultSslCa": "<string>",
        "vaultSslCert": "<string>",
        "obfuscatedVaultSslCert": "<string>",
        "vaultSslKey": "<string>",
        "obfuscatedVaultSslKey": "<string>"
      },
      "authenticationType": "AUTHENTICATION_UNSPECIFIED",
      "azureCredential": {
        "tenantId": "<string>",
        "clientId": "<string>"
      },
      "awsCredential": {},
      "gcpCredential": {},
      "saslConfig": {
        "krbConfig": {
          "primary": "<string>",
          "instance": "<string>",
          "realm": "<string>",
          "keytab": "<string>",
          "kdcHost": "<string>",
          "kdcPort": "<string>",
          "kdcTransportProtocol": "<string>"
        }
      },
      "additionalAddresses": [
        {
          "host": "<string>",
          "port": "<string>"
        }
      ],
      "directConnection": true,
      "region": "<string>",
      "warehouseId": "<string>",
      "masterName": "<string>",
      "masterUsername": "<string>",
      "masterPassword": "<string>",
      "obfuscatedMasterPassword": "<string>",
      "redisType": "REDIS_TYPE_UNSPECIFIED",
      "cluster": "<string>",
      "extraConnectionParameters": {}
    }
  ],
  "syncInterval": "<string>",
  "maximumConnections": 123,
  "syncDatabases": [
    "<string>"
  ],
  "mysqlLowerCaseTableNames": 123,
  "lastSyncTime": "2023-11-07T05:31:56Z",
  "roles": [
    {
      "name": "<string>",
      "connectionLimit": 123,
      "validUntil": "<string>",
      "attribute": "<string>"
    }
  ],
  "labels": {}
}

Path Parameters

​
instance
string
required

The instance id.

Query Parameters

​
updateMask
string<field-mask>

The list of fields to update.

​
allowMissing
boolean

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

Body

application/json

Instance is the proto for instances.

​
title
string
​
engine
enum<string>
Available options:
ENGINE_UNSPECIFIED,
CLICKHOUSE,
MYSQL,
POSTGRES,
SNOWFLAKE,
SQLITE,
TIDB,
MONGODB,
REDIS,
ORACLE,
SPANNER,
MSSQL,
REDSHIFT,
MARIADB,
OCEANBASE,
STARROCKS,
DORIS,
HIVE,
ELASTICSEARCH,
BIGQUERY,
DYNAMODB,
DATABRICKS,
COCKROACHDB,
COSMOSDB,
TRINO,
CASSANDRA
​
activation
boolean
​
version
string
​
externalLink
string
​
dataSources
object[]
​
syncInterval
string

The interval between automatic instance synchronizations.

​
maximumConnections
integer<int32>

The maximum number of connections. The default is 10 if the value is unset or zero.

​
syncDatabases
string[]

Enable sync for the following databases. Default empty, means sync all schemas & databases.

​
mysqlLowerCaseTableNames
integer<int32>

The lower_case_table_names config for MySQL instances. It is used to determine whether the table names and database names are case sensitive.

​
lastSyncTime
string<date-time>
​
roles
object[]
​
labels
object

Labels are key-value pairs that can be attached to the instance. For example, { "org_group": "infrastructure", "environment": "production" }

Response

OK

Instance is the proto for instances.

​
title
string
​
engine
enum<string>
Available options:
ENGINE_UNSPECIFIED,
CLICKHOUSE,
MYSQL,
POSTGRES,
SNOWFLAKE,
SQLITE,
TIDB,
MONGODB,
REDIS,
ORACLE,
SPANNER,
MSSQL,
REDSHIFT,
MARIADB,
OCEANBASE,
STARROCKS,
DORIS,
HIVE,
ELASTICSEARCH,
BIGQUERY,
DYNAMODB,
DATABRICKS,
COCKROACHDB,
COSMOSDB,
TRINO,
CASSANDRA
​
activation
boolean
​
version
string
​
externalLink
string
​
dataSources
object[]
​
syncInterval
string

The interval between automatic instance synchronizations.

​
maximumConnections
integer<int32>

The maximum number of connections. The default is 10 if the value is unset or zero.

​
syncDatabases
string[]

Enable sync for the following databases. Default empty, means sync all schemas & databases.

​
mysqlLowerCaseTableNames
integer<int32>

The lower_case_table_names config for MySQL instances. It is used to determine whether the table names and database names are case sensitive.

​
lastSyncTime
string<date-time>
​
roles
object[]
​
labels
object

Labels are key-value pairs that can be attached to the instance. For example, { "org_group": "infrastructure", "environment": "production" }