Big Data How Robinhood Built Their Data Pipeline with Amazon Redshift Robinhood Robinhood is a stock brokerage application that democratizes access to the financial markets, which enables its customers to buy and sell U.S. listed stocks and ETFs with zero commission.... Donal Tobin Read More
big data integration Behind "Amazon Redshift is 10x faster and cheaper than Hadoop + Hive" slides We been providing a web service to make it easy to process & analyze big data on the cloud using Hadoop, utilizing Amazon Elastic MapReduce. Abe Dearmer Read More
big data integration Scalability of Amazon Redshift Data Loading and Query Speeds A lot of people are concerned about the time it took to load all of our data onto Redshift, specifically about the "17 hours for 1.2TB". Donal Tobin Read More
big data integration Is Amazon Redshift a Game-Changer for Big Data Analysis? This article is for explaining what exactly is Amazon Redshift and what is not. Hope it helps those who are curious about Amazon Redshift. Mark Smallcombe Read More
Cloud Integration 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. Abe Dearmer Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 1) We recently discovered an issue running queries from EC2-Classic instances onto a Redshift cluster in EC2-VPC. We ran through a number of troubleshooting steps including: Mark Smallcombe Read More
Cloud Integration How to make EC2 MTU Settings Compatible with Amazon Redshift (Part 2) We set out to edit all our Chef recipes to deploy our new DHCP client configuration files so we can quickly deploy them to all our instances. Mark Smallcombe Read More
Cloud Integration How to improve performance of "UPSERT"s when running "COPY commands UPSERT is the operation to merge new records with existing records using primary keys on a table. While some RDBMSs support a single UPSERT statement. Abe Dearmer Read More
ETL 26 min Top 14 ETL Tools (Updated Jaunary 2025) Integrate.io lists the 14 best ETL software tools for 2024 based on features, user review scores, and more. Which ETL tool should you choose? Abe Dearmer Read More
ETL 11 min SFTP to Salesforce – Guide to a Secure Integration Integrating data from your systems into Salesforce is a critical process. Here is a guide featuring the SFTP to Salesforce process. Donal Tobin Read More
Data Integration 10 min What Is Operational ETL? Delving into Operational ETL: Learn how it transforms business data handling for enhanced productivity. Donal Tobin Read More