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!
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
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
andPROJECT_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.