turbot/steampipecloud

GitHub
steampipe plugin install steampipecloudsteampipe plugin install steampipecloud

Steampipe Cloud + Steampipe

Steampipe Cloud is a fully managed SaaS platform for hosting Steampipe instances.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

For example:

select
user_handle,
email,
status
from
steampipecloud_organization_member
where
status = 'pending'
> select user_handle, email, status from steampipecloud_organization_member where status = 'pending'
+-------------+------------------+----------+
| user_handle | email | status |
+-------------+------------------+----------+
| mario | mario@turbot.com | pending |
| yoshi | yoshi@turbot.com | pending |
+-------------+------------------+----------+

Documentation

Get started

Install

Download and install the latest Steampipe Cloud plugin:

steampipe plugin install steampipecloud

Configuration

Installing the latest Steampipe Cloud plugin will create a config file (~/.steampipe/config/steampipecloud.spc) with a single connection named steampipecloud:

connection "steampipecloud" {
plugin = "steampipecloud"
# Steampipe Cloud API token. If `token` is not specified, it will be loaded
# from the `STEAMPIPE_CLOUD_TOKEN` environment variable.
# token = "spt_thisisnotarealtoken_123"
# Steampipe Cloud host URL. This defaults to "https://cloud.steampipe.io/".
# You only need to set this if connecting to a remote Steampipe Cloud database
# not hosted in "https://cloud.steampipe.io/".
# If `host` is not specified, it will be loaded from the `STEAMPIPE_CLOUD_HOST`
# environment variable.
# host = "https://cloud.steampipe.io"
}
  • token (required) - API tokens can be used to access the Steampipe Cloud API or to connect to Steampipe Cloud workspaces from the Steampipe CLI. May alternatively be set via the STEAMPIPE_CLOUD_TOKEN environment variable.
  • host (optional) The Steampipe Cloud Host URL. This defaults to https://cloud.steampipe.io/. You only need to set this if you are connecting to a remote Steampipe Cloud database that is NOT hosted in https://cloud.steampipe.io/. This can also be set via the STEAMPIPE_CLOUD_HOST environment variable.

Get Involved