4 ms·
For me, the most interesting part is SPICE. To implement a data warehouse, one creates a star schema (OLAP) database from a regular OLTP database. This involves
by solutionyogi 11y ago
For me, the most interesting part is SPICE. To implement a data warehouse, one creates a star schema (OLAP) database from a regular OLTP database. This involves massive amount of work. It looks like SPICE aims to replace the need for OLAP database and produce similar data directly from OLTP systems. I would love to know more about this engine. I hope Amazon open sources the engine (I highly doubt that they will do it).
- JPKab 11y agoMy question is how does SPICE differ from BigQuery? I can connect to BigQuery from Tableau, BIME, Chartio, etc.
- ickwabe 11y agoNot sure about BIME, Chartio. But Tableau certainly connects to Google BigQuery.
- thingsilearned 11y agoBoth Chartio and BIME do support BigQuery as well.
- shrikant 11y agoThe documentation for QuickSight mentions that Tableau can connect to SPICE as well.
- baconner 11y agoThere are a few similar technologies out there some of which are open source. Prestodb comes to mind but there's also some other closed systems like powerbi (with some underlying azure distributed data warehouse bits), etc out there. What's happening in the industry I think is that there was a first wave of data discovery products (tableau being the prime example) that seek to get you right to reporting and data exploration side without necessarily having to slog through all the data warehouse design, and now a second wave like powerbi, etc that are pure saas plays that do something very similar are starting to come out.
- solutionyogi 11y agoI had never heard of Prestodb. That looks very interesting. Any other solutions that you are familiar with?