FlyData Blog

AWS Redshift Pricing: How much does Redshift cost?
 • 
What is Redshift’s pricing model and how much will Redshift cost me? While Redshift is arguably the best data warehouse on the market, it can come with a hefty price tag. We’ve created this Redshift pricing guide to help you evaluate Redshift cheaply, create a budget for full implementation, and...
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.