Retrieve Droplets in DigitalOcean.
View Specific Information
Digital Ocean supports only Id and TagName columns with "=" operator as filter criteria for this view.
SELECT * FROM Droplets WHERE Id=99585958 SELECT * FROM Droplets WHERE TagName='tag1'
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.
|Id [KEY]||Integer||A unique identifier for each Droplet instance. This is automatically generated upon Droplet creation.|
|Name||String||The human-readable name set for the Droplet instance.|
|Memory||Integer||Memory of the Droplet in megabytes.|
|Vcpus||Integer||The number of virtual CPUs.|
|Disk||Integer||The size of the Droplet's disk in gigabytes.|
|Locked||Boolean||A boolean value indicating whether the Droplet has been locked, preventing actions by users.|
|Status||String||A status string indicating the state of the Droplet instance. This may be 'new', 'active', 'off', or 'archive'.|
|BackupIds||String||An array of backup IDs of any backups that have been taken of the Droplet instance. Droplet backups are enabled at the time of the instance creation.|
|SnapshotIds||String||An array of snapshot IDs of any snapshots created from the Droplet instance.|
|Features||String||An array of features enabled on the Droplet.|
|The slug of the region where the Droplet instance is deployed in.|
|The id of base image used to create the Droplet instance.|
|The unique slug identifier for the size of this Droplet.|
|KernelId||Integer||The id of current kernel.|
|KernelName||String||The display name of the current kernel.|
|KernelVersion||String||A standard kernel version string representing the version, patch, and release information.|
|NextBackupWindow||String||The details of the Droplet's backups feature, if backups are configured for the Droplet. This object contains keys for the start and end times of the window during which the backup will start.|
|Tags||String||An array of Tags the Droplet has been tagged with.|
|VolumeIds||String||A flat array including the unique identifier for each Block Storage volume attached to the Droplet.|
|CreatedAt||Datetime||The date and time value that represent when the Droplet was created.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|TagName||String||Tag name used to query the table.|