Pro · via Fivetran integration
Mama plus BigQuery.
Same schema as Snowflake. Hightouch reverse-ETL supported for pushing back into Mama.
OAuth · 2.0
ReadsAccount tables, signal events
WritesMama-managed dataset
Sync cadenceEvery 6 hours · webhooks for signals
What we sync between Mama and BigQuery.
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
BigQuery datasets sync into Mama; Mama writes briefs + scores back to a Mama-managed dataset.
Custom SQL signals
Yes
Any SQL query over your BigQuery data can become a Mama signal.
BI join schema
Yes
Output dataset designed for joining in Looker Studio or Tableau.
Slot allocation
Partial
Pro plan — pin Mama to a slot reservation so it doesn't spike on-demand pricing.
~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 → BigQuery.
- Click Connect. The OAuth window opens — sign in to BigQuery and grant the requested scopes.
- Map your Mama workspaces to the right BigQuery objects (Accounts/Organizations/etc).
- First sync runs immediately — usually completes in under 5 minutes for accounts ≤10k.
- Done. Briefs surface inside BigQuery 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.
Mama plugs into the rest of the stack the same way.
One OAuth click, capabilities documented honestly, no surprises in production.
Signal-anchored outbound, no theater
Connect your BigQuery and see every account scored by tomorrow morning.
Free up to 100 accounts. No card. OAuth install in under 5 minutes. Cancel anything later from Settings → Integrations.