0

select * from cloud;

 1 year ago
source link: https://steampipe.io/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Get Steampipe

Open source
No DB required
200+ data sources
steampipe interactive client
Features

Query like it's 1992

Stop hacking around with scripts; get real work done with
the data access standard that's been rocking it for 4 decades.

select
runtime,
count(*)
aws_lambda_function
group by
runtime;
 +------------+-------+
 |  runtime   | count |
 +------------+-------+
 | nodejs12.x |     1 |
 | python3.7  |     1 |
 | python3.8  |     2 |
 +------------+-------+
SQL? Really?

Yes, SQL. It is an elegant and powerful tool that makes working with multiple APIs simple. SQL levels the playing field for your team, easily integrates with other systems and accelerates delivery.

select
aws.name aws_user_name,
slack.id as slack_user_id,
slack.display_name as slack_name
aws_iam_user as aws,
slack_user as slack
where
aws.name = slack.email;
+--------------------------+---------------+------------+
|     aws_user_name        | slack_user_id | slack_name |
+--------------------------+---------------+------------+
| [email protected] | U2EMB8HLP     | dwight     |
| [email protected]    | U02HE4Z7E     | jim        |
+--------------------------+---------------+------------+
Explore, connect and join data.

Painlessly join live cloud configuration data with internal or external data sets to create new insights.

select
domain,
expiration_date
whois_domain
where
domain in ('apple.com','steampipe.io');
+--------------+---------------------+
|    domain    |   expiration_date   |
+--------------+---------------------+
| apple.com    | 2021-02-20 05:00:00 |
| steampipe.io | 2021-10-13 19:28:29 |
+--------------+---------------------+
The cloud is a live database.

Stop building and maintaining out-of-sync lists and point-in-time environment snapshots; Steampipe's live tables give you the current view of any resource right now.


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK