Reverse ETL

Purpose

Sync aggregated, transformed data from a data warehouse to operational SaaS tools (CRM, marketing, support) to power customer-facing and internal operational workflows.

Agent Protocol

Trigger

Exact user phrases: "reverse ETL", "Census", "Hightouch", "Grouparoo", "operational analytics", "warehouse to SaaS", "data activation", "warehouse sync", "audience export", "sync config", "operational data", "warehouse-first", "sync identity resolution".

Input Context

Before activating, verify:

• Source warehouse (Snowflake, BigQuery, Redshift, Databricks, Postgres)
• Destination SaaS tools (Salesforce, HubSpot, Marketo, Braze, Amplitude, Zendesk, Google Ads, Facebook Audiences)
• Sync frequency (real-time, hourly, daily, batch window)
• Identity resolution strategy (unique keys, merge rules, foreign key mapping)
• Volume (rows per sync, daily active records)
• Idempotency requirements (upsert vs replace vs append)