Matt Palmer

We dive into what dbt sources are, how they work, and how you can use them to advance your data warehouse.

In this in-depth guide, Zuar explains what data staging is, why it's important, types of data staging, software staging best practices, and more.

What is data transformation? What are the benefits of data transformation? What are the processes? Learn all this and more!

Learn about the top 5 most common data integration patterns: data migration, broadcast, bi-directional sync, correlation, and aggregation.

Learn the differences between data lakes, data mesh, and data fabric and how your organization can leverage these frameworks in your data stack.

Learn about the key differences between ETL, ELT, and Reverse ETL and how they can be leveraged in your data integration strategy.

Get an overview of Google Cloud Composer, including the pros and cons, an overview of Apache Airflow, workflow orchestration, and frequently asked questions.

This how-to guide explains Redshift's DATEDIFF function including arguments, examples, related functions, and frequently asked questions.

See how companies create value with data, better understand the data lifecycle, and learn how to implement the data value chain.

Learn the basics of Google BigQuery including features and functionality, SQL examples, the architecture, and more.

Use this cheat sheet to quickly reference some of the most common Google BigQuery commands, expressions, data types, and more.

See how to load data from an Amazon S3 bucket into Amazon Redshift. We’ll cover using the COPY command to load tables in both singular and multiple files. with some options available with COPY that allow the user to handle various delimiters, NULL data types, and other data characteristics.

Questions about Redshift? We're providing answers to the questions we often get from Redshift users and admins.

Aren’t sure which modern database is right for your organization? Zuar explores the different database models and their benefits.