What is Steampipe?

→ Query cloud APIs.
→ Visualize queries on dashboards.
→ Run compliance controls and benchmarks.
→ Blazing fast multi-threaded Golang CLI.
→ Connect anything to the embedded PostgreSQL.

{` select region, instance_state as state, instance_type as type from aws_ec2_instance; `} {`+-----------+---------+-----------+ | region | state | type | +-----------+---------+-----------+ | eu-west-1 | running | t3.medium | | eu-west-2 | running | m5a.large | | us-east-1 | running | t3.large | +-----------+---------+-----------+ `}

## tl;dr ** → ** **[Benchmark dashboards](#benchmark-dashboards)**.
** → ** **[Postgres 14](#postgres-14)**.
** → ** **[ARM64](#arm64-binaries-for-macos-and-linux)**.
** → ** **[New plugins and mods](#new-plugins-and-mods)**.
** → ** Even more goodies in the [full release notes](https://github.com/turbot/steampipe/blob/main/CHANGELOG.md#v0140-2022-05-09). ## Benchmark dashboards In v0.13.0 we introduced [Dashboards](https://steampipe.io/blog/dashboards-as-code), a major new Steampipe feature that makes it easy to visualize queries using HCL + SQL. And we added a new class of [Insights](https://hub.steampipe.io/mods?objectives=dashboard) mods, for all the major clouds, that answer key questions ("How old are my resources?", "Where is encryption not enabled?") with charts, tables, infocards, and flow diagrams. We've grown these Insights mods substantially since the v0.13.0 launch, and we encourage you to write and contribute your own. Now, in v0.14.0, all existing benchmarks and controls work automatically as interactive dashboards! For example, here's [AWS Thrifty](https://hub.steampipe.io/mods/turbot/aws_thrifty).

The setup is the same as before. ``` steampipe plugin update aws git clone https://github.com/turbot/steampipe-mod-aws-thrifty cd steampipe-mod-aws-thrifty ``` You can still use `steampipe check all` to run all the checks, optionally [exporting results](https://steampipe.io/docs/reference/cli/check#available-commands) to HTML and/or CSV. But now, in that same directory, you can use `steampipe dashboard` and then visit `localhost:9194` to view an interactive report that you can also export to CSV. ## Postgres 14 We've upgraded the embedded Postgres engine from 12.1 to 14.2. The Postgres [feature matrix](https://www.postgresql.org/about/featurematrix/) documents all the new features now available. The new [JSONB subscripting](https://www.postgresql.org/docs/14/datatype-json.html#JSONB-SUBSCRIPTING) will be of particular interest to Steampipe users who often unpack information in JSONB columns. Here's the original (and still-supported) way to extract the `Name` field from the `tags` column of `aws_ec2_instance`. ``` select tags ->> 'Name' as tag_name from aws_ec2_instance ``` Now you can do this in way that feels more familiar if you've used other JSON implementations. ``` select tags['Name'] as tag_name from aws_ec2_instance ``` If you have created tables or materialized views based on Steampipe data, and/or written Postgres functions to work with that data, those objects -- stored in the Postgres public schema -- will automatically migrate to the new database. The tools that Steampipe uses to do that migration -- `pg_dump` and `pg_restore` -- are also now included in this release. ## ARM64 binaries for MacOS and Linux With the advent of Apple silicon, aka M1, it became possible to ship Steampipe binaries for this new architecture. And in v14.0 that's what what you get. When you [install Steampipe](https://steampipe.io/downloads) on MacOS you get an M1 version of both Steampipe and the Steampipe foreign data wrapper (FDW). When you install new plugins, those will be M1 binaries too. What about existing plugins? We've got you covered! Steampipe will upgrade those in place. These binaries will run faster than their x86 counterparts. They will also download faster, and occupy smaller disk footprints, than would universal (aka "fat") binaries. You can also now use ARM64 binaries on other systems, like those based on [AWS Graviton](https://aws.amazon.com/ec2/graviton/), provided they are running Linux. ## New plugins and mods Since our [last release](https://steampipe.io/blog/release-0-13-0), we've added 2 new plugins: - [Snowflake](https://hub.steampipe.io/plugins/turbot/snowflake) - query database, role, session, user, etc - [AWS CloudFormation](https://hub.steampipe.io/plugins/turbot/awscfn) - query mapping, output, parameter, resource And we've added 5 new mods: - [Azure Insights](https://hub.steampipe.io/mods/turbot/azure_insights) - [DigitalOcean Insights](https://hub.steampipe.io/mods/turbot/digitalocean_insights) - [GCP Insights](https://hub.steampipe.io/mods/turbot/gcp_insights) - [Snowflake Compliance](https://hub.steampipe.io/mods/turbot/snowflake_compliance) - [Terraform OCI Compliance](https://hub.steampipe.io/mods/turbot/terraform_oci_compliance) We are always improving the suites of plugins and mods. During this cycle, tables were added to these plugins: [Alibaba Cloud](https://hub.steampipe.io/plugins/turbot/alicloud), [AWS](https://hub.steampipe.io/plugins/turbot/aws), [Azure](https://hub.steampipe.io/plugins/turbot/azure), [DigitalOcean](https://hub.steampipe.io/plugins/turbot/digitalocean), [GitLab](https://hub.steampipe.io/plugins/theapsgroup/gitlab), and [Oracle Cloud](https://hub.steampipe.io/plugins/turbot/oci). We added dashboards to these Insights mods: [Alibaba Cloud](https://hub.steampipe.io/mods/turbot/alicloud_insights), [AWS](https://hub.steampipe.io/mods/turbot/aws_insights), [Azure](https://hub.steampipe.io/mods/turbot/azure_insights), [GCP](https://hub.steampipe.io/mods/turbot/gcp_insights), and [Oracle Cloud](https://hub.steampipe.io/mods/turbot/oci_insights). Finally, we added 19 new AWS Foundational Security Best Practices controls to [AWS Compliance](https://hub.steampipe.io/mods/turbot/aws_compliance). ## Let’s get building! Steampipe delivers tools to build, execute, and visualize and share cloud configuration, compliance, and security frameworks using HCL + SQL and a little elbow grease. To support those tools, it maps a growing suite of APIs to tables that you can query, and join across, in Postgres. Do you want to help us expand the open source documentation and control coverage for CIS, PCI, HIPAA, and NIST? Add tables to existing plugins? Create plugins to bring new APIs into the mix? Create dashboards to visualize those APIs? The best way to get started is to [join our Slack workspace](https://steampipe.io/community/join) and raise your hand. We would love to talk to you! For even more good stuff in v0.14.0, check out the [full release notes on GitHub](https://github.com/turbot/steampipe/blob/main/CHANGELOG.md#v0140-2022-05-09).

v0.14.0: Benchmark dashboards, Postgres 14, ARM64