June 2025

Lite Connectors

Improved control over multi-value setup form fields

We have changed the behavior of the setup form fields that accept multiple values. You can now specify values for these fields only during the initial connection setup and cannot modify them after you set up the connection. This change ensures data integrity for your connections. If you want to change these field values for any existing connection, you have to set up a new connection with the updated values.

We have made this change to the following connectors and setup form fields:

CONNECTOR	FIELD
Akamai	Type Name
CJ Commission Detail	Company IDs
Clari	Forecast ID
Cloudbeds	Property ID
LINE Ads	Group ID
myosh	Server variable
Pigment	View ID
Qualaroo	Survey IDs
Rakuten Advertising	Report keys
Rarible	Collection Address
Sentry	Project IDs
SISTRIX	Domain
Statistics Netherlands CBS	Catalog identifier
Unicommerce	Facility code

Transformations for dbt Core

Account-level transformations

The transformation list now has items from all groups of the account the current user has access to. Adding a transformation to any destination of the account is now possible without switching the group The new "Manage projects" page containing all connected dbt projects in the account is now available

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

Schema changes

Aha!

Effective June 13, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to improve its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name
`GOAL`
column	Discontinued Column	`parent_id`
`GOAL_PARENT`
table	New Table		`GOAL_PARENT`

Braintree

We've added the following columns to the ANDROID_PAY_DETAILS table:

commercial
country_of_issuance
debit
healthcare
issuing_bank
payroll
prepaid

We've added the following columns to the APPLE_PAY_CARD table:

bin
commercial
country_of_issuance
debit
healthcare
issuing_bank
payroll
prepaid

Braze

We've added the created_at column to the USER table. This column contains the timestamp of when the user profile was created in Braze, in ISO 8601 format.

This allows you to better track the lifecycle of users and analyze registration patterns and tenure across your Braze user base.

Front

Front will sunset the Group API and replace it with the List API on September 1, 2025. To support the API change, we have added a new table, LIST. We'll continue to sync to both GROUP and LIST tables. We'll stop syncing data to the GROUP table effective September 6, 2025.

Mavenlink

We've added the provider_lead_name column to the WORKSPACE table.

This column contains the name of the team lead for the provider side of the project. This addition improves visibility into project ownership and team structure.

Microsoft Dynamics 365 CRM

We have added a new column, renamed_attributename, to the STRINGMAP table. The column contains the values of attributename that are renamed according to the destination renaming rules. For more information, see our documentation.

Pipe17

Effective June 6, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to enhance its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

