Snowplow on Amazon Redshift

Amazon Redshift, the original cloud data warehouse, now powers mission-critical workloads for over 15,000 organizations worldwide. One of them? Learn how Snowplow delivers the best behavioral data into your Redshift cloud data warehouse, enabling you to better understand and serve your customers.

Why use Snowplow with your AWS account?

Rich and granular data

Each event captured by Snowplow has 130+ properties by default, providing you with incredibly rich behavioral data. You can also fully customize events, allowing you to power use cases specific to your organization.

Low latency load

Snowplow delivers high quality event-level behavioral data to Amazon Redshift in less than 30 minutes, so you can model your data and derive insights faster.

Automatic table evolution

Snowplow is designed to make it easy for you to evolve your tracking over time, as your products and your business requirements evolve. Our Redshift loader automatically creates or updates tables based on any changes you make to your data structures, so you don’t have to worry about breaking reporting or ensuring changes are backwards compatible.

dbt models included

We have out of the box dbt models for web and mobile, aggregating the event level data into page views, screen views, sessions and users tables. The fully incremental design ensures you are processing data in the most performant and cost-effective way. They are pluggable, allowing you to add your custom events and entities, custom modeling logic, and custom tables. All data models can easily be configured in our UI, or you can leverage our corresponding dbt packages.

How does it work?

Get Started

Unlock the value of your behavioral data with customer data infrastructure for AI, advanced analytics, and personalized experiences