DigitalOcean
DigitalOcean is a cloud infrastructure provider and platform-as-a-service (PaaS) company that offers cloud computing services, virtual machines, and developer-friendly tools for deploying, managing, and scaling applications. DigitalOcean provides simplified cloud infrastructure solutions primarily targeted at developers, startups, and small to medium-sized businesses looking for cost-effective and straightforward cloud hosting alternatives to larger providers like AWS, Azure, or Google Cloud Platform.
| Category | Cloud |
| Direction | Query source |
| Sign-in | Personal Access Token |
| Query languages | SQLite |
| Tables | 24 |
| Website | digitalocean.com |
Before you start
Huntbase signs in to DigitalOcean with Personal Access Token. Create the credential in DigitalOcean first, then keep it to hand for the Connect step.
- In the DigitalOcean Control Panel, click Account › API in the main menu.
- On the Tokens tab, in Personal access tokens, click Generate New Token.
- Enter a Token name, choose an Expiration, and under Scopes select Read Only.
- Click Generate Token and copy the token. It is shown only once.
Permissions:
- Read Only
Watch out for
- You cannot change a token's scopes after you create it. To change access, create a new token.
For the vendor's own instructions, see DigitalOcean personal access token documentation.
tip
Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.
Connect DigitalOcean
- Go to Connections and click New connection, or click New connection on the DigitalOcean product page.
- On Product, pick DigitalOcean and choose the Owner.
- On Details, give the connection a Name and, optionally, a Description.
- On Connect, fill in the settings and credentials described below.
- On Verify, review the summary and click Create & check.
For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.
Credentials
The only Method is Personal Access Token. Enter a Credential label (for example Production), then fill in:
| Field | Required | Notes |
|---|---|---|
| Personal Access Token | Yes | Secret — not shown again after you save it. |
Query it
Once connected, DigitalOcean can serve these languages in a query tab, and Scout can use it when you ask in Auto:
| Language | Use it for |
|---|---|
| SQLite | SQL over the 24 tables listed below, alongside every other connected source. |
Tables
DigitalOcean adds 24 tables. Browse their columns from Schema in the query bar's ⋯ menu.
All 24 tables
| Table | Contains |
|---|---|
digitalocean_account | Retrieve information about your current account. |
digitalocean_action | Actions are records of events that have occurred on the resources in your account. These can be things like rebooting a Action, or transferring an image to a new region. |
digitalocean_alert_policy | DigitalOcean Alert Policy |
digitalocean_app | DigitalOcean App |
digitalocean_balance | Balance information for the current account. |
digitalocean_bill | Billing history is a record of billing events for your account. For example, entries may include events like payments made, invoices issued, or credits granted. |
digitalocean_container_registry | DigitalOcean Container Registry |
digitalocean_database | DigitalOcean's managed database service simplifies the creation and management of highly available database clusters. Currently, it offers support for PostgreSQL, Redis, and MySQL. |
digitalocean_domain | DigitalOcean Domain |
digitalocean_droplet | A Droplet is a DigitalOcean virtual machine. |
digitalocean_firewall | DigitalOcean Cloud Firewalls are a network-based, stateful firewall service for Droplets provided at no additional cost. Cloud firewalls block all traffic that isn’t expressly permitted by a rule. |
digitalocean_floating_ip | DigitalOcean Floating IPs are publicly-accessible static IP addresses that can be mapped to one of your Droplets. They can be used to create highly available setups or other configurations requiring movable addresses. |
digitalocean_image | A DigitalOcean image can be used to create a Droplet and may come in a number of flavors. Currently, there are five types of images: snapshots, backups, applications, distributions, and custom images. |
digitalocean_key | DigitalOcean allows you to add SSH public keys to the interface so that you can embed your public key into a Droplet at the time of creation. Only the public key is required to take advantage of this functionality. |
digitalocean_kubernetes_cluster | DigitalOcean Kubernetes (DOKS) is a managed Kubernetes service that lets you deploy Kubernetes clusters without the complexities of handling the control plane and containerized infrastructure. Clusters are compatible with standard Kubernetes toolchains and integrate natively with DigitalOcean Load Balancers and block storage volumes. |
digitalocean_kubernetes_node_pool | DigitalOcean Kubernetes Node Pool |
digitalocean_load_balancer | DigitalOcean Load Balancers provide a way to distribute traffic across multiple Droplets. |
digitalocean_project | Projects allow you to organize your resources into groups that fit the way you work. You can group resources (like Droplets, Spaces, load balancers, domains, and floating IPs) in ways that align with the applications you host on DigitalOcean. |
digitalocean_region | A region in DigitalOcean represents a datacenter where Droplets can be deployed and images can be transferred. Each region represents a specific datacenter in a geographic location. Some geographical locations may have multiple "regions" available. This means that there are multiple datacenters available within that area. |
digitalocean_size | The sizes objects represent different packages of hardware resources that can be used for Droplets. This includes the amount of RAM, the number of virtual CPUs, disk space, and transfer. The size object also includes the pricing details and the regions that the size is available in. |
digitalocean_snapshot | Snapshots are saved instances of a Droplet or a block storage volume. |
digitalocean_tag | A tag is a label that can be applied to a resource (currently Droplets, Images, Volumes, Volume Snapshots, and Database clusters) in order to better organize or facilitate the lookups and actions on it. |
digitalocean_volume | DigitalOcean Block Storage Volumes provide expanded storage capacity for your Droplets and can be moved between Droplets within a specific region. Volumes function as raw block devices, meaning they appear to the operating system as locally attached storage which can be formatted using any file system supported by the OS. |
digitalocean_vpc | VPCs (virtual private clouds) are virtual networks containing resources that can communicate with each other in full isolation using private IP addresses. |
Next steps
- Connections — health, credentials and settings after you connect
- Query languages — syntax, parameters and time ranges
- Chatting with Scout — ask questions without writing a query
- All integrations — the rest of the catalog