Minimal preso

[pauldougan]

Preso for knowledgeshare

[pauldougan]

remix this

Mention

• plug-ins cf net rss csv config terraform
• sources: api, dns, repos,

[pauldougan]

Query cloud things with APIs with SQL

Steampipe is a data wrangling package that uses an extensible Postgres foreign data wrapper to make it feel like a set of relational tables

Architecture diagram

Plug-in architecture allows contributed go modules

Huge number, with many of the major things we are concerned with

• net for dns, tls, certificates
• AWS for AWS infra
• cf for cloud foundry
• config for json, yaml
• csv for data
• Whois
• Prometheus
• grafana
• docker

From user point of view you have a CLI and a local Postgres 14 database with the FDW wrapper installed so you can do idiomatic Postgres things, uses support for jsonb, cast data types etc

Use built in cli for prototyping or use your favourite tools that can talk to Postgres, psql, pgadmin, visidata

Then create dashboards with hcl and sql

Hack code and preview in browser

Can create reports to check compliance

Large number of predefined mods catering to different needs, eg k8s best practice, AWS spend controls ...

Run reports with dashboard or generate reports is csv, json or other formats