Notes
Tasks
Done
- DONE Migrate Census to Fivetran
Context
- Data team is using Census for reverse-ETL jobs. For example, updating tenant info from BigQuery (after transforming) to HubSpot.
- Census is acquired by Fivetran and they request us to migrate from Census account to Fivetran account.
- Deadline: end of march 2026.
- Branding rename: Census => Fivetran Activations.
Current state
- Census organization:
[email protected] - Census plan: free. Expect migrating to Fivetran should stay at free plan.
- There are 2 existing syncs (need to validate after migrating)
- BigQuery
dim_contacts=> HubSpot Contact logseq.order-list-type:: number- Source:
select * from `skilled-fulcrum-90207.mart_holistics.dim_contacts` where holistics_user_role is not null and company_id is not null
- Mapping: https://media.secondbrain.lelouvincx.com/2026/03/c5685cdddf39a4b3c8257c4f6e46bda0.png
- Source:
- BigQuery
fct_customer_stats=> HubSpot Company logseq.order-list-type:: number- Source:
select * from `skilled-fulcrum-90207.mart_holistics.fct_customer_stats` where customer_status != 'not_engaged'
- Mapping: https://media.secondbrain.lelouvincx.com/2026/03/d604277373ef1e5090eae039b5e1fad1.png
- Source:
- BigQuery
- Census organization:
Migration FAQ (link)
- How do I navigate the new Fivetran UI?
- Everything you’d previously configured in Census (datasets, segments, syncs, workspaces, etc.) still exist within Fivetran under that tab.
- Updated pricing: we are using free tier, and we expect this migration stays at free tier.
- Fivetran usage-based pricing model.
- I’m currently using Census for free. After I migrate my account to Fivetran, will I still be able to?
- Yes, Fivetran also offers a free plan. This plan includes free usage for the Fivetran platform, including Activations, within certain limits.
- How do I migrate my Census account to Fivetran if I’m not an existing Fivetran customer?
- All Census accounts are being migrated into Fivetran and standalone Census accounts will not be accessible after April 1, 2026. If you do not already have a Fivetran account, you will need to first create a new Fivetran account and then continue with the migration.
- It’s important to understand that even though your new Fivetran account will have a 14-day trial, you’ll still need to select a Fivetran plan (such as the free plan, if appropriate) in order to ensure your Fivetran account is not frozen when your Census plan expires.
- What happens to my Census account during migration? Is there downtime?
- The only changes to your Census account are to the sign-in process, authentication configuration, and account administration roles.
- The process only takes a few seconds.
- All of your existing Census sources, destinations, syncs, datasets, segments and everything else will not be touched.
- All your syncs will continue to run as normal without any impact or change.
- How do I navigate the new Fivetran UI?
Plan
DONE Understand MAR counting
- TODO Create a Fivetran account for data team ([email protected])
- TODO Login to Census, migrate to the new account.
- TODO Config Fivetran free tier plan.
DONE Adhoc fix failed CI
upload-holisticsin dbt projectDONE Review PR CI dataset scope