Panoply.io - A blog about data management and data infrastructure

Technical insights and creative ideas about data management, data infrastructure, and data analysis.

Subscribe to our emails and get Panoply updates on the fly.

AWS Redshift

Data Engineer's Guide to Redshift Pricing

Although there are several data warehousing systems on the market, Amazon Redshift and Google BigQuery are the industry behemoths. There is a “prevailing consensus that Amazon is leading the pack.....

[+]
Written by Alon Brody |July 06, 2017

AWS Redshift

Redshift Data Types. Day to Day Challenges.

Let's talk about data. The sheer volume of the data collected today is enormous. When I try to even imagine the amounts ... it's staggering.

[+]
Written by Alon Brody |May 15, 2017

AWS Redshift

Redshift Query Queues: The Complete Guide

Setting up a Redshift cluster that hangs on some number of query executions is always a hassle. When users run queries in Amazon Redshift, the queries are routed to query queues. Usually the....

[+]
Written by Alon Brody |April 25, 2017

AWS Redshift

AWS Spectrum, Athena and S3: Everything You Need to Know

Yesterday at AWS San Francisco Summit, Amazon announced a powerful new feature - Redshift Spectrum. Spectrum offers a set of new capabilities that allow Redshift users to seamlessly query....

[+]
Written by Roi Avinoam |April 21, 2017

From raw data to analysis in under 10 minutes.

Sign up now for a demo or a free trail of the Panoply.io platform.

Learn more about platform features

AWS Redshift Data Industry and Trends

Amazon Athena Does Battle: Comparing Athena and Redshift

Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached new heights with the help of....

[+]
Written by Alon Brody |April 18, 2017

AWS Redshift

Lessons Learned From the Recent Amazon S3 Outage

On Feb 28th, Amazon Web Services (AWS), went down for approximately 4 hours. The outage occurred in Amazon’s US-East-1 facility in Virginia, their biggest region, and disrupted business continuity....

[+]
Written by Yaniv Leven |March 30, 2017

AWS Redshift

Introducing Panoply Multi Zone Redshift Service

Today’s considered data management best practices, advocate building resilient architectures that span multiple data centers, regions or even continents.

[+]
Written by Roi Avinoam |March 02, 2017

AWS Redshift

Redshift vs. BigQuery: The Full Comparison

As we speak the future of cloud computing is being decided. Amazon and Google, as well as Microsoft and a few others, offer multiple cloud solutions for practically everything. Despite the....

[+]
Written by Roi Avinoam |July 04, 2016

AWS Redshift

Redshift Benchmark: A First Test of the Entire Data Funnel

Amazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.

[+]
Written by Roi Avinoam |April 12, 2016