Sync your data warehouse

Centralize, activate, and analyze customer data

Many companies store business data in an external data warehouse. While Klaviyo Advanced KDP is your single source of customer truth, it may not include all of your financial, inventory, or operational data.

Klaviyo removes this gap with native data warehouse import and export. Now, every team can work from one accurate, up-to-date view of the customer.

Key capabilities:

• Import: Enrich profiles by importing custom profile properties that leverage predictive models, custom segmentation, or offline data sources in your warehouse. Our reverse ETL [tools? manager?] and native data warehouse connectors automatically transform and sync your data for immediate use in your Klaviyo personalization, segmentation, and reporting.
• Export: Send Klaviyo events and profile data to your data warehouse or S3 to keep external systems current.
• Monitor: Schedule recurring syncs to keep models, third-party insights, and offline data fresh.

Feature highlights

• No code and no developer needed
• No need for a separate ETL
• Customizable configuration of which integration data gets synced

Import views or tables in your data warehouse into Klaviyo

This guide walks you through how to import profile data into Klaviyo. Before you begin, make sure:

• Your data warehouse is connected to Klaviyo
• You have permission to create and share views/tables
• You know where your customer identifiers (email, phone, ID) live

Prepare your data Connect your warehouse Create your first sync Check your sync status Verify your data in Klaviyo and start to use it!

Prepare your data

Make sure your data team has a clean table or view with the customer attributes you want to sync (e.g. loyalty point balances).

Your table must include:

• At least one profile identifier (e.g., email or phone)
• An updated-at timestamp used to detect which rows to process in each sync cycle
• Filter or clean your data as needed before syncing.

Connect your warehouse

1. In Klaviyo, go to Data Management > Syncing
2. Click Create Sync → Import data from your data warehouse
3. Choose your warehouse type: Snowflake, BigQuery, or Databricks (Support for Amazon Redshift, S3, and Azure Synapse is coming soon!)
4. Add your credentials and test the connection

‍

Create your first sync

1. Name your sync and add a short description
2. Under Data Source, choose the table or view to sync
3. Select data type: Profiles (Events and Custom Objects coming soon)
4. Choose sync Cadence and Change Detection column
5. Map warehouse fields to Klaviyo profile properties (create new ones as needed)
6. Click Save

Check your sync status

1. Open Sources > [Your Warehouse Connection]
2. Click your sync name
3. Review recent sync runs, timestamps, and record counts
4. Confirm the latest sync completed successfully

Verify your data in Klaviyo and start to use it!

1. Go to Audience > Profiles
2. Search for a synced profile
3. Under Custom Properties, confirm your synced fields appear

Once verified, use your new data for personalization and segmentation:

1. Go to Audience > Lists & Segments
2. Click Create New > Create Segment
3. Choose Properties about someone
4. Search your new field (e.g., loyalty_balance)
5. Build a segment such as “loyalty_balance > 500 points”

Your segment will auto-update as syncs run.

‍

Looking for inspiration?

When your data warehouse and Klaviyo stay in sync, every team across the customer experience works from the same, reliable source of truth.

You can instantly pull in customer attributes, predictive scores, or engagement data to drive more precise strategies, consistent reporting, and better experiences.

Here are a few ways to get started: