Hacker News Reader

Comment by solutionyogi | Hacker News Reader

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).

View on HN

There 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.

I had never heard of Prestodb. That looks very interesting. Any other solutions that you are familiar with?

My question is how does SPICE differ from BigQuery? I can connect to BigQuery from Tableau, BIME, Chartio, etc.

The documentation for QuickSight mentions that Tableau can connect to SPICE as well.

Not sure about BIME, Chartio. But Tableau certainly connects to Google BigQuery.

Both Chartio and BIME do support BigQuery as well.

Reply on news.ycombinator.com