Failing syncs on Monday
Priya Sharma, marketing operations manager at BigCo, asked which Census syncs were failing. Memtro listed two marked failing, each with its operation, destination object and schedule frequency.
Census + Memtro
Which Census syncs are failing, and how many records did they drop?
Census, now Fivetran Activations, sends warehouse data to your business tools. Memtro reads your syncs with status, operation, schedule and whether paused, and each sync's runs with records processed, failed and invalid, and any error. It reads the sources, activations and datasets behind them too. When asked, and once an administrator has granted the action by name, it can run a sync now, which writes changed records to the destination system where they stay, pause or resume a sync, cancel a running run, and permanently delete a sync. Dataset SQL is never returned.
In Memtro
What you can do with Census in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Census tool, reads what it needs, and answers with the source cited.
What it does
- 01List syncs with status, operation, the activation and object they send to, schedule frequency and whether paused.
- 02Read one sync's runs, newest first, with what triggered each and source records processed, updated, failed and invalid, with the error if any.
- 03List sources with type, sync engine, region and whether the last connection test passed.
- 04List activations, the destinations data is sent to, and datasets with description, source and column count.
- 05When asked and granted, runs a sync now, querying your warehouse and writing changed records, or every record on a full sync, to the destination system, where they stay.
- 06When asked and granted, pauses or resumes a sync, cancels a running sync run, and permanently deletes a sync with its mappings and run history.
Acts when asked
When you ask it to
These tools change something in Census. The model is told to use them only when you ask for exactly that, and an administrator grants each one by name to the teams that may use it; a personal connection acts only after its owner allows it.
- 01Run a sync now, sending changed records to its destination (optionally a full sync)
- 02Pause a sync, or resume a paused one
- 03Cancel a running sync run
- 04Delete a sync permanently
In practice
Ask it like you would a colleague
Once Census is connected, these are the kinds of things people ask. Plain questions, no syntax. If the answer lives partly in another system you have connected, Memtro looks there too.
Census + MemtroWhich Census syncs are failing?
Why did the HubSpot upsert sync fail this morning?
How many records were invalid on the last Salesforce run?
Which Census syncs are paused?
Pause the HubSpot upsert sync until Monday
Holding a sync during a migration
Tom Reilly, analytics engineer at Northwind, asked Memtro to pause the Salesforce sync while the sales team cleaned up duplicate accounts. Memtro paused it in Census, so it stopped running on its schedule. When the clean-up was done he asked again, and Memtro resumed it and started one run.
Teams
Where it fits
The teams that lean on Census most, a question each of them asks, and what they connect beside it.
- Data and analyticsQuestions answered from the warehouse, with the SQL shownAnalyst, Data engineer, Anybody with a question, Head of data“Revenue by segment for Q3 from the warehouse, with the SQL you used”Used alongside Postgres, Stripe, Slack, Google Drive, Snowflake and 3 more.
- EngineeringKeep decisions from evaporatingEngineer, Tech lead, On call, New joiner“Who owns the billing migration, and what did we decide about retries?”Used alongside GitHub, Linear, Jira, Confluence, Slack and 5 more.
- FinanceAsk the ledger questions in plain EnglishFinance lead, Credit control, Management accountant, Founder or CFO“Which invoices over £5k are more than 30 days overdue?”Used alongside Xero, Stripe, Postgres, HubSpot, QuickBooks Online and 10 more.
Better together
Works with
A record in Census is rarely the whole story. Connect the systems that hold the rest and Memtro checks them together, then remembers what it learned so the next question starts further along.
- AnalyticsCensus with Google Analytics 4Ask your traffic questions in plain English and get the numbers back.
- AnalyticsCensus with Plausible AnalyticsAsk about your website traffic in plain English.
- AnalyticsCensus with UmamiAsk about your website traffic in plain English, without sending anybody to a dashboard.
- Finance and commerceCensus with XeroInvoices, bills, contacts and reports, answered in plain English with figures cited to Xero.
- Finance and commerceCensus with StripeCustomers, charges, invoices and subscriptions through a restricted key.
- Finance and commerceCensus with FellohBookings, payments, refunds, chargebacks, supplier payments and payouts from the travel payments platform.
- Work managementCensus with JiraJQL search, issue details and projects from Jira Cloud.
- Work managementCensus with Clio ManageAsk the matter: its client, its fee earner, the time on it and what is still unbilled.
- Work managementCensus with LinearIssues, projects and teams, synced hourly into memory.
Also in Databases and warehouses
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
- Postgres
- MySQL and MariaDB
- SQL Server
- BigQuery
- Snowflake
- AWS Athena
- MongoDB
- ClickHouse
- Amazon Redshift
- Databricks
- Elasticsearch
- dbt Cloud
- Fivetran
- Neon
- Appwrite
Grist- Hasura
- Meilisearch
NocoDB- Qdrant
Typesense
Weaviate
Tinybird
Hightouch- Airbyte
- Budibase
- CockroachDB Cloud
- Cube Cloud
- DataHub
kintone
Monte Carlo
OpenMetadata- Pinecone
- PlanetScale
- Quickbase
Secoda
Softr
Teable- Turso
- Upstash
Vectara- Xata
- Zilliz Cloud
Setup
How to connect
Connect withPersonal access token and optional region
- 1
In Census, open User settings → Personal Access Tokens → New Token. The token has its creator's permissions, so create it as a user with read-only access unless Memtro should run, pause or delete syncs.
- 2
Name it Memtro and copy it. A Fivetran PAT or an old V1 workspace API key does not work here.
- 3
In Memtro, open Connections → Census, paste it as Personal access token, and set Region to eu if you sign in at app-eu.getcensus.com.
- 4
Ask: which Census syncs are failing?
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Census tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Census?+
Only when you ask, and only what it has been granted: run a sync now, sending changed records to its destination (optionally a full sync); pause a sync, or resume a paused one; cancel a running sync run; delete a sync permanently. Every other tool reads, searches or lists. The Connections page labels the tools that act, an administrator grants each one by name to the teams that may use it, and a personal connection acts only after its owner allows it.
Who can use a Census connection?+
A personal connection serves only your own requests. A shared connection serves the organisation: everyone, or only the teams an admin chooses. Admins can always add shared connections; other members need the permission.
Does Memtro store my Census data?+
Credentials are encrypted at rest. Tool results are cached briefly so agent loops do not repeat identical calls, and the facts the model extracts are saved to your organisation's memory with provenance (system, record and link) so they can be checked and superseded.
How do I connect Census?+
Personal access token and optional region. In Census, open User settings → Personal Access Tokens → New Token. The token has its creator's permissions, so create it as a user with read-only access unless Memtro should run, pause or delete syncs.
Connect Census in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.