18 total changes • 17 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ARRIVAL_LINE_ITEM`
column	Primary Key Change	`arrival_id`	`arrival_id` 🔑	Added to primary key.
`CONNECTOR_ENTITY`
column	Primary Key Change	`connector_id`	`connector_id` 🔑	Added to primary key.
`FULFILLMENT_LINE_ITEM`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
column	Primary Key Change	`sku`	`sku` 🔑	Added to primary key.
column	New Column		`bundle_quantity_partial`
`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`
table	Discontinued Table	`FULFILLMENT_LINE_ITEM_BUNDLE_QUANTITY_PARTIAL`		Data is available in the `bundle_quantity_partial` column of the `FULFILLMENT_LINE_ITEM` table.
`FULFILLMENT_TRACKING_NUMBER`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`FULFILLMENT_TRACKING_URL`
column	Primary Key Change	`fulfillment_id`	`fulfillment_id` 🔑	Added to primary key.
`ORDER_DISCOUNT`
column	Primary Key Change	`line_item_id` 🔑	`line_item_id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PRODUCT_PUBLISHED`
column	Primary Key Change	`sku` 🔑	`sku`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`PURCHASE_LINE_ITEM`
column	Primary Key Change	`purchase_id`	`purchase_id` 🔑	Added to primary key.
`RECEIPT_LINE_ITEM`
column	Primary Key Change	`receipt_id`	`receipt_id` 🔑	Added to primary key.
`SHIPMENT_LINE_ITEM`
column	Primary Key Change	`shipment_id`	`shipment_id` 🔑	Added to primary key.
`SHIPPING_METHOD_MAPPED_METHOD`
column	Primary Key Change	`shipping_method_id`	`shipping_method_id` 🔑	Added to primary key.
`SUPPLIER_CONTACT`
column	Primary Key Change	`supplier_id`	`supplier_id` 🔑	Added to primary key.
`TRANSFER_LINE_ITEM`
column	Primary Key Change	`transfer_id`	`transfer_id` 🔑	Added to primary key.

Qualtrics

We have made the following improvements to the QUESTION_RESPONSE table:

Added a new column, text, to store the values that respondents enter in the text boxes associated with the Other option in Qualtrics. The new column avoids the creation of multiple records for such values.
We have fixed a bug where the question_option_key column incorrectly stored the recode value of a question option. We now correctly map the recode value to the corresponding question option key before storing it.

We are gradually rolling out these changes to all existing connections.

SmartHR

Effective June 3, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to align with source changes.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

3 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name
`EMPLOYEE`
column	Discontinued Column	`department`
column	Discontinued Column	`position`
`EMPLOYEE_POSITION`
table	New Table		`EMPLOYEE_POSITION`

Square

We've added the disputed_payment_id column to the DISPUTE table.

This column contains the Square-generated unique ID of the payment that was disputed, providing a direct foreign key reference to the PAYMENT table.

Transcend

Effective June 4, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to support a feature enhancement.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

81 total changes • 54 possible breaking changes

Table/column	Change type	Old name	New name
`ACTIVITY`
table	New Table		`ACTIVITY`
`ASSESSMENT_FILE`
table	New Table		`ASSESSMENT_FILE`
`ASSESSMENT_FORM`
table	New Table		`ASSESSMENT_FORM`
`ASSESSMENT_FORM_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_ASSIGNEE`
`ASSESSMENT_FORM_ATTRIBUTE_VALUE`
table	New Table		`ASSESSMENT_FORM_ATTRIBUTE_VALUE`
`ASSESSMENT_FORM_COMMENT`
table	New Table		`ASSESSMENT_FORM_COMMENT`
`ASSESSMENT_FORM_EXTERNAL_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_EXTERNAL_ASSIGNEE`
`ASSESSMENT_FORM_REVIEWER`
table	New Table		`ASSESSMENT_FORM_REVIEWER`
`ASSESSMENT_FORM_SECTION`
table	New Table		`ASSESSMENT_FORM_SECTION`
`ASSESSMENT_FORM_SECTION_QUESTION`
table	New Table		`ASSESSMENT_FORM_SECTION_QUESTION`
`ASSESSMENT_FORM_TEMPLATE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE`
`ASSESSMENT_FORM_TEMPLATE_ATTRIBUTE_KEY`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_ATTRIBUTE_KEY`
`ASSESSMENT_FORM_TEMPLATE_SECTION`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION`
`ASSESSMENT_FORM_TEMPLATE_SECTION_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_ASSIGNEE`
`ASSESSMENT_FORM_TEMPLATE_SECTION_EXTERNAL_ASSIGNEE`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_EXTERNAL_ASSIGNEE`
`ASSESSMENT_FORM_TEMPLATE_SECTION_QUESTION`
table	New Table		`ASSESSMENT_FORM_TEMPLATE_SECTION_QUESTION`
`ASSESSMENT_GROUP`
table	New Table		`ASSESSMENT_GROUP`
`ASSESSMENT_GROUP_ATTRIBUTE_VALUE`
table	New Table		`ASSESSMENT_GROUP_ATTRIBUTE_VALUE`
`ASSESSMENT_GROUP_REVIEWER`
table	New Table		`ASSESSMENT_GROUP_REVIEWER`
`ASSESSMENT_QUESTION`
table	New Table		`ASSESSMENT_QUESTION`
`ASSESSMENT_QUESTION_ANSWER_OPTION`
table	New Table		`ASSESSMENT_QUESTION_ANSWER_OPTION`
`ASSESSMENT_QUESTION_COMMENT`
table	New Table		`ASSESSMENT_QUESTION_COMMENT`
`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION`
table	New Table		`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION`
`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION_ANSWER`
table	New Table		`ASSESSMENT_QUESTION_PREVIOUS_SUBMISSION_ANSWER`
`ASSESSMENT_QUESTION_SELECT_OPTION`
table	New Table		`ASSESSMENT_QUESTION_SELECT_OPTION`
`ASSESSMENT_QUESTION_SELECTED_ANSWER`
table	New Table		`ASSESSMENT_QUESTION_SELECTED_ANSWER`
`ASSESSMENT_SECTION_COMMENT`
table	New Table		`ASSESSMENT_SECTION_COMMENT`
`COOKIE`
column	Discontinued Column	`avc_email_verified`
column	Discontinued Column	`business_user_overview`
column	Discontinued Column	`consent_do_not_sell_integration`
column	Discontinued Column	`controller_manual_instructions`
column	Discontinued Column	`datapoints_customizable`
column	Discontinued Column	`disqualification_reasons`
column	Discontinued Column	`form_config`
column	Discontinued Column	`has_api_functionality`
column	Discontinued Column	`has_avc_functionality`
column	Discontinued Column	`has_content_classification_functionality`
column	Discontinued Column	`has_plugins`
column	Discontinued Column	`has_silo_discovery_functionality`
column	Discontinued Column	`has_usp_api_support`
column	Discontinued Column	`hero_background_color`
column	Discontinued Column	`hero_image_url`
column	Discontinued Column	`integration_status`
column	Discontinued Column	`intro_message`
column	Discontinued Column	`is_complete`
column	Discontinued Column	`is_featured`
column	Discontinued Column	`is_prompt_avendor_compatible`
column	Discontinued Column	`is_suggested`
column	Discontinued Column	`minimum_sombra_version`
column	Discontinued Column	`plain_text`
column	Discontinued Column	`prompt_avendor_email_address`
column	Discontinued Column	`prompt_email_template_id`
column	Discontinued Column	`see_other_integrations`
column	Discontinued Column	`website`
`DATA_FLOW`
column	Discontinued Column	`avc_email_verified`
column	Discontinued Column	`business_user_overview`
column	Discontinued Column	`consent_do_not_sell_integration`
column	Discontinued Column	`controller_manual_instructions`
column	Discontinued Column	`datapoint_customizable`
column	Discontinued Column	`disqualification_reasons`
column	Discontinued Column	`form_config`
column	Discontinued Column	`has_api_functionality`
column	Discontinued Column	`has_avc_functionality`
column	Discontinued Column	`has_content_classification_functionality`
column	Discontinued Column	`has_plugin`
column	Discontinued Column	`has_silo_discovery_functionality`
column	Discontinued Column	`has_usp_api_support`
column	Discontinued Column	`hero_background_color`
column	Discontinued Column	`hero_image_url`
column	Discontinued Column	`integration_status`
column	Discontinued Column	`intro_message`
column	Discontinued Column	`is_complete`
column	Discontinued Column	`is_featured`
column	Discontinued Column	`is_prompt_avendor_compatible`
column	Discontinued Column	`is_suggested`
column	Discontinued Column	`minimum_sombra_version`
column	Discontinued Column	`plain_text`
column	Discontinued Column	`prompt_avendor_email_address`
column	Discontinued Column	`prompt_email_template_id`
column	Discontinued Column	`see_other_integrations`
column	Discontinued Column	`website`

