FlyData Blog

How to Extract Data from Amazon Redshift
 • 
After using FlyData to load data into Amazon Redshift, you may want to extract data from your Redshift tables to Amazon S3. There are various reasons why you would want to do this, for example: You want to load the data in your Redshift tables to some other data source (e.g. MySQL) To better man...
When Should You Consider Using Amazon Redshift?
 • 
So your application has gained traction and now your queries are starting to take a long time to run. Or maybe you are simply looking for a better way to run analytic queries against your ever growing data. This is when you might want to start looking into data warehousing. Deciding to start usin...
What's Unique About a Columnar Database?
 • 
Looking for the right database technology to use? Luckily there are many database technologies to choose from, including relational databases (MySQL, Postgres), NoSQL (MongoDB), columnar databases (Amazon Redshift, BigQuery), and others. Each choice has its own pros and cons, but today let’s walk...
How to improve performance of "UPSERT"s when running "COPY commands
 • 
TL;DR version: Add "COMPUPDATE OFF" and "STATUPDATE OFF" option to "COPY" for loading data to a staging table. With these options, you can skip post processes of "COPY", which may take a long time even if the number of loaded records is small. What is “UPSERT”? "UPSERT" is the operation to merg...
With Amazon Redshift SSD, querying a TB of data took less than 10 seconds
 • 
The AWS team announced the release of an SSD version of Amazon Redshift on January 24, 2014. To test out the specs of the newly released SSD version, we have performed some comparisons of its performance against the traditional HDD version of Amazon Redshift. http://aws.typepad.com/aws/2014/01/...
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.