FlyData Blog

Learning about ETL - a founding engineer's personal account
 • 
There came a point in my journey working for hired.com where we began to struggle with our data architecture. In this article, I want to share some of the lessons learned in the hope that they are useful to you in your own engineering journey. Hired started as a Ruby on Rails web application bac...
Redshift Unload: Amazon Redshift’s Unload Command
 • 
Redshift’s UNLOAD command is a great little tool that complements Redshift’s COPY command, by doing the exact reverse function. While COPY grabs data from an Amazon s3 bucket and puts into a Redshift table for you, UNLOAD takes the result of a query, and stores the data in Amazon s3. Why would y...
The 5 V’s of Big Data
 • 
Google, Facebook, Netflix, LinkedIn, Twitter and all other social media platforms clearly qualify as big data technology centers. But when did they know to start worrying about the data they have? The answer is simple - it all depends on the characteristics of big data, and when the data processi...
Redshift Show Tables | How to List Redshift Tables
 • 
In order to list or show all of the tables in a Redshift database, you'll need to query the PGTABLEDEF systems table. An interesting thing to note is the PG_ prefix. This is because Redshift is based off Postgres, so that little prefix is a throwback to Redshift’s Postgres origins. Running SELE...
Redshift vs. Postgres: A Detailed Comparison
 • 
Amazon Redshift was birthed out of PostgreSQL 8.0.2. For this reason, many analysts and engineers making the move from Postgres to Redshift feel a certain comfort and familiarity about the transition. While it is true that much of the syntax and functionality crosses over, there are key differenc...
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.