Damn this looks really good. Data-first SQL integrated interfaces always get a +1 from me, managing resources without unified abstractions is always painful, especially when you have to do this at scale, standard CLIs always end up falling short in some way<p>Also, relevant tool for similar applications (albeit not SQL based): <a href="https://github.com/cloud-custodian/cloud-custodian" rel="nofollow">https://github.com/cloud-custodian/cloud-custodian</a>
Obviously a quite popular project given the number of times it's been submitted this month: <a href="https://news.ycombinator.com/from?site=github.com/cloudquery" rel="nofollow">https://news.ycombinator.com/from?site=github.com/cloudquery</a>
This is very interesting. If you're managing hundreds of accounts pulling data even from Config from the master payer level is tedious and time consuming. If that data can be pulled out and queried with a real query language (config ql just doesn't cut it) it would make mass management so much easier.
Looks like there are two steps to this tool:<p><pre><code> 1) Fetch data and put into a sql db
2) Query sql db
</code></pre>
Wouldn't it be better, performance aside, if there was just one step, i.e. querying the cloud with SQL, essentially an SQL-to-cloud-APIs interface. Otherwise you're always operating on out-of-date data.
I work on a product named <a href="http://vantage.sh/" rel="nofollow">http://vantage.sh/</a> that provides something similar as a managed service specifically for AWS. I respect the effort that went into this!