I'll admit I'm unfamiliar with the warehousing landscape, but the existing solutions are quite hard to evaluate as they are all quite enterprise-y and offer too many features.
I am looking for a solution that will
- slurp data from my PostgreSQL instance into a columnar store of some kind
- includes a sql-pad that my team can write and share queries on
- maybe include some lightweight graphing
Thanks!
My default is Azure SQL database (SQL as a service) using its column store indexes. [1] https://learn.microsoft.com/en-us/sql/relational-databases/i... [2] https://learn.microsoft.com/en-us/sql/relational-databases/i...
If I outgrow it, I would look into more enterprise-y solutions.