non ephemeral DB

[davidhammturner]

Is there a way to have SteamPipe use a non-ephemeral DB? This would be useful for larger organizations with a large number of accounts.

A large DB could be populated with an initial scan/query and subsequently queried by any number of interested parties without having to gain access to individual accounts. Initially the organization could re-scan/query all accounts on a timed basis and later cloudtrail could be integrated for more efficient approach.

Seems like merely exposing an optional DB config/connection configuration could achieve this.

[johnsmyth]

To an extent, you could do something similar by running steampipe in service mode, setting it to listen on the external network with the listen option, and setting the cache duration with connection options.

We have discussed enterprise use-cases such as yours, and appreciate any insights or suggestions you have as we evolve the product. I would love to hear more details on your specific environment and ideas - would you be willing to get on a call to discuss this some time? If so, we can work out the details via slack, but not a big deal if you dont have the time...