Cloud Data Warehouses

Last updated Oct 25, 2024

• Snowflake
• Google BigQuery
• Amazon Redshift
• Azure SQL Data Warehouse

• Firebolt

Another approach is that you change your on-premise Data Warehouse to a Cloud Data Warehouse to get more scalability, more speed, and better availability. This option is best suited for you if you do not necessarily need the fastest response time and you do not have tera- or petabytes of data. The idea is to speed up your DWH and skip the layer of cubes. This way you save much time in the development, processing, and maintenance of OLAP Cubes. On the other hand, you lose in query latency while you create your dashboards. If you mainly have reports anyway, which can run beforehand, then this is perfect for you.

With the release of Amazon Redshift in 2013 followed by Snowflake, Google Big Query, and others in the subsequent years.

Origin: OLAP, what’s coming next? | ssp.sh
References: Cloud Data Provider