Skip to main content
GET
/
v1
/
instances
/
{instance}
cURL
curl --request GET \
  --url https://api.example.com/v1/instances/{instance}
{
  "name": "<string>",
  "state": "STATE_UNSPECIFIED",
  "title": "<string>",
  "engine": "ENGINE_UNSPECIFIED",
  "engineVersion": "<string>",
  "externalLink": "<string>",
  "dataSources": [
    {
      "id": "<string>",
      "type": "DATA_SOURCE_UNSPECIFIED",
      "username": "<string>",
      "useSsl": true,
      "verifyTlsCertificate": true,
      "host": "<string>",
      "port": "<string>",
      "database": "<string>",
      "srv": true,
      "authenticationDatabase": "<string>",
      "replicaSet": "<string>",
      "sid": "<string>",
      "serviceName": "<string>",
      "sshHost": "<string>",
      "sshPort": "<string>",
      "sshUser": "<string>",
      "externalSecret": {
        "secretType": "SECRET_TYPE_UNSPECIFIED",
        "url": "<string>",
        "authType": "AUTH_TYPE_UNSPECIFIED",
        "appRole": {
          "type": "SECRET_TYPE_UNSPECIFIED",
          "mountPath": "<string>"
        },
        "engineName": "<string>",
        "secretName": "<string>",
        "passwordKeyName": "<string>",
        "skipVaultTlsVerification": true
      },
      "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>",
      "redisType": "REDIS_TYPE_UNSPECIFIED",
      "cluster": "<string>",
      "extraConnectionParameters": {}
    }
  ],
  "environment": "<string>",
  "activation": true,
  "roles": [
    {
      "name": "<string>",
      "roleName": "<string>",
      "connectionLimit": 123,
      "validUntil": "<string>",
      "attribute": "<string>"
    }
  ],
  "syncInterval": "<string>",
  "maximumConnections": 123,
  "syncDatabases": [
    "<string>"
  ],
  "lastSyncTime": "2023-11-07T05:31:56Z",
  "labels": {}
}

Path Parameters

instance
string
required

The instance id.

Response

OK

name
string

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

state
enum<string>

The lifecycle state of the instance.

Available options:
STATE_UNSPECIFIED,
ACTIVE,
DELETED
title
string

The display title of the instance.

engine
enum<string>

The database engine type.

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
engineVersion
string

The version of the database engine.

External URL to the database instance console.

dataSources
object[]

Data source configurations for connecting to the instance.

environment
string

The environment resource. Format: environments/prod where prod is the environment resource ID.

activation
boolean

Whether the instance is activated for use.

roles
object[]

Database roles available in this instance.

syncInterval
string

How often the instance is synced.

maximumConnections
integer<int32>

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

syncDatabases
string[]

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

lastSyncTime
string<date-time>

The last time the instance was synced.

labels
object

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