Twilio

We have added a new column, attributes, to the PARTICIPANT table.

VWO

Effective June 13, 2025 we use a new June 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migration article for more details.

We are updating the connector schema to enhance its usability.

You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.

2 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`GOAL`
column	New Column		`urls`
`GOAL_URL`
table	Discontinued Table	`GOAL_URL`		Data is available as a JSON object in the `urls` column of the `GOAL` table.

Workday HCM

We have added a new column, id_type, to the PERSON_IDENTITY_DOCUMENT table.

We have made the following schema changes to the ASSESS_TALENT_NOMINATION table:

Added a new primary key column, index
Removed the jobProfileId column from the composite primary key

Zendesk Support

We have added the following new columns to the GROUP table:

default
description
is_public

Improvements

Google Calendar

We have changed our sync strategy and now incrementally sync the EVENT table and its child tables. Previously, we re-imported the table.

We are gradually rolling out this change to all existing connections.

We have changed the sync strategy for the SETTING table. We now re-import the table once a week. Previously, we re-imported it during every sync.

We are gradually rolling out this change to all existing connections.

Gorgias

Effective June 10, 2025 we no longer perform a monthly re-import of the TICKET table to capture deletes. We now detect and sync deleted records for this table without re-importing it.

PostgreSQL

We now support syncing the "BIT" data type as STRING. See all supported data types in our PostgreSQL documentation.

Redshift

We have added support for the SUPER data type to store JSON data. For source connections of accounts created after June 12, 2025, we convert JSON data type to SUPER data type in your Redshift destination. For more information about how to parse your JSON data from Redshift destinations, see our Redshift documentation.

Sentry

We have made the following changes to the sync strategy for Sentry connections:

We now re-import the following tables once a month instead of weekly:
- ORGANIZATION_RELEASE
- ORGANIZATION_TEAM
- PROJECT_RELEASE_FILE
- PROJECT_SERVICE_HOOK
We no longer re-import the PROJECT_ERROR_EVENT and PROJECT_ISSUE tables on a weekly basis.

Snapchat Ads

The Snapchat Ads connector now lets you select individual accounts to sync, instead of selecting entire organizations.

Snowflake

We now support Google Cloud Storage as an external stage for unstructured files. We have updated the destination setup form and changed the Storage for Unstructured Files toggle to a drop-down menu.

Stripe

We have changed the sync strategy for the COUPON table to prevent service disruptions caused by Stripe API's rate limits. We no longer re-import the table every week. Instead, we re-import the table only when you manually re-sync it.

Zendesk Support

We have added option, Max Zendesk API usage (%), to the connection setup form. This option allows you to set the percentage of the API rate limit you want Fivetran to use. For more information, see our setup instructions.