4 ms·
What about joins, are they supported? Can't see them in the examples. The real power of SQL is locked until you can join different data sources.
by ComodoHacker 4y ago
What about joins, are they supported? Can't see them in the examples.
The real power of SQL is locked until you can join different data sources.
- judell 4y agoHere is one of our favorite examples: https://steampipe.io/blog/use-shodan-to-test-aws-public-ip https://steampipe.io/blog/use-shodan-to-test-aws-public-ip
- nathanwallace 4y agoYes - joins work across tables and schemas! This (toy) example connects IAM user records with Slack user data: select u.name, s.id, s.display_name from aws_iam_user as u, slack_user as s where u.name = s.email
- chousuke 4y agoSteampipe is pretty much "just" PostgreSQL with a foreign data wrapper and some fancy extras on top. The data is in tables from the database's perspective, so pretty much everything you can do with PostgreSQL, you can do with steampipe, including creating your own tables, views, functions and whatnot.