Snowflake is a cloud data platform for storing, processing, and analyzing data with SQL. In this workflow, selected customer history is shared with Amperity through Secure Data Sharing. Amperity resolves identity and prepares email-keyed audience lists and profile attributes for delivery to Klaviyo.

Klaviyo is a marketing platform that uses customer profiles and audiences to support personalized messaging. This connection updates named lists and selected customer attributes through its REST API. Your team manages campaigns, flow configuration, and current subscription consent in Klaviyo after the data arrives.

Snowflake to Klaviyo

Q: How do I connect Snowflake to Klaviyo through Amperity?

Configure an inbound Snowflake Bridge, build an email-keyed audience query in Amperity, and send its results through the Klaviyo destination. Enable profile updates when including attributes beyond email. Validate the list and profile fields before coordinating the source workflow and outbound orchestration schedule.

Q: Can Snowflake customer history update Klaviyo custom properties?

Yes, once that history is available in Amperity, selected query columns map to profile, location, or custom-property fields according to their names. NULL explicitly clears the corresponding field; omitting a field leaves it unchanged. Review missing values and joins to avoid unintentionally erasing existing customer context.

Q: Does refreshing a Klaviyo list subscribe customers?

No, adding a profile to a list does not itself grant subscription consent. Define the audience using available permission data and check current consent in Klaviyo before messaging. Review existing list-triggered flows before sending a test, because adding profiles can trigger those flows under their configured rules.

Bring Snowflake customer history into Klaviyo audiences through Amperity, with Snowflake Secure Data Sharing inbound, identity resolution and audience selection in Amperity, and email-keyed list and profile updates through the Klaviyo REST API.

See the Klaviyo docs Snowflake Bridge docs

How to send Snowflake data to Klaviyo

Share customer history. Configure secure views and an inbound Amperity Bridge using Snowflake Secure Data Sharing.
Prepare the Klaviyo audience. Resolve identity in Amperity and select email addresses plus the customer attributes your team needs.
Send list and profile updates. Configure the Klaviyo destination, enable profile updates when needed, and validate the list and selected properties.

Prepare Klaviyo audiences from Snowflake customer history

Build replenishment lists from available purchase dates.

Enrich Klaviyo profiles with available loyalty tiers.

Refresh named Klaviyo lists as customer eligibility changes.

Supply customer-location properties for Klaviyo segmentation.

What the Snowflake to Klaviyo connection supports

Audience or field	Mapping and behavior	Documentation
Named list	Send email-keyed query results to an existing or new list; verify membership after delivery.	Amperity docs; Vendor reference
Profile identity	Use email as the audience key; map a chosen external identifier to external_id if needed.	Amperity docs; Vendor reference
Standard fields	Alias name columns as first_name and last_name; enable profile updates to send these fields.	Amperity docs; Vendor reference
Location fields	Map address1, city, region and zip into the nested location object.	Amperity docs; Vendor reference
Custom properties	Other columns become properties; NULL columns explicitly clear their corresponding fields.	Amperity docs; Vendor reference

Make purchase and loyalty history useful in Klaviyo

Prepare replenishment outreach

Use purchase dates and product categories available in Amperity to choose customers for a replenishment audience. Send the list and selected purchase-context properties to Klaviyo, where the team can review messaging and current consent before sending.

Recognize a customer’s loyalty relationship

Select an available loyalty tier or membership attribute from customer history shared through Snowflake. Send it as a Klaviyo custom property so the team can distinguish relevant experiences in its segmentation or content. Keep names and values consistent with existing properties.

Set up the Snowflake to Klaviyo workflow

Create a Snowflake share with secure views and the correct Amperity account locator for your stack and region. Check supported types before syncing the inbound connection. Follow the Snowflake Bridge setup.

Authorize Klaviyo with OAuth or a private API key with lists:write and profiles:write scopes. Review profile-update settings, NULL clearing and consent; validate a sandbox sample and any list-triggered flows before production. Follow the Klaviyo destination setup.

Snowflake to Klaviyo integration FAQs

What is Snowflake?

What is Klaviyo?

How do I connect Snowflake to Klaviyo through Amperity?

Can Snowflake customer history update Klaviyo custom properties?

Does refreshing a Klaviyo list subscribe customers?

Put customer context to work in Klaviyo

Explore how purchase and loyalty context can make your next Klaviyo audience more relevant.

Get a demo