megachangelog
Census logo

Census Changelog

Census — Data, ETL product updates and releases, tracked on megachangelog.


Breaking2026.09.25

Google Sheets: Primary Identifier Mapping Required

Starting September 25, 2026, Google Sheets destination syncs require a primary identifier mapping to track row changes accurately. New syncs and edits to existing syncs must specify a unique source column as the key, either via the UI or API/Terraform with is_primary_identifier: true.

google-sheetsdestinationssyncsbreakingapi
Improvement

HTTP Request: Raw Payload Type Support

The HTTP Request destination now supports a raw payload type for sending non-JSON request bodies, including XML and SOAP envelopes.

httpapixmldestinationspayloads
Improvement

File-Based Destinations: File Name Timestamp Offset

File-based Activations destinations now support offsetting timestamp tokens in sync file paths by a configurable number of seconds.

file-based-destinationsactivationstimestampconfiguration
Improvement

Asana: Update Only sync behavior

Asana now supports an Update Only sync behavior that uses the native Asana ID (gid) as the key, allowing users to update existing records without creating new ones.

asanasyncfeatureintegration
Improvement

Appcues: Group Object Support

The Appcues connector now supports the Group object for syncing account-level properties like plan tier, MRR, and renewal date using group_id as the identifier.

appcuesgroupsintegrationproperties
Improvement

Reddit Ads: Event Source URL and Product Metadata Fields

The Reddit Ads Conversion Event object now supports event_source_url for improved click attribution and metadata.products for product-level reporting, enabling better tracking and analysis in Reddit's Events Manager.

reddit-adseventsattributionreportingintegrations
Improvement

Mixpanel: India (IN) Region Support

The Mixpanel connector now supports India as a data residency region. Users with Mixpanel projects in India can select the IN region from the region selector to route syncs appropriately.

mixpanelconnectordata-residencyregionsindia
Improvement

Braze: Additional API Region Support

The Braze connector now supports additional API endpoint regions including Australia, Indonesia, Japan, and Korea, allowing accounts hosted on non-US/EU instances to connect to Fivetran Activations.

brazeapiregionsconnectoractivations
Feature

Planhat: Owner Field, Conversation Object, and Mirror Sync Support

Census now supports mapping Company Owner fields to Planhat users, syncing Conversations as standalone objects, and enabling Mirror Sync for bidirectional record synchronization including deletes. Additionally, datetime custom field mapping is now available.

planhatintegrationsynccrmdata-mapping
Feature

Amazon DynamoDB: Role-based IAM Auth with External ID

Amazon DynamoDB destinations now support role-based IAM authentication with an External ID, preventing the confused deputy problem. Users can enable role-based auth via a toggle that generates a Fivetran-managed External ID to add to their AWS IAM trust policy, ensuring only their Fivetran account can assume the role.

dynamodbiamauthawssecurity
Announcement

Streamlining Fivetran Activations - Upcoming Integration Changes

Census Activations are transitioning to operate as a native Fivetran feature with changes to UI, API, access controls, and cloud infrastructure. Most customers require no immediate action, but API users should plan for migration to new endpoints before Q3 2026 deprecation.

activationsfivetranapibreakingmigration
Improvement

LinkedIn Ads: IPv4 Address and GAID as Conversion Identifiers

The LinkedIn Ads connector now supports IPv4 Address and GAID (Google Advertising ID) as identifiers for Conversion Event syncs, expanding available matching options for better campaign tracking.

linkedin-adsconnectorsconversion-trackingidentifiers
Announcement

Enforcing Audience Hub access

Census is restricting Audience Hub access to Enterprise and Business Critical plans starting June 9th, 2026. Existing activation syncs will continue working, but new syncs and segments cannot be created unless customers upgrade their Fivetran plan.

audience-hubbillingplansfeature-accessannouncement
Improvement

HTTP Request Object: per-sync custom headers

HTTP Request object syncs now support per-sync custom headers on the HTTP Request destination and within NetSuite and HubSpot integrations, allowing more flexible request customization.

httprequestsheadersnetsuitehubspot
Improvement

HTTP Request: JSON Body Support on DELETE

DELETE syncs in the HTTP Request destination now support JSON and URL-encoded request bodies, expanding the types of integrations and APIs that can be called during deletion operations.

http-requestapideleteintegrations
Announcement

Activations User List and Invitation APIs deprecated

The Users and Invitation organization endpoints in the Fivetran Activations API have been deprecated in favor of Fivetran's core Users endpoints, which offer expanded functionality including invitation generation and account-level role management. Developers should plan to use both API keys in parallel during the transition to the standard Fivetran auth mechanisms.

apiactivationsauthdeprecationusers
Improvement

Microsoft Dynamics now supports Service Principal Authentication

The Microsoft Dynamics connector now supports Service Principal (client credentials) authentication as an alternative to OAuth, giving users more flexibility in how they authenticate their connections.

microsoft-dynamicsauthenticationconnectoroauth
Feature

Owner roles can now assign custom roles

Workspace Owners in Fivetran Activations can now assign custom roles to workspace members, previously limited to account administrators. This improves access control management within Fivetran Activations workspaces.

rolespermissionsworkspaceaccess-controlfivetran-activations
Improvement

Zendesk V2 Custom Object Lookup Field Support

The Zendesk connector now supports lookup fields on v2 custom objects, allowing fields that reference other Zendesk objects like Users or Organizations to be mapped through a "Lookup by" option in the UI.

zendeskconnectorcustom-objectsmappinglookup
Improvement

LinkedIn Ads: Sync Multiple IDs for Customer Audiences

The LinkedIn Ads connector now supports syncing multiple customer identifiers (emails, ad IDs) at once, enabling better matching when contacts have multiple IDs on file.

linkedin-adsconnectorsaudiencesdata-sync
Feature

Trigger Activation Syncs from Fivetran Connections and Transformations

Activation syncs can now be triggered automatically when upstream Fivetran connections and transformations change. Configure these dependencies directly in your sync's trigger settings under the Fivetran tab with no additional setup required.

fivetranactivationsyncstriggersorchestration
Feature

Salesforce: FinancialAccount Object Support

The Salesforce connector now supports the FinancialAccount object for Salesforce Financial Services Cloud customers, enabling FSC users to sync financial account data.

salesforceconnectorfscobjects
Improvement

Userflow connector now supports EU region

The Userflow connector now supports EU region selection via a new Region dropdown in the connection setup UI. Existing connections default to US with no changes required.

userfloweu-regionconnectorinfrastructure
Improvement

Ortto: Multi-Region Support

The Ortto connector now supports regional API endpoints (US, AU, EU) that can be selected during connection setup. Existing connections default to US.

orttoconnectorsregionsapi
Improvement

Amazon Athena: Liquid Template Expression Support

The Amazon Athena connector now supports Liquid template expressions in sync mappings, allowing you to transform and combine source fields using Liquid syntax (e.g., {{ record['first_name'] }} {{ record['last_name'] }}) when syncing to your destination.

amazon-athenaconnectorsliquid-templatessync-mappingstransformation
Improvement

Freshsales: Dynamic Rate Limiting

The Freshsales connector now supports dynamic rate limiting that adapts to your account's API limits, improving reliability and sync performance.

freshsalesrate-limitingconnectorapireliability
Feature

New Ads Destination: Spotify Ads

Fivetran Activations now supports Spotify Ads as a destination, enabling businesses to sync customer data to build targeted audiences and track conversions across audio, video, and display ads.

adsdestinationactivationspotifyintegration
Improvement

X Ads: Additional Field Support for Web Conversions

The X Ads connector now supports ip_address and user_agent as optional fields for web conversions, enabling richer data collection and targeting capabilities.

x-adsconnectorsweb-conversionsfields
Improvement

Zendesk V2 Custom Object Support

The Zendesk connector now supports v2 custom objects. Zendesk will remove legacy custom objects on July 27, 2026, so users should migrate to ensure their syncs continue running.

zendeskconnectorscustom-objectsmigration
Announcement

Sunsetting Census Store, CSV Datasets, and Mesh Datasets

Census is deprecating Census Store and related features (CSV Datasets, Mesh Datasets, and Iceberg catalog access) as it unifies with Fivetran's data platform. Existing accounts will have read-only access from July 2026, and the service will shut down completely on August 1, 2026.

deprecationstoredatasetsmigrationfivetran
Announcement

Transactional Email Sender Updated

Transactional emails from Census are now sent from activation-support@fivetran.com instead of support@getcensus.com. Users with email filters or rules based on the sender address should update them to include both addresses.

emailnotificationsinfrastructure
Announcement

Retiring the Weekly Summary email

Census has disabled per-workspace weekly summary emails in preparation for integration into Fivetran, with an improved version planned for the future. If you have automated processes depending on the current email format, contact support to request re-enablement.

emailnotificationsdeprecationintegrations

Sign up to see more

30 more changes from Census. Sign up to read the whole changelog.

Sign up free

GitHub or email — no card needed.