Chinh (lelouvincx) / 2026-03-09

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]
    • https://media.secondbrain.lelouvincx.com/2026/03/2cc4f3771066ace4ea3b5b3a21a74f91.png
    • https://media.secondbrain.lelouvincx.com/2026/03/ab97a01230a393c6da930d192aecd319.png
  • 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
    • 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

• 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.

• 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-holistics in dbt project

• DONE Review PR CI dataset scope