SSIS Components for DigitalOcean

Build 20.0.7587


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 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.


Name Type References Description
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.

Name Type Description
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.

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