Cloud Integration Redshift Join: How to use Redshift's Join Clause Redshift’s JOIN clause is perhaps the second most important clause after SELECT clause. Here's how to use it. Abe Dearmer Read More
Big Data What is Amazon Redshift Spectrum? A lot of data lies inert, in “cold” data lakes, unavailable for analysis. Also called “dark data”, it can hold key insights for enterprises. But the problem is, how do... Abe Dearmer Read More
Cloud Integration What's Unique About a Columnar Database? In this article, we'll cover what is a columnar database and give the advantages and disadvantages of columnar databases. Abe Dearmer Read More
big data integration AWS Redshift Pricing: How much does Redshift cost? What is AWS Redshift’s pricing model and how much will Redshift cost me? We'll go over everything you need to know to answer all of your Amazon Redshfit pricing questions. Abe Dearmer Read More
Cloud Integration Redshift Copy: How 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... Mark Smallcombe Read More
Cloud Integration What Is Snowflake? Looking for a warehouse that can keep pace as your data grows? Here, you’ll learn what is Snowflake and its cost-efficient on-the-fly scaling capabilities. Abe Dearmer Read More
Cloud Integration How Dow Jones Uses Amazon Redshift to Build a Cloud-based Data Platform Table of Contents A struggle for data Designing the new data platform Best practices for querying data New use cases for data The Future of Dow Jones’ Data Platform Why... Abe Dearmer 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