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": {}
}Gets a database instance by name. Permissions required: bb.instances.get
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": {}
}The instance id.
OK
The name of the instance. Format: instances/{instance}
The lifecycle state of the instance.
STATE_UNSPECIFIED, ACTIVE, DELETED The display title of the instance.
The database engine type.
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 The version of the database engine.
External URL to the database instance console.
Data source configurations for connecting to the instance.
Show child attributes
The environment resource. Format: environments/prod where prod is the environment resource ID.
Whether the instance is activated for use.
Database roles available in this instance.
Show child attributes
How often the instance is synced.
The maximum number of connections. The default is 10 if the value is unset or zero.
Enable sync for following databases. Default empty, means sync all schemas & databases.
The last time the instance was synced.
Labels are key-value pairs that can be attached to the instance. For example, { "org_group": "infrastructure", "environment": "production" }
Show child attributes
Was this page helpful?