Design and implement reverse ETL pipelines that push warehouse data into operational tools.
npx skills add https://github.com/nrakow/ae-skills-dev --skill reverse-etl
Please help me install this Agent Skill. Skill: reverse-etl Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/reverse-etl Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill reverse-etl
Reverse ETL pipelines move modeled warehouse data into operational tools such as Salesforce, HubSpot, and Intercom to empower go-to-customer teams.
Create an activation model under models/activation for your first destination and configure Census or Hightouch to run after your dbt activation runs.
High-intent search queries and answers about installing and using this skill.
Reverse ETL is the process of pushing modeled warehouse data into operational tools like Salesforce. It creates an activation layer between dbt marts and sync tools to reliably update downstream systems with modeled metrics.
To set up an activation layer, create a dedicated model under models/activation for each specific destination. Configure Hightouch to execute the sync only after your dbt activation runs complete to ensure data freshness.
Yes, you can sync to Census without duplicates by using explicit field mappings, stable natural keys, and idempotent upserts. This ensures reliable batch-driven audience activation and prevents duplicate records in target platforms.
Reverse ETL pipelines include governance and safety practices for syncing to HubSpot, featuring PII handling controls, audit logs, and runbooks. These governance artifacts ensure compliant data activation across operational tools.
You should design one model per destination to maintain clear activation layer architecture between marts and sync tools. This practice ensures explicit field mappings and idempotent execution for targeted systems like ad platforms.
tomtoto757Build and configure an ecommerce data warehouse with dbt transformations.
somachakValidate ETL/ELT pipelines for freshness, schema drift, and reconciliation errors.
delta-and-betaManage Braze cohort imports and resolve audience identity mismatches.
charly3pinsEnforce multi-layer validation across API boundaries, services, and test environments.
