curl --request GET \
--url https://api.example.com/v1/instances/{instance}/databases:batchGet{
"databases": [
{
"name": "<string>",
"state": "STATE_UNSPECIFIED",
"successfulSyncTime": "2023-11-07T05:31:56Z",
"project": "<string>",
"schemaVersion": "<string>",
"environment": "<string>",
"effectiveEnvironment": "<string>",
"labels": {},
"instanceResource": {
"title": "<string>",
"engine": "ENGINE_UNSPECIFIED",
"engineVersion": "<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": {}
}
],
"activation": true,
"name": "<string>",
"environment": "<string>"
},
"backupAvailable": true,
"drifted": true
}
]
}Retrieves multiple databases by their names. Permissions required: bb.databases.get
curl --request GET \
--url https://api.example.com/v1/instances/{instance}/databases:batchGet{
"databases": [
{
"name": "<string>",
"state": "STATE_UNSPECIFIED",
"successfulSyncTime": "2023-11-07T05:31:56Z",
"project": "<string>",
"schemaVersion": "<string>",
"environment": "<string>",
"effectiveEnvironment": "<string>",
"labels": {},
"instanceResource": {
"title": "<string>",
"engine": "ENGINE_UNSPECIFIED",
"engineVersion": "<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": {}
}
],
"activation": true,
"name": "<string>",
"environment": "<string>"
},
"backupAvailable": true,
"drifted": true
}
]
}Was this page helpful?