Your data warehouse is your single source of truth for customer data. This tutorial shows you how to expose that data as profile attributes in MarTech Pulse without duplicating your entire warehouse.
Prerequisites
You'll need a read-only service account in Snowflake, BigQuery, or Redshift with SELECT access to the tables you want to sync. We recommend creating a dedicated schema (martech_pulse_sync) and only granting access to the tables you intend to expose.
Setting Up the Warehouse Connection
Navigate to Connections > Data Warehouse and click Add Connection. Select your warehouse type and enter your connection credentials. MarTech Pulse uses a dedicated IP range for egress — you'll need to allowlist these IPs in your warehouse firewall rules.
Configuring the Profile Mapping
Once connected, select the table you want to sync and map the identifier column (usually email or user_id) to the MarTech Pulse profile identity field. Then map any additional columns to profile attributes. Numeric columns become number attributes, string columns become string attributes, and boolean columns become boolean attributes.
Incremental Sync and Scheduling
By default, MarTech Pulse runs a full table sync on first connection and then incremental syncs every 15 minutes using a watermark column (updated_at or similar). For tables without a reliable watermark, you can configure a full sync on a daily schedule. Synced attributes appear on profiles within seconds of the sync completing.