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.

Roi Avinoam

Recent Posts

Data Technology

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 |January 31, 2018

Being Data Driven Data Technology

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 |January 24, 2018

Being Data Driven

ETL vs ELT: The Difference is in the How

For the last couple of decades ETL (extract, transform, load) has been the traditional approach for data warehousing and analytics. The ELT (extract, load, transform) approach changes the old....

[+]
Written by Roi Avinoam |January 17, 2018

Being Data Driven

How to Move Your MySQL to Redshift

 

Data analytics is a requirement for virtually every business today. However building an analytical data warehouse requires vast computing power to maintain performance and quick retrieval of....

[+]
Written by Roi Avinoam |January 10, 2018

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

Data Technology

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

Product Data Technology

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

Product

PGproxy: Smart Database Load Balancing and Query Routing

A smart, proactive PostgreSQL connection pooler, we are proud to announce our PGproxy offers the advantages of query routing and rewriting, making it optimal for data engineers who need to query....

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

Being Data Driven

The fallacy of One Data Technology to Rule Them All

As a species we’ve invented some pretty nifty things. It’s practically consensus that the wheel, the printing press and the internet top the list but we don’t need to look that far back to find....

[+]
Written by Roi Avinoam |February 16, 2016