Even the most potent database is still prone to the terrifying error any database system can face: query bottlenecks.

Data Warehousing

Redshift Query Queues: The Complete Guide

By Daniel Paes on November 12, 2021

One of the significant challenges to data-driven companies comes when integrating different application systems. Major public cloud providers, such as Amazon or Google, ...

Data Stack

AWS Spectrum, Athena, and S3: Everything You Need to Know

By Daniel Paes on July 8, 2021

Data has become the lifeblood of business and data warehouses are an essential part of that. But knowing which data warehouse makes sense for your business can be tricky.

Data Warehousing

Snowflake vs Redshift: Data Warehouse Comparison

By Ben Rogojan on January 9, 2021

As we speak the future of cloud computing is being duked out. Amazon and Google, as well as Microsoft, Snowflake, and a few others, offer multiple cloud solutions for ...

Data Warehousing

Redshift vs. BigQuery: The Full Comparison

By Roi Avinoam on December 18, 2020

We now generate more data in an hour than we did in an entire year just two decades ago. The same old tools simply don't cut it anymore. That's why Amazon came out ...

Data Warehousing

Top 5 Redshift Alternatives: Balancing Cost and Complexity

By Andrew Zola on November 30, 2020

If you're thinking about creating a data warehouse from scratch, one of the options you are probably considering is Amazon Redshift. Redshift is very powerful, but ...

Redshift

A Redshift Pricing Guide for CTOs

By Alon Brody on August 6, 2020

So. You run a business that lives on data. You’ve got a SQL-style relational database or two up and running to store your data, but your data keeps growing and you’re ...

Data Warehousing

Redshift vs Postgres: Differences in Performance, Functions, and Cost

By Peter Weinberg on April 24, 2019

In an increasingly data-focused world, the term “machine learning” is more popular than ever. However, many find the concept intimidating and believe that it is too ...

Redshift

Connecting R to a Redshift Data Warehouse for Machine Learning

By Skyler Shasky on January 23, 2019

Cloud-based data warehouses are quickly replacing their on-premise counterparts, allowing organizations with big data needs to potentially save millions in costs. Amazon ...

Data Warehousing

Setting Up A Cloud Data Warehouse: A Schema To SQL Tutorial

By Peter Weinberg on January 17, 2019

Amazon Redshift is a massively popular data warehouse service that lives on their AWS platform, making it easy to set up and run a data warehouse. Redshift clusters can ...

Data Warehousing

Set up Your First AWS Redshift Database: A Schema to SQL Tutorial

By Peter Weinberg on January 10, 2019

Amazon Redshift is a very powerful data warehouse, optimized for analyzing massive amounts of data in a blink of a second, when configured right.

Redshift

Redshift Benchmark: A First Test of the Entire Data Funnel

By Roi Avinoam on January 24, 2018

Data analytics is a requirement for virtually every business today. However building an analytical data warehouse requires vast computing power to maintain performance ...

Data Warehousing

How to Move Your MySQL to Redshift

By Roi Avinoam on January 10, 2018

Let's talk about data. The sheer volume of the data collected today is enormous. When I try to even imagine the amounts...it's staggering.

Data Warehousing

Redshift Data Types: Day To Day Challenges

By Alon Brody on May 15, 2017

Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached ...

Redshift

Athena vs Redshift: An Amazonian Battle or Performance and Scale

By Alon Brody on April 18, 2017

One of the main goals of this blog is to help developers and data architects, just like us, with their Amazon Redshift operations, including Redshift security. Starting ...

Redshift

Redshift Security - Encrypting Loads with S3/KMS/Lambda

By Alon Brody on February 22, 2017

Data analyst? You must be familiar with both Tableau and AWS Redshift. And you must know, or at least you should believe me that integrating the Redshift columnar-based ...

Data Warehousing

Tableau & Redshift: How to Visualize Amazon Redshift Data

By Alon Brody on February 8, 2017

The basic free Google Analytics (GA) functionality is great for small and medium websites and mobile applications, but as your online business expands, you will start ...

Data Warehousing

Step-by-Step: Loading Data from Google Analytics to Redshift

By Alon Brody on January 24, 2017