Big Data How Gusto Built Their Data Pipeline with Amazon Redshift Gusto Gusto, founded in 2011, is a company that provides a cloud-based payroll, benefits and workers’ compensation solution for businesses. Their business has grown steadily over the years, currently topping... Abe Dearmer Read More
Big Data 3 Steps to Set up Automatic WLM with Query Priority in Amazon Redshift Introduction With the release of Query Priorities and Automatic WLM, the AWS team has given Amazon Redshift administrators a powerful new way to define and prioritize data workloads. Without using... Donal Tobin Read More
Big Data How Yelp Built Their Data Pipeline with Amazon Redshift Yelp The tech world has changed dramatically since Yelp was launched back in 2004. Eight years later and Yelp started its change. It transformed from running a huge monolithic application... Donal Tobin Read More
Big Data What is the worst part of data engineering? Table of Contents Drivers of change The Challenge of Data Engineering The worst part of data engineering Summary In data engineering teams the list is long and depends on your... Abe Dearmer Read More
Big Data Customer Success Story: Fuze improves query performance by 10x Fuze is a cloud-based communications and collaboration platform provider. Fuze drives workplace transformation for its customers with data from 2.5 million meetings, 20 million calls, and 33 million messages each... Abe Dearmer Read More
Big Data Don’t Use Redshift as an OLTP Database It is common to connect an application framework like Django to Amazon Redshift. This is useful when using Redshift data in your application, i.e. in an OLTP scenario. Since Amazon... Donal Tobin Read More
Big Data Redshift’s Automatic WLM with Query Priority: A First Look at Performance Introduction The AWS team recently released a new feature of their Automatic WLM that we’re really excited about: Query Priorities. This feature aims to address the main limitation of Auto... Abe Dearmer Read More
Big Data Use Routine Vacuuming to Reclaim Unused Space Amazon Redshift databases require periodic maintenance known as vacuuming. Amazon Redshift is based on PostgreSQL, but unlike PostgreSQL, Redshift doesn’t offer autovacuum. So when a row is deleted from a... Abe Dearmer Read More
ETL 46 min Top 25 ETL Tools (Updated Dec 2025) Integrate.io lists the 14 best ETL software tools for 2025 based on features, user review scores, and more. Which ETL tool should you choose? Abe Dearmer Read More
ETL 15 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
