Redshift Show Tables | How to List Redshift Tables December 03, 2021 by Donal Tobin In order to list or show all of the tables in a Redshift database, you'll need to query the PG_TABLE_DEF systems table. An interesting thing to note is the PG_...
Redshift Unload: Amazon Redshift’s Unload Command December 03, 2021 by Abe Dearmer Redshift’s UNLOAD command is a great little tool that complements Redshift’s COPY command, by doing the exact reverse function. While COPY grabs data from an Amazon s3 bucket and puts...
Learning about ETL - a founding engineer's personal account December 03, 2021 by Donal Tobin In this article, I want to share some of the lessons learned in the hope that they are useful to you in your own engineering journey.
Redshift vs. BigQuery: 8 Considerations When Choosing Your Data Warehouse December 03, 2021 by Donal Tobin BigQuery and Redshift are world-class data warehouses, but they are very different. We’ll look at the most important criteria for choosing your data warehouse, including Cloud platform support, Scalability, Performance,...
How Did Your Paid Marketing Channels Perform on Black Friday? December 03, 2021 by Abe Dearmer Create better campaigns for events like Black Friday by integrating data and analyzing the effectiveness of your paid channels.
Data Engineering as a Service - how we help startups make sense of their data December 03, 2021 by Abe Dearmer This blog is to help guide some early teams with tight engineering resources. If you have growing data, you need to view it in one place, analyze it effortlessly and...
AWS Redshift Architecture: Clusters & Nodes & Data Apps December 02, 2021 by Abe Dearmer In this post, we lay out the 5 major components of Amazon Redshift’s architecture. Understanding the components and how they work is fundamental for building a data platform with Redshift....
Top 14 ETL Tools for 2024 November 20, 2023 by Abe Dearmer 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?
MuleSoft vs. Integrate.io: Comparison and Review May 05, 2023 by Abe Dearmer When it comes to ETL solutions, Mulesoft ETL is like a Swiss Army Knife. But if all you need to do is open boxes, do you really need a corkscrew?
17 Best Data Integration Platforms January 29, 2021 by Abe Dearmer You have access to a wide range of data – make sure your organization can use it. Explore these seventeen data integration tools and platforms.