Home / Integrations / Snowflake

Pro · via Fivetran integration Install: ~10 minutes via Fivetran connector Tier: Pro plan only

Mama plus Snowflake.

Connector ships mama__accounts, mama__signals, mama__attributions tables.

Connect Snowflake → All integrations

Signal Mama Research layer

OAuth · 2.0

Snowflake Connected

ReadsAccount tables, signal events

WritesMama-managed schema with briefs + scores

Sync cadenceEvery 6 hours · webhooks for signals

What we sync between Mama and Snowflake.

The honest breakdown of what works today, what's partial, and what we deliberately don't ship. Capabilities marked Partial are Pro-plan only or in beta.

Bidirectional sync Yes

Your Snowflake account tables flow into Mama; Mama writes scores + briefs back to its own schema in your warehouse.

Custom SQL signal definitions Yes

Define a signal as any SQL query over your warehouse — Mama scores it nightly.

BI tool join-ready schema Yes

Mama's output schema designed for direct join in Looker/Tableau/Hex.

Cost controls Partial

Available on Pro — set a daily compute budget so the connector doesn't blow up your bill.

~10 minutes via Fivetran connector from clicking "Connect" to first scoring run.

Standard OAuth 2.0 install. No engineering work, no procurement call for the standard tiers.

Sign in to Mama and open Settings → Integrations → Snowflake.
Click Connect. The OAuth window opens — sign in to Snowflake and grant the requested scopes.
Map your Mama workspaces to the right Snowflake objects (Accounts/Organizations/etc).
First sync runs immediately — usually completes in under 5 minutes for accounts ≤10k.
Done. Briefs surface inside Snowflake on the next scoring run, typically the morning after install.

Security note. Mama requests the minimum scopes needed for the capabilities above — no contact-export, no bulk-download of historical data. Read the security details or the data sources page for the full provenance trail.