Home Data Insights Tutorials Engineering Company Community

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.

Maximizing Snowflake Storage: Understanding Views and Table Types

Madison Schott on Feb 20, 2023

5 Signs Analytics Engineering Might Be the Right Career For You

Madison Schott on Jan 30, 2023

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

Madison Schott on Jan 18, 2023

Best practices for data modeling with SQL and dbt

Madison Schott on Aug 23, 2022

6 ways to reduce Snowflake costs

Madison Schott on Jul 26, 2022

Best Practices to Design a Data Ingestion Pipeline

Madison Schott on May 10, 2022

Best Practices for Snowflake Users, Roles, and Permissions

Madison Schott on Apr 19, 2022

Snowflake Data Warehouse Architecture: How to Organize Databases, Schemas and Tables

Madison Schott on Mar 22, 2022

Best Practices for your dbt Style Guide

Madison Schott on Feb 15, 2022

Using SQL String Functions to Clean Raw Data

Madison Schott on Jan 24, 2022

Loading more...

15 minutes

Validate data replication pipelines with data-diff

made by

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

made by

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

made by

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

Loading more...