Hacker News Reader

+1 Steampipe's aggregators to combine multiple datasets into one are great

Very cool! Is it possible to connect to steampipe via jdbc connector?

I presume so: "You can also use psql, pgcli, Metabase, Tableau, or any client that can connect to Postgres."

Correct - it's just Postgres, so all your favorite clients / tools work as usual. We have docs for a number of example integrations [1] that work with Steampipe CLI (or cloud).

1 - https://steampipe.io/docs/cloud/integrations/overview

Is it possible to join those data sources against an existing database like MySQL or SQLServer?

Steampipe runs an embedded Postgres database [1]. One approach would be to connect that Postgres database with other databases using the usual (advanced) techniques like Foreign Data Wrappers [2]? With that connection in place, joins would work as normal.

1 - https://steampipe.io/docs/develop/overview 2 - https://wiki.postgresql.org/wiki/Foreign_data_wrappers