turbot / steampipe-plugin-digitalocean

Use SQL to instantly query droplets, VPCs, users and more from DigitalOcean. Open source CLI. No DB required.

DigitalOcean Plugin for Steampipe

Use SQL to query infrastructure including servers, networks, identity and more from DigitalOcean.

• Get started →
• Documentation: Table definitions & examples
• Community: Join #steampipe on Slack →
• Get involved: Issues

Quick Start

Install the plugin with Steampipe:

steampipe plugin install digitalocean

Run a query:

select
  name,
  engine,
  version
from
  digitalocean_database;

Developing

Prerequisites:

• Steampipe
• Golang

Clone:

git clone https://github.com/turbot/steampipe-plugin-digitalocean.git
cd steampipe-plugin-digitalocean

Build, which automatically installs the new version to your ~/.steampipe/plugins directory:

make

Configure the plugin:

cp config/* ~/.steampipe/config
vi ~/.steampipe/config/digitalocean.spc

Try it!

steampipe query
> .inspect digitalocean

Further reading:

• Writing plugins
• Writing your first table

Open Source & Contributing

This repository is published under the Apache 2.0 (source code) and CC BY-NC-ND (docs) licenses. Please see our code of conduct. We look forward to collaborating with you!

Steampipe is a product produced from this open source software, exclusively by Turbot HQ, Inc. It is distributed under our commercial terms. Others are allowed to make their own distribution of the software, but cannot use any of the Turbot trademarks, cloud services, etc. You can learn more in our Open Source FAQ.

Get Involved

Join #steampipe on Slack →

Want to help but don't know where to start? Pick up one of the help wanted issues:

• Steampipe
• DigitalOcean Plugin

steampipe-plugin-digitalocean's Issues

Add table digitalocean_droplet_disk_i/o

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

v0.6.0

Add table digitalocean_domain

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add table digitalocean_droplet_cpu_usage

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add CHANGELOG for v0.2.1

Add table digitalocean_container_registry

References
Terraform link : https://registry.terraform.io/providers/digitalocean/digitalocean/latest/docs/resources/container_registry

Add table digitalocean_kubernetes_node_pool

References
terraform link : https://registry.terraform.io/providers/digitalocean/digitalocean/latest/docs/resources/kubernetes_node_pool

Update example query.

Describe the bug
Example query needs update for region col. https://hub.steampipe.io/plugins/turbot/digitalocean/tables/digitalocean_database

Steampipe version (steampipe -v)
Example: v0.3.0

Plugin version (steampipe plugin list)
Example: v0.5.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

Update digitalocean_droplet example doc to remove size_gigabytes

Describe the bug
Examples using size_gigabytes here breaks due to the non-existence of the required column.

size_gigabytes column exists in digitalocean_snapshot

Steampipe version (steampipe -v)
Example: v0.3.0

Plugin version (steampipe plugin list)
Example: v0.5.0

To reproduce
Steps to reproduce the behavior (please include relevant code and/or commands).

Expected behavior
A clear and concise description of what you expected to happen.

Additional context
Add any other context about the problem here.

update docs/index.md for config file options

Add table digitalocean_storage_spaces

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Update steampipe-plugin-sdk to v1.3.1

Add table digitalocean_app

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

cannot list droplets

hi,
when i try to list my droplets i get an error. listing my k8s-clusters or accountdata works.

> select * from do_test.digitalocean_account;
+----------------------------+---------------+----------------+-------------------+--------+----------------+------------------------------------------+--------------+---------------------------------------------------------+------+----------->
| email                      | droplet_limit | email_verified | floating_ip_limit | status | status_message | uuid                                     | volume_limit | akas                                                    | tags | title     >
+----------------------------+---------------+----------------+-------------------+--------+----------------+------------------------------------------+--------------+---------------------------------------------------------+------+----------->
...
> select * from do_test.digitalocean_kubernetes_cluster;
+--------------------------------------+-------------+---------+---------------------+--------------+----------------+---------------------------------------------------------------------+---------------+-------------+------------------+------>
| id                                   | name        | status  | created_at          | auto_upgrade | cluster_subnet | endpoint                                                            | ipv4          | region_slug | registry_enabled | servi>
+--------------------------------------+-------------+---------+---------------------+--------------+----------------+---------------------------------------------------------------------+---------------+-------------+------------------+------>
...
> select * from do_prod.digitalocean_droplet;
Error: failed to populate column 'next_backup_window_start': rpc error: code = Internal desc = transform timestampToIsoTimestamp failed with panic interface conversion: interface {} is nil, not *godo.Timestamp

this is my environment:

❯ steampipe --version
steampipe version 0.7.0
❯ steampipe plugin list
+-----------------------------------------------------+---------+-----------------+
| Name                                                | Version | Connections     |
+-----------------------------------------------------+---------+-----------------+
| hub.steampipe.io/plugins/theapsgroup/gitlab@latest  | 0.0.2   | gitlab          |
| hub.steampipe.io/plugins/turbot/digitalocean@latest | 0.4.0   | do_prod,do_test |
+-----------------------------------------------------+---------+-----------------+

Add project_id info in digitalocean_database

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Add table digitalocean_database_connection

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add table digitalocean_cloud_firewall

References
Pls check if the inbound and outbound rule table will be different or can be part of the same table.

Add table digitalocean_alert_policy

References
https://www.digitalocean.com/products/monitoring/

v0.3.0

v0.3.0 [2021-03-11]

What's new?

• New tables added
  • digitalocean_action
  • digitalocean_balance
  • digitalocean_bill

Enhancements

• Added private_ipv4, public_ipv4, public_ipv6 columns to digitalocean_droplet table
• Renamed column size to size_slug in digitalocean_load_balancer table
• Renamed column region to region_slug in digitalocean_load_balancer table
• Updated columns using deprecated ColumnType_DATETIME type to instead use ColumnType_TIMESTAMP type

Add table digitalocean_database_db

References
https://registry.terraform.io/providers/digitalocean/digitalocean/latest/docs/resources/database_db

Add `firewall_rules` column and users & database info in digitalocean_database

Is your feature request related to a problem? Please describe.

• The user and db_names columns are not populated in digitalocean_database.
• Require the firewall_rules column for digitalocean_database_dashboard.

Describe the solution you'd like

Add firewall_rules column and users & database info in digitalocean_database

Add table digitalocean_ kubernetes_cluster

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

Add table digitalocean_ kubernetes_cluster

References
Add any related links that will help us understand the resource, including vendor documentation, related GitHub issues, and Go SDK documentation.

v0.5.0

v0.4.0

Add CHANGELOG for v0.2.0

Add DigitalOcean account owner & project details across all tables

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Getting error on doing a get call to table `digitalocean_snapshot`

Getting error on doing a get call to table digitalocean_snapshot:

> select title, regions, id, akas from digitalocean_snapshot where id = '125517051'

ERROR: rpc error: code = Unknown desc = failed to populate column 'akas': rpc error: code = Internal desc = transform snapshotToURN failed with panic interface conversion: interface {} is *godo.Snapshot, not godo.Snapshot (SQLSTATE HV000)