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

  1. raw data queries (with massive dataset responses)
  2. 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?

Related questions 15 AWS Redshift vs Snowflake use cases 1 Question regarding choosing Cloud Provider 0 Snowflake Cloud data warehouse - Database best practice limitations Related questions 15 AWS Redshift vs Snowflake use cases 1 Question regarding choosing Cloud Provider 0 Snowflake Cloud data warehouse - Database best practice limitations 10 What is difference between Snowflake Database And Snowflake Schema 0 Is there any feature difference of snowflake between AWS and Azure 1 SnowSQL JSONL vs JSON 4 Snowflake and OLAP solutions 1 Is "Snowflake Data Cloud" a good choice for a cloud-native transactional application data-store? 1 Data Modelling Best Practice in Snowflake 2 Snowflake multi-cluster warehouse performance vs single warehouse with large warehouse size Load 7 more related questions Show fewer related questions

Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.