Apache Druid vs Snowflake
I'm Choosing the Proper Tools for Bi/Olap and Need Understand Whether Snowflake or Druid Is More Suitable for My Goals. Currently I'm Using Snowflake as My...
I'm choosing the proper Tools for BI/OLAP and need understand whether Snowflake or Druid is more suitable for my goals.
Currently I'm using Snowflake as my Data Warehouse, and it serves both
- raw data queries (with massive dataset responses)
- aggregated results
In order to achieve performance of the second type, I'm creating additional aggregation tables, which acts as an OLAP cube. My data is time-based.
However, this method demands additional work, as well as data duplication and static query requirements.
Therefore, I'm considering to adopt apache Druid, which will provide solution for the aggregation.
Is Druid capable of replacing Snowflake for the raw dataset, assuming the the queries will always be bound by the time range, and that I can use scan-queries? Or must I keep both DBs?
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
