SSIS Components for DigitalOcean

Build 20.0.7587

DatabaseClusters

Retrieve information regarding the database clusters.

View Specific Information

Select

Digital Ocean supports only Id column with "=" operator as filter criteria for this view.

SELECT * FROM DatabaseClusters WHERE Id='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Id [KEY] String A unique ID that can be used to identify and reference a database cluster.
ConnectionDatabase String The name of the default database.
ConnectionHost String The FQDN pointing to the database cluster's current primary node.
ConnectionPassword String The randomly generated password for the default user.
ConnectionPort Integer The port on which the database cluster is listening.
ConnectionSsl Boolean A boolean value indicating if the connection should be made over SSL.
ConnectionUri String A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.
ConnectionUser String The default user for the database.
PrivateConnectionDatabase String The name of the default database.
PrivateConnectionHost String The FQDN pointing to the database cluster's current primary node.
PrivateConnectionPassword String The randomly generated password for the default user.
PrivateConnectionPort Integer The port on which the database cluster is listening.
PrivateConnectionSsl Boolean A boolean value indicating if the connection should be made over SSL.
PrivateConnectionUri String A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.
PrivateConnectionUser String The default user for the database.
DbNames String An array of strings containing the names of databases created in the database cluster.
CreatedAt Datetime Represents when the database cluster was created.
Engine String A slug representing the database engine used for the cluster. The possible values are: 'pg' for PostgreSQL, 'mysql' for MySQL, and 'redis' for Redis.
Name String A unique, human-readable name referring to a database cluster.
NumNodes Integer The number of nodes in the database cluster.
Region String The slug identifier for the region where the database cluster is located.
Size String The slug identifier representing the size of the nodes in the database cluster.
Status String A string representing the current status of the database cluster. Possible values include creating, online, resizing, and migrating.
Tags String An array of tags that have been applied to the database cluster.
Users String An array containing objects describing the database's users
Version String A string representing the version of the database engine in use for the cluster.
MaintenanceWindowDay String The day of the week on which to apply maintenance updates.
MaintenanceWindowDescription String A list of strings, each containing information about a pending maintenance update.
MaintenanceWindowHour String The hour in UTC at which maintenance updates will be applied in 24 hour format.
MaintenanceWindowPending Boolean A boolean value indicating whether any maintenance is scheduled to be performed in the next window.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587