Investigate Steampipe Integration #20
Description
Steampipe allows querying a variety of APIs as SQL, and provides sqlite extensions to help. In theory it should be possible to represent each API source as a zillion config and run reports against it as you would any other sql datasource. It would be nice if there was already metadata we could use to convert to zillion configs for each datasource. Also if there are any tools that can make the sqlite extension installation more seamless, so that it might be automatically handled if the extension is missing at warehouse init time.
https://steampipe.io/
https://til.simonwillison.net/sqlite/steampipe