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 you want to […]

Read More

The 3+ Vs of Big Data: Volume, Velocity, Variety, and a whole lot more

Everyone wants to claim that they work with big data, but what is big data? Like many qualitative concepts, extremes are easy to identify. Large banks and social media platforms clearly qualify as big data centers, but what about more average companies? When do they need to start worrying about the impact of big data? […]

Read More

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 PG_TABLE_DEF 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  SELECT * FROM PG_TABLE_DEF […]

Read More

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 differences in syntactic structure, performance, and the mechanics […]

Read More

Redshift Copy: How and when to use Redshift’s COPY command

In this guide, we’ll go over the Redshift COPY command, how it can be used to import data into your Redshift database, its syntax, and a few troubles you may run into. What is the Redshift COPY command? The Redshift COPY command, funnily enough, copies data from one source and loads it into your Amazon […]

Read More

FlyData handles real-time replication for Amazon RDS and Aurora, MySQL and PostgreSQL.

Get set up in minutes. Start uncovering data to make faster, better business decisions today.

By using this website you agree to accept our Privacy Policy and Terms & Conditions