Turbot Pipes + Steampipe
Turbot Pipes is an intelligence, automation & security platform built specifically for DevOps.
Steampipe is an open source CLI to instantly query cloud APIs using SQL.
For example:
select user_handle, email, statusfrom pipes_organization_memberwhere status = 'accepted';
> select user_handle, email, status from pipes_organization_member where status = 'accepted';+-------------+------------------+----------+| user_handle | email | status |+-------------+------------------+----------+| mario | mario@turbot.com | accepted || yoshi | yoshi@turbot.com | accepted |+-------------+------------------+----------+
Documentation
Get started
Install
Download and install the latest Pipes plugin:
steampipe plugin install pipes
Configuration
Installing the latest Pipes plugin will create a config file (~/.steampipe/config/pipes.spc
) with a single connection named pipes
:
connection "pipes" { plugin = "pipes"
# Turbot Pipes API token. If `token` is not specified, it will be loaded # from the `STEAMPIPE_CLOUD_TOKEN` environment variable and if not found # there will fallback to the `PIPES_TOKEN` environment variable. If both # are set simultaneously, `STEAMPIPE_CLOUD_TOKEN` will take preference. # token = "tpt_thisisnotarealtoken_123"
# Turbot Pipes host URL. This defaults to "https://pipes.turbot.com". # You only need to set this if connecting to a remote Turbot Pipes database # not hosted in "https://pipes.turbot.com". # If `host` is not specified, it will be loaded from the `STEAMPIPE_CLOUD_HOST` # environment variable and if not found there will fallback to the # `PIPES_HOST` environment variable. If both are set simultaneously, # `STEAMPIPE_CLOUD_HOST` will take preference. # host = "https://pipes.turbot.com"}
token
(required) - API tokens can be used to access the Turbot Pipes API or to connect to Turbot Pipes workspaces from the Steampipe CLI. May alternatively be set via theSTEAMPIPE_CLOUD_TOKEN
orPIPES_TOKEN
. Note that the value inSTEAMPIPE_CLOUD_TOKEN
will take preference if both are set.host
(optional) The Turbot Pipes Host URL. This defaults tohttps://pipes.turbot.com
. You only need to set this if you are connecting to a remote Turbot Pipes database that is NOT hosted inhttps://pipes.turbot.com
. This can also be set via theSTEAMPIPE_CLOUD_HOST
orPIPES_HOST
. Note that the value inSTEAMPIPE_CLOUD_HOST
will take preference if both are set.
Get Involved
- Open source: https://github.com/turbot/steampipe-plugin-pipes
- Community: Join #steampipe on Slack →