Retrieve images in DigitalOcean.
View Specific Information
Digital Ocean supports only Id, Slug and Private columns with "=" operator as filter criteria for this view.
SELECT * FROM Images SELECT * FROM Images WHERE Id='16376426' SELECT * FROM Images WHERE Slug='cassandra' SELECT * FROM Images WHERE Private=true
To retrieve only distribution images or application images, use TypeOf pseudo-column with "=" operator in WHERE clause.
SELECT * FROM Images WHERE TypeOf='distribution' SELECT * FROM Images WHERE TypeOf='application'
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]||Long||A unique number used to identify and reference a specific image.|
|Slug [KEY]||String||A uniquely identifying string that is associated with each of the DigitalOcean-provided public images. These can be used to reference a public image as an alternative to the numeric id.|
|Name||String||The display name of the image. This is shown in the web UI and is generally a descriptive title for the image in question.|
|Kind||String||The kind of image, describing the duration of how long the image is stored. This is either 'snapshot' or 'backup'.|
|Distribution||String||The base distribution used for this image.|
|IsPublic||Boolean||A boolean value that indicates whether the image in question is public. An image that is public is available to all accounts. A non-public image is only accessible from your account.|
|Regions||String||An array of the regions where the image is available. The regions are represented by their identifying slug values.|
|MinDiskSize||Integer||The minimum 'disk' size required for a size to use this image.|
|SizeGigabytes||Double||The size of the image in gigabytes.|
|CreatedAt||Datetime||When the image 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.
|TypeOf||String||TypeOf can be used to retrieve only distribution or application images, by setting its value to 'distribution' or 'application'.|
|Private||Boolean||Set this to true to retrieve private images.|