Content from Madison Schott

About the Author

Madison Schott is an Analytics Engineer, author of The ABCs of Analytics Engineering book. Madison blogs about the modern data stack on Medium and writes a newsletter on Substack.

4 Problems The Modern Data Stack Solves

•

August 23, 2023

•

8 min read

Moving Data From Stripe To A Warehouse With Airbyte: Sync Modes

•

July 25, 2023

•

15 min read

Testing Data Pipelines with dbt-expectations: A Beginner's Guide

•

June 7, 2023

•

10 min read

Data Engineering to Analytics Engineering: How to Successfully Transition

•

May 9, 2023

•

10 min read

How to Write a High-Quality Data Model From Start to Finish Using dbt

•

April 5, 2023

•

15 min read

Maximizing Snowflake Storage: Understanding Views and Table Types

•

February 20, 2023

•

10 min read

5 Signs Analytics Engineering Might Be the Right Career For You

•

January 30, 2023

•

10 min read

Snowflake security best practices: access control, data masking, and governance

•

January 18, 2023

•

8 min read

Best practices for data modeling with SQL and dbt

•

August 23, 2022

•

8 min read

6 ways to reduce Snowflake costs

•

July 26, 2022

•

10 min read

Best Practices to Design a Data Ingestion Pipeline

•

May 10, 2022

•

10 min read

Best Practices for Snowflake Users, Roles, and Permissions

•

April 19, 2022

•

15 min read

15 minutes

Validate data replication pipelines with data-diff

Learn to replicate data from Postgres to Snowflake with Airbyte, and compare replicated data with data-diff.

10 minutes

Identify data quality issues on data ingestion pipelines with dbt and re_data

Learn how to detect data quality issues on your Airbyte syncs with re_data.

15 minutes

Build a data ingestion pipeline from Mailchimp to Snowflake

Learn how to easily build a data ingestion pipeline to load business data from Mailchimp to Snowflake.