Recipes

Pipeline scenarios

Real-world source → destination patterns teams run on eltPulse. Each scenario maps to connectors in our 123+ catalog. Pick one, hit Start this scenario, add credentials, and run.

All industriesSaaSE-commerceEnterpriseMarketingEngineeringCustomer supportData platform

12 scenarios

Stripe→SnowflakeSaaS

Stripe revenue analytics in Snowflake

Sync customers, subscriptions, invoices, and charges into Snowflake for finance dashboards and cohort analysis — without maintaining custom Stripe ETL scripts.

Finance & RevOps

• · Incremental by event date
• · dbt-ready tables
• · No Fivetran MAR lock-in

Start this scenarioStripeSnowflake

GitHub→BigQueryEngineering

Engineering metrics from GitHub

Load issues, PRs, reviews, and stargazers into BigQuery for DORA metrics, sprint reporting, and open-source community analytics.

Platform & DevEx teams

• · Partition by day
• · Verified connector
• · Export to Git for review

Start this scenarioGitHubBigQuery

Postgres→SnowflakeData platform

Postgres OLTP → Snowflake warehouse

Replicate production Postgres tables to Snowflake — the classic operational-to-analytical handoff for BI and embedded analytics.

Data engineers

• · Database replication
• · Table-level streams
• · Incremental cursors

Start this scenarioPostgresSnowflake

HubSpot→MotherDuckSaaS

HubSpot CRM in MotherDuck

Pull contacts, deals, and engagements into hosted DuckDB for fast analytics, prototyping, and lightweight reverse-ETL experiments.

Growth & ops

• · Hosted DuckDB
• · No file paths
• · Verified HubSpot source

Start this scenarioHubSpotMotherDuck

Salesforce→SnowflakeEnterprise

Salesforce pipeline reporting

Land accounts, opportunities, and activities in Snowflake so sales ops can join CRM data with product usage and billing.

Sales operations

• · Incremental loads
• · Enterprise CRM coverage
• · Git-native definitions

Start this scenarioSalesforceSnowflake

Shopify→BigQueryE-commerce

Shopify orders & inventory in BigQuery

Sync orders, products, and inventory levels for merchandising dashboards, LTV models, and demand forecasting.

E-commerce analytics

• · Order-level grain
• · Marketing join-ready
• · Managed or self-hosted runs

Start this scenarioShopifyBigQuery

Zendesk Support→PostgresCustomer support

Support tickets beside product data

Replicate Zendesk tickets and users into Postgres (or your warehouse) to correlate CSAT with product events and churn.

Customer success

• · Ticket history
• · Join with app DB
• · Incremental sync

Start this scenarioZendesk SupportPostgres

Google Ads→SnowflakeMarketing

Paid media spend in the warehouse

Load Google Ads campaigns and performance into Snowflake for marketing mix modeling and ROAS reporting alongside Stripe revenue.

Marketing analytics

• · Campaign-level facts
• · Attribution joins
• · Schedule nightly syncs

Start this scenarioGoogle AdsSnowflake

Notion→MotherDuckSaaS

Notion docs as queryable tables

Turn Notion databases into structured tables in MotherDuck for ops playbooks, OKR tracking, and lightweight reporting.

Ops & PM

• · No-code source
• · Hosted DuckDB
• · Great for prototypes

Start this scenarioNotionMotherDuck

S3→SnowflakeData platform

Lake files → Snowflake tables

Ingest CSV, JSON, or Parquet landing in S3 into Snowflake — common for vendor dumps, exports, and batch feeds.

Data platform

• · File-based sources
• · Batch-friendly loads
• · Partition-friendly

Start this scenarioS3Snowflake

Mysql→RedshiftData platform

MySQL app DB to Redshift

Mirror MySQL application tables into Redshift for Amazon-native BI stacks and legacy app modernization.

AWS data teams

• · Database replication
• · Proven pattern
• · BYO execution

Start this scenarioMysqlRedshift

Intercom→BigQueryCustomer support

Product conversations in BigQuery

Sync Intercom users and conversations for NLP pipelines, support deflection analysis, and product feedback loops.

Product & support

• · Conversation objects
• · BigQuery ML ready
• · Webhook on run complete

Start this scenarioIntercomBigQuery