# Steampipe - select * from cloud;

> Clean Markdown view of GeekNews topic #7543. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=7543](https://news.hada.io/topic?id=7543)
- GeekNews Markdown: [https://news.hada.io/topic/7543.md](https://news.hada.io/topic/7543.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2022-10-05T10:46:01+09:00
- Updated: 2022-10-05T10:46:01+09:00
- Original source: [steampipe.io](https://steampipe.io/)
- Points: 20
- Comments: 1

## Topic Body

- 200개 이상의 데이터 소스(클라우드)에서 데이터를 쿼리하는 오픈소스 도구(GO CLI)  
  - AWS, Azure, GCP 및 각종 SaaS, Identity, DevOps, 네트워크(CDN, IMAP, WHOIS,..), IaC, Log, Social,..   
- SQL 방식으로 다양한 데이터 소스를 조인하여 이용 가능   
  - 슬랙 사용자 중 MFA가 활성화 된 사용자는? `select id, display_name, real_name, has_2fa from slack_user;`  
  - 사용하지 않는 EBS 볼륨은 ? `select volume_id, volume_type from aws_ebs_volume where attachments is null;`  
  - `  
select  
  aws.name aws_user_name,  
  slack.id as slack_user_id,  
  slack.display_name as slack_name  
from  
  aws_iam_user as aws,  
  slack_user as slack  
where  
  aws.name = slack.email;`

## Comments



### Comment 12621

- Author: jhbaek
- Created: 2022-10-05T12:22:22+09:00
- Points: 1

와 외부 BI랑 연결되면 정말 최강일 것 같네요