Skip to content

Latest commit

 

History

History
129 lines (94 loc) · 3.48 KB

index.md

File metadata and controls

129 lines (94 loc) · 3.48 KB
Raw
organization category icon_url brand_color display_name short_name description og_description og_image engines
Turbot
public cloud
/images/plugins/turbot/linode.svg
#00b050
Linode
linode
Steampipe plugin to query resources, users and more from Linode.
Query Linode with SQL! Open source CLI. No DB required.
/images/plugins/turbot/linode-social-graphic.png
steampipe
sqlite
postgres
export

Linode + Steampipe

Linode is a cloud hosting company that provides virtual private servers and other infrastructure services.

Steampipe is an open-source zero-ETL engine to instantly query cloud APIs using SQL.

List instances in your Linode account:

select
  label,
  region,
  status
from
  linode_instance
+-------------+---------+---------+
| label       | region  | status  |
+-------------+---------+---------+
| my-instance | us-east | running |
+-------------+---------+---------+

Documentation

Get started

Install

Download and install the latest Linode plugin:

steampipe plugin install linode

Credentials

No credentials are required.

Configuration

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

connection "linode" {
  plugin = "linode"
  token  = "5a76843869c183a4ea901c79102bfa1f667f39a2ea0ba857c9a35a9885d91fbd"
}
  • token - API token from Linode.

Multi-Account Connections

You may create multiple linode connections:

connection "linode_dev" {
  plugin    = "linode"
  token     = "5a76843869c183a4ea901c79102bfa1f667f39a2ea0ba857c9a35a9965d91fbd"
}

connection "linode_qa" {
  plugin    = "linode"
  token     = "5a76843869c183a4ty001c79102bfa1f667f39a2ea0ba857c9a35a9965d91fbd"
}

connection "linode_prod" {
  plugin    = "linode"
  token     = "5a76843869c183a4ea901c79102bfa1f667f39a2ea0ba857c9a35a7765d91fbd"
}

Each connection is implemented as a distinct Postgres schema. As such, you can use qualified table names to query a specific connection:

select * from linode_qa.linode_user

You can create multi-account connections by using an aggregator connection. Aggregators allow you to query data from multiple connections for a plugin as if they are a single connection.

connection "linode_all" {
  plugin      = "linode"
  type        = "aggregator"
  connections = ["linode_dev", "linode_qa", "linode_prod"]
}

Querying tables from this connection will return results from the linode_dev, linode_qa, and linode_prod connections:

select * from linode_all.linode_user

Alternatively, you can use an unqualified name and it will be resolved according to the Search Path. It's a good idea to name your aggregator first alphabetically so that it is the first connection in the search path (i.e. linode_all comes before linode_dev):

select * from linode_user

Steampipe supports the * wildcard in the connection names. For example, to aggregate all the linode_user plugin connections whose names begin with linode_:

connection "linode_all" {
  type        = "aggregator"
  plugin      = "linode_user"
  connections = ["linode_*"]
}