Query Offload with Redshift Spectrum. Use Cases and Limitations

Jiří Mauritz Data Warehouse, Redshift

Update: An earlier version of this article claimed that Spectrum runs Presto under the hood. This is incorrect. Spectrum uses its own query layer. Query offload from relational data warehouses to cheaper distributed storage seems to be all the rage these days. In this blog post we examine what works and what the limitations are. What is Query Offload? Let’s ...

Data Warehousing in the Age of Big Data. RDBMS Scalability, Exploding Data Volumes and License Costs.

Uli Bethke Big Data, Data Warehouse, Hadoop, MapR

Note: There is an updated version of this post. You can download it for free. Download updated version In the first part of this series of blog posts on data warehousing in the era of big data we looked at limitations of relational databases for data warehousing. In this post I will elaborate further on the impact of growing data ...