SSIS Components for DigitalOcean

Build 20.0.7587


Query Kernels available to a Droplet in DigitalOcean.

View Specific Information


You need to specify DropletId to retrieve all kernels available to a Droplet. The DropletId is also the only column supported by Digital Ocean in WHERE clause. The supported operator is "=".

SELECT * FROM Kernels WHERE DropletId=99583825

If a DropletId is not specified, the CData SSIS Components for DigitalOcean will internally append the filter:

WHERE DropletId IN (SELECT Droplets.Id FROM Droplets)

It is recommended to always specify at least one DropletId in the criteria to provide the best performance available.

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case you must specify at least DropletId. The DigitalOcean API requires that queries contain this filter.


Name Type References Description
Id [KEY] Integer A unique number used to identify and reference a specific kernel.
DropletId Integer


The id of the ticket the comment belongs to.
Name String The display name of the kernel. This is shown in the web UI and is generally a descriptive title for the kernel in question.
Version String A standard kernel version string representing the version, patch, and release information.

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