FlyData Blog

What is Big Data?
 • 
As we proceed through this age of massive information and great technologies, we are obtaining many more angles from which we can record data. As a result, organizations like Google, Amazon, Facebook, Netflix, and Twitter are finding more and more uses for the information gained from analyzing th...
Redshift Table Size: How to find the size of a table in Redshift
 • 
SVVTABLEINFO is a Redshift systems table that shows information about user-defined tables (not other system tables) in a Redshift database. The table is only visible to superusers. To get the size of each table, run the following command on your Redshift cluster: SELECT “table”, size, tblrows F...
Amazon Redshift DISTKEY and SORTKEY | Redshift Indexes
 • 
Amazon Redshift’s DISTKEY and SORTKEY are a powerful set of tools for optimizing query performance. Because Redshift is a columnar database with compressed storage, it doesn't use indexes that way a transactional database such as MySQL or PostgreSQL would. Instead, it uses DISTKEYs and SORTKEYs. ...
Redshift Create Table | How to Create a Redshift Table
 • 
Amazon’s official documentation on Redshift’s CREATE TABLE commands has a lot of information in it. Too much, in fact. It’s hard to sort the necessary from the unimportant, and that’s why we wrote this blog post. In this guide, we’re going to keep things simple. First up, we break down how to use...
How to Sync Data from Amazon Aurora to Redshift
 • 
What is the best way to sync data from Amazon Aurora to Redshift? In this guide, we’ll break down what these two databases are, why should you be using them, and how to sync your data from Amazon Aurora to Redshift quickly and easily and keep it replicating in near real-time. What is Amazon Auro...
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.