September 2025
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.2.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Fix in inference for
booleandata type, to identify as boolean and not int. - Minor improvements and enhancements.
We have released version 2.1.1 of the fivetran-connector-sdk PyPI package. This release adds support for Python version 3.13. All new connections default to Python 3.13 unless the version is specified in the connector code.
We have released version 2.1.0 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Support for using pipreqs-fivetran to generate requirements.txt
- Minor fixes and improvements
We have released version 2.0.2 of the fivetran-connector-sdk PyPI package. This release adds the following:
- Improved logging
- Updated tester performance
- Minor fixes and improvements
Lite Connectors
Lite connectors are now available for the following sources:
Improvements to re-sync strategy
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records. We are gradually rolling out this improvement to all connections.
This change applies to the following tables of the connectors below:
| Connector | Tables |
|---|---|
| 7shifts | RECEIPT_TIP_DETAIL, RECEIPT_LINE, RECEIPT, and RECEIPT_LINE_EXTERNAL_CATEGORY. |
| Ada | MESSAGE_SELECTED, MESSAGE_QUICK_REPLY, CONVERSATION_FEEDBACK, MESSAGE, CONVERSATION, and MESSAGE_SELECT_TABLE. |
| Affinity | INTERACTION_EMAIL_TO, INTERACTION_MEETING_ATTENDEE, INTERACTION_EMAIL, INTERACTION_MEETING, INTERACTION_CALL_PERSON, INTERACTION_CALL_ATTENDEE, INTERACTION_MEETING_NOTE, INTERACTION_CHAT, REMINDER, INTERACTION_CHAT_NOTE, INTERACTION_CALL, INTERACTION_CHAT_PERSON, INTERACTION_CALL_NOTE, and INTERACTION_MEETING_PERSON. |
| Aircall | CALL_TAG, CALL, CALL_COMMENT, CALL_TEAM, and CALL_PARTICIPANT. |
| Amazon Attribution | PERFORMANCE_REPORT_BY_CREATIVE, PERFORMANCE_REPORT_BY_CAMPAIGN, PERFORMANCE_REPORT_BY_ADGROUP, and PRODUCT_REPORT. |
| Appfigures | SUBSCRIPTION, AD_REPORT, REVENUE, ESTIMATE, PAYMENT, SALE, and ADVERTISEMENT_SPEND. |
| Aura from Unity | ADVERTISER_REPORT |
| Bitly | LINK_CLICK |
| Brightcove | LIVE_ANALYTICS_TIME_SERIES_SECOND_VIEWED_DATA_POINT, LIVE_ANALYTICS_TIME_SERIES_CCU_DATA_POINT, LIVE_ANALYTICS_TIME_SERIES_VIDEO_IMPRESSION_DATA_POINT, VIDEO_ENGAGEMENT_VALUE, VIDEO_ENGAGEMENT, LIVE_ANALYTICS_TIME_SERIES_VIDEO_VIEW_DATA_POINT, and LIVE_ANALYTICS_TIME_SERIES_FINGERPRINT_COUNT_DATA_POINT. |
| Brivo | ACCESS_EVENT, AUDIT_EVENT, and AUDIT_EVENT_PROPERTY_CHANGE. |
| Buildkite | AGENT, BUILD_JOB_AGENT_QUERY_RULE, BUILD_JOB, BUILD, and AGENT_METADATA. |
| CallRail | SUMMARIZED_CALL and CALL. |
| Clari | ACTOR and ITEM. |
| Cloudflare Analytics | CPU_TIME, REQUEST_GROUP, and IMAGE_RESIZE_REQUEST. |
| Cvent | EMAIL |
| Datadog | SERVICE_LEVEL_OBJECTIVE_HISTORY_NUMERATOR_VALUE_UNIT, SERVICE_LEVEL_OBJECTIVE_HISTORY_NUMERATOR_VALUE, SERVICE_LEVEL_OBJECTIVE_HISTORY, SERVICE_LEVEL_OBJECTIVE_HISTORY_MONITOR, SERVICE_LEVEL_OBJECTIVE_HISTORY_GROUPS, LOG, SERVICE_LEVEL_OBJECTIVE_HISTORY_DENOMINATOR_VALUE_UNIT, SERVICE_LEVEL_OBJECTIVE_HISTORY_SERIES_TIME, HOURLY_USAGE_ATTRIBUTION, SERVICE_LEVEL_OBJECTIVE_HISTORY_THRESHOLD, SERVICE_LEVEL_OBJECTIVE_HISTORY_DENOMINATOR_VALUE, and RUM_EVENT. |
| eBay | ORDER_HISTORY, ORDERS_PAYMENT_HOLD, ORDERS_LINE_ITEM, ORDERS_LINE_ITEM_REFUND, ORDERS_LINE_ITEM_TAX, ORDERS_PAYMENT, ORDERS_LINE_ITEM_VARIATION_ASPECT, ORDERS_PAYMENT_REFUND, ORDERS_FULFILLMENT_START_INSTRUCTION, and ORDERS_LINE_ITEM_PROMOTION. |
| Everflow | CONVERSION_REPORT |
| Fountain | USER_ACTIVITY |
| Freshchat | CONVERSATION_METRICS |
| Freshdesk Contact Center | LIFECYCLE |
| FullStory | SEGMENT_EVENT |
| G2 | EVENT_STREAM, SURVEY_RESPONSE, and ANSWER. |
| Gladly | HELP_CENTER_ANSWER_USAGE_REPORT, GLAD_APP_CONTACT_POINT_REPORT, WORK_SESSION_REPORT, AGENT_STATUS_EVENT, TASK_SUMMARY_REPORT, CONTACT_EVENT, AGENT_AVAILABILITY_EVENT, GLAD_APP_ANSWER_USAGE_REPORT, TASK_EVENT, AGENT_SUMMARY_GLANCE_REPORT, CONVERSATION, GLAD_APP_ANSWER_SEARCH_REPORT, CONTACT_EXPORT_REPORT_V_3, CUSTOMER_PHONE, CUSTOMER_EVENT, CONTACT_TIMESTAMP_REPORT, QUICK_ACTION_USAGE_REPORT, PAYMENT_REQUEST_EVENT, TASK_TIMESTAMPS_REPORT, AGENT_TIMESTAMPS_REPORT, CUSTOMER_EMAIL, TASK_EXPORT_REPORT, AGENT_DURATION_REPORT, CONVERSATION_EXPORT_REPORT, CONVERSATION_TOPIC, andCUSTOMER. |
| Helpshift | ANALYTIC_CUSTOM_BOT, ANALYTIC_SUPPORT, ANALYTIC_OPEN_ISSUE, ANALYTIC_CUSTOM_BOT_STEP, ANALYTIC_ISSUE_TAG, ANALYTIC_FAQ,ANALYTIC_AGENT, ANALYTIC_AGENT_GROUP, and ANALYTIC_ISSUE. |
| Integral Ad Science | MEDIA_PARTNER, REPORT, CAMPAIGN, and PLACEMENT. |
| Jama Software | ACTIVITY, ATTACHMENT, TEST_RUN_BASELINED_APPLIED_CATEGORY_SNAPSHOT, ITEM,TEST_CYCLE, TEST_RUN_GROUP, and TEST_RUN. |
| JustCall | CALL_AI_TAG, SALE_DIALER_CAMPAIGN, SALES_DIALER_ANALYTICS, TEXT, SALES_DIALER_CALL, SALES_DIALER_CALL_AI_MOMENT, CALL, TEXT_MMS, SALES_DIALER_CALL_AI_TAG, CALL_AI_MOMENT, and CALL_INFO_TRAIT. |
| Khoros Care | RESPONSE_REPORT, COMBINED_REPORT, TEAM_PERFORMANCE_REPORT, CONVERSATION_ACTION_HISTORY_REPORT, INCOMING_POST_REPORT, CONVERSATION_REPORT, RESPONSE_APPROVAL_REPORT, HELP_REQUEST_REPORT, USER_REPORT, and TEAM_PERFORMANCE_INTERVAL. |
| Khoros Communities | EXPORT_COMMUNITY_LABEL, REQUEST_HEADER_REFERRER_URL, PRODUCT_TAG, REQUEST_HEADER_REFERRER_HOST, and EXPORT_COMMUNITY. |
| Khoros Marketing | AD_NET_VALUE, STREAM_ITEM_DATA, PUBLISHED_POST, DAILY_SUMMARY, PROFILE, STREAM_ITEM_ACTION, ACCOUNT, and CUSTOMER_FEEDBACK. |
| Moloco | AD_PERFORMANCE_ANALYTICS |
| Mux | ERROR |
| PandaDoc | DOCUMENT_PRICING_QUOTE_SECTION, DOCUMENT_TAG, DOCUMENT_PRICING_QUOTE_SECTION_RECURRING_SUBTOTAL, DOCUMENT, DOCUMENT_PRICING_QUOTE_MERGE_RULE, DOCUMENT_LINKED_OBJECT, DOCUMENT_PRICING_TABLE_COLUMN, DOCUMENT_PRICING_QUOTE_RECURRING_SUBTOTAL, DOCUMENT_PRICING_TABLE, DOCUMENT_TOKEN, DOCUMENT_RECIPIENT_ROLE, DOCUMENT_PRICING_TABLE_ITEM, DOCUMENT_PRICING_QUOTE_MERGE_RULE_CONDITION_COMPARISON, DOCUMENT_PRICING_QUOTE, DOCUMENT_PRICING_QUOTE_SECTION_COLUMN, DOCUMENT_FIELD, DOCUMENT_RECIPIENT, and DOCUMENT_PRICING_QUOTE_SECTION_ITEM. |
| Phoenix Ads | REPORT |
| Pinterest Organic | PIN_ANALYTICS, USER_ACCOUNT_TOP_VIDEO_PIN_ANALYTICS, USER_ACCOUNT_ANALYTIC_DAILY_METRIC, USER_ACCOUNT_ANALYTICS, USER_ACCOUNT_TOP_PIN_ANALYTICS, andPIN_ANALYTIC_DAILY_METRIC. |
| Placer.ai | VISIT_BY_HOUR and VISIT_BY_OPENING_HOUR. |
| Planful | GL_DATA_ACTUAL_SCENARIO and GL_DATA. |
| RevX | RTB_REPORT |
| RTB House | CONVERSION_ALL_POST_CLICK, CONVERSION_ATTRIBUTED, CONVERSION_POST_VIEW, and CONVERSION_ALL. |
| Samsara | ALERT_INCIDENT_CONDITIONS and ALERT_INCIDENT. |
| ShareASale | WEEKLY_PROGRESS and TRANSACTION. |
| Sharetribe | EVENT and AVAILABILITY_EXCEPTION. |
| Short.io | DOMAIN_STATISTICS_OS, DOMAIN_STATISTICS, LINK_STATISTICS_COUNTRY, DOMAIN_STATISTICS_CITY, DOMAIN_STATISTICS_REFERER, DOMAIN_STATISTICS_COUNTRY, LINK_TAG, LINK_STATISTICS_CITY, LINK_STATISTICS_REFERER, LINK, LINK_STATISTICS_OS, DOMAIN_STATISTICS_SOCIAL, LINK_STATISTICS_SOCIAL, LINK_STATISTICS_BROWSER, LINK_STATISTICS, and DOMAIN_STATISTICS_BROWSER. |
| SkuVault | TRANSACTION |
| SparkPost | DELAY_REASON_METRICS, ENGAGEMENT_DETAIL, DELIVERIES_BY_ATTEMPT, DELIVERABILITY_METRICS, EVENT_SMS_REMOTE, BOUNCE_METRICS, REJECTION_REASON_METRICS, EVENT, and EVENT_RCPT_TAG. |
| Teads | REPORT_BUDGET, REPORT_LUMEN, REPORT_SCOPE, REPORT_VIDEO, REPORT_MOAT, REPORT_VIDEO_PROGRESS, and REPORT_DISPLAY_PROGRESS. |
| Tempo | TIMESHEET_APPROVAL |
| TikTok Organic | PROFILE, PROFILE_AUDIENCE_COUNTRY, PROFILE_AUDIENCE_AGE, PROFILE_METRIC_AUDIENCE_ACTIVITY, PROFILE_METRIC, PROFILE_AUDIENCE_CITY, and PROFILE_AUDIENCE_GENDER. |
| Toggl Track | PROJECT and TASK. |
| Udemy Business | USER_COURSE_ACTIVITY and USER_ACTIVITY. |
| Walmart Marketplace | ORDER_LINE_STATUS, LABEL_DETAIL_BY_PURCHASE_ORDER, ORDERS, ORDER_LINE, LABEL_DETAIL_BOX_ITEM, ORDER_PICKUP_PERSON, ORDER_LINE_REFUND_CHARGE, ORDER_LINE_CHARGE, and LABEL_DETAIL_ADD_ON. |
| Wicked Reports | ORDER_PAYMENT, CONTACT, ORDERS, CLICK, and ORDER_PRODUCT. |
| Wrike | COMMENT |
| Yahoo Display Ads on Yahoo Japan | AD and REACH. |
| Zoom | DASHBOARD_MEETING_TRACKING_FIELD, DASHBOARD_WEBINAR_CUSTOM_KEY, PHONE_SMS_MMS_CHARGE_USAGE_REPORT, PHONE_CALL_HISTORY, DASHBOARD_WEBINAR, DASHBOARD_MEETING_CUSTOM_KEY, PHONE_CALL_CHARGE_USAGE_REPORT, and DASHBOARD_MEETING. |
Transformations for dbt Core
dbt Core versions 1.9.10 and 1.10.11 support
We now support dbt Core* versions 1.9.10 and 1.10.11. You can use these versions to run your projects.
For these dbt Core versions, we don't support MySQL and Azure Synapse destinations. These destinations are not currently supported by the custom dbt Core adapters.
* 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.
Updated dbt Quickstart packages
We have updated the Quickstart packages for the following connectors:
- Amazon Selling Partner to version 0.2.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
- Qualtrics to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 18, 2025.
- QuickBooks to version 0.21.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
- Recharge to version 1.1.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 20, 2025.
- Reddit Ads to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 12, 2025.
- SAP ERP on HANA to version 0.3.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
- Shopify to version 0.22.0. We are gradually rolling out this change. All Quickstart transformations will be updated by October 22, 2025.
- Zendesk Support to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by October 13, 2025.
Schema changes
Adobe Workfront
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PORTFOLIO | |||||
| table | New Table | PORTFOLIO | |||
PORTFOLIO_CUSTOM_VALUE | |||||
| table | New Table | PORTFOLIO_CUSTOM_VALUE | |||
PROGRAM_CUSTOM_VALUE | |||||
| table | New Table | PROGRAM_CUSTOM_VALUE | |||
PROJECT_CUSTOM_VALUE | |||||
| table | New Table | PROJECT_CUSTOM_VALUE | |||
ADP Workforce Now
We have added the following child tables to the WORKER_TIME_CARD table:
WORKER_TIME_CARD_DAY_ENTRYWORKER_TIME_CARD_TIME_ENTRYWORKER_TIME_CARD_LABOR_ALLOCATIONWORKER_TIME_CARD_ENTRY_TOTAL
We are gradually rolling out this change to all connections.
Akeneo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
REFERENCE_ENTITY_ATTRIBUTE_OPTION | |||||
| column | Primary Key Change | reference_entity_attribute_code | reference_entity_attribute_code 🔑 | Added to primary key. | |
REFERENCE_ENTITY_RECORD | |||||
| column | Primary Key Change | reference_entity_code | reference_entity_code 🔑 | Added to primary key. | |
Appcues
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BANNER | |||||
| table | New Table | BANNER | |||
BANNER_STEP | |||||
| table | New Table | BANNER_STEP | |||
BANNER_STEP_TRAIT | |||||
| table | New Table | BANNER_STEP_TRAIT | |||
BANNER_TRAIT | |||||
| table | New Table | BANNER_TRAIT | |||
CHECKLIST | |||||
| table | New Table | CHECKLIST | |||
LAUNCH_PAD | |||||
| table | New Table | LAUNCH_PAD | |||
LAUNCH_PAD_STEP | |||||
| table | New Table | LAUNCH_PAD_STEP | |||
LAUNCH_PAD_TRAIT | |||||
| table | New Table | LAUNCH_PAD_TRAIT | |||
TAGS | |||||
| table | New Table | TAGS | |||
Apple App Store
We have added the following new tables:
SALES_WIN_BACK_ELIGIBILITYto store the win-back offer eligibility data for churned subscription customers.SALES_PRE_ORDER_SUMMARYcontains pre-order sales data from Apple's App Store Connect, allowing you to track and analyze pre-order performance across different time frequencies.
We are gradually rolling out these changes to all existing connections.
Brivo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
USER_CUSTOM_FIELD | |||||
| table | New Table | USER_CUSTOM_FIELD | |||
CallRail
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
FORM_SUBMISSION | |||||
| column | Discontinued Column | best_time_to_call | Data is available in the custom_best_time_to_call column. | ||
| column | Discontinued Column | contact_method | Data is available in the custom_contact_method column. | ||
| column | Discontinued Column | date_of_accident | Data is available in the custom_date_of_accident column. | ||
| column | Discontinued Column | email | Data is available in the custom_email column. | ||
| column | Discontinued Column | gclid | Data is available in the custom_gclid column. | ||
| column | Discontinued Column | name | Data is available in the custom_name column. | ||
| column | Discontinued Column | phone | Data is available in the custom_phone column. | ||
| column | Discontinued Column | tell_us_about_your_case | Data is available in the custom_tell_us_about_your_case column. | ||
| column | Discontinued Column | thank_you_message | Data is available in the custom_thank_you_message column. | ||
| column | Discontinued Column | thank_you_message_timeout | Data is available in the custom_thank_you_message_timeout column. | ||
| column | New Column | custom_* | |||
| column | New Column | customer_email | |||
| column | New Column | customer_phone_number | |||
| column | New Column | formatted_customer_phone_number | |||
Coupa
We have added a new column, rejected, to the EASY_FORM_DATA table.
Criteo
We have added two new reporting tables, AD_STATISTICS_DAILY_REPORT and CAMPAIGN_STATISTICS_DAILY_REPORT. We are gradually rolling out this change to all existing connections.
Cvent
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTACT | |||||
| column | New Column | source_id | |||
Deposco
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SHIPMENT | |||||
| column | Discontinued Column | container_depth_uom | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_description | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_lpn | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_status | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_total_charge | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_tracking_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | container_type | Column moved to the shipment_line table. | ||
| column | Discontinued Column | dimension_height | Column moved to the shipment_line table. | ||
| column | Discontinued Column | dimension_length | Column moved to the shipment_line table. | ||
| column | Discontinued Column | dimension_unit | Column moved to the shipment_line table. | ||
| column | Discontinued Column | dimension_volume | Column moved to the shipment_line table. | ||
| column | Discontinued Column | dimension_width | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_customer_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_expiration_date | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_item_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_lot_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_order_pack_quantity | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_shipment_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_shipped_pack_quantity | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_status | Column moved to the shipment_line table. | ||
| column | Discontinued Column | line_tracking_number | Column moved to the shipment_line table. | ||
| column | Discontinued Column | pack_custom_mapping_nil | Column moved to the shipment_line table. | ||
| column | Discontinued Column | pack_dimension_nil | Column moved to the shipment_line table. | ||
| column | Discontinued Column | pack_quantity | Column moved to the shipment_line table. | ||
| column | Discontinued Column | pack_type | Column moved to the shipment_line table. | ||
| column | Discontinued Column | pack_upcs_nil | Column moved to the shipment_line table. | ||
| column | Discontinued Column | unit | Column moved to the shipment_line table. | ||
| column | Discontinued Column | weight | Column moved to the shipment_line table. | ||
SHIPMENT_LINE | |||||
| table | New Table | SHIPMENT_LINE | |||
Drata
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DEVICE | |||||
| column | Discontinued Column | admin | |||
| column | Discontinued Column | agent_version | |||
| column | Discontinued Column | graphics | |||
| column | Discontinued Column | hdd_size | |||
| column | Discontinued Column | memory | |||
| column | Discontinued Column | processor | |||
| column | Discontinued Column | type | |||
| column | New Column | antivirus_enabled | |||
| column | New Column | antivirus_explanation | |||
| column | New Column | asset_id | |||
| column | New Column | auto_update_enabled | |||
| column | New Column | auto_update_explanation | |||
| column | New Column | encryption_explanation | |||
| column | New Column | external_id | |||
| column | New Column | firewall_explanation | |||
| column | New Column | password_manager_enabled | |||
| column | New Column | password_manager_explanation | |||
| column | New Column | personnel_id | |||
| column | New Column | screen_lock_explanation | |||
| column | New Column | user_id | |||
DEVICE_COMPLIANCE_CHECK | |||||
| column | Discontinued Column | compliant | |||
| column | Discontinued Column | types | |||
| column | New Column | status | |||
DEVICE_IDENTIFIER | |||||
| column | Discontinued Column | types | |||
USER_BACKGROUND_CHECK | |||||
| column | Discontinued Column | type | |||
USER_IDENTITY | |||||
| column | New Column | first_name | |||
| column | New Column | is_contractor | |||
| column | New Column | job_title | |||
| column | New Column | last_name | |||
| column | New Column | manager_id | |||
| column | New Column | manager_name | |||
| column | New Column | secondary_email | |||
| column | New Column | separated_at | |||
| column | New Column | started_at | |||
USERS | |||||
| column | Discontinued Column | table_name | |||
| column | Discontinued Column | type | |||
| column | New Column | entry_id | |||
Flywheel Digital
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SEARCH_TERM | |||||
| column | New Column | weight | |||
Gladly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AGENT_SUMMARY_GLANCE_REPORT | |||||
| table | New Table | AGENT_SUMMARY_GLANCE_REPORT | |||
Infobip
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
MESSAGE | |||||
| column | New Column | author_id | |||
| column | New Column | author_type | |||
Iterable
We have added a new table, JOURNEY. We are gradually rolling out this change to all existing connections starting September 17, 2025.
Jira
We've changed the data type of the id column in the ASSET_REFERENCE_TYPE table from INTEGER to STRING.
JustCall
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTACT | |||||
| column | Discontinued Column | company | |||
| column | Discontinued Column | firstname | |||
| column | Discontinued Column | lastname | |||
| column | Discontinued Column | notes | |||
| column | Discontinued Column | phone | |||
| column | New Column | address | |||
| column | New Column | birthday | |||
| column | New Column | created_at | |||
| column | New Column | name | |||
| column | New Column | occupation | |||
| column | New Column | phone_number | |||
| column | New Column | status | |||
| column | New Column | status_updated_at | |||
CONTACT_CUSTOM_FIELD | |||||
| table | New Table | CONTACT_CUSTOM_FIELD | |||
CONTACT_OTHER_PHONES | |||||
| table | Discontinued Table | CONTACT_OTHER_PHONES | |||
GROUPS | |||||
| table | New Table | GROUPS | |||
PHONE_NUMBER | |||||
| column | Discontinued Column | agent_id | |||
| column | Discontinued Column | capabilities_fax | |||
| column | Discontinued Column | capabilities_voice | |||
| column | Discontinued Column | custom_name | |||
| column | Discontinued Column | friendly_name | |||
| column | Discontinued Column | phone | |||
| column | New Column | availability_setting | |||
| column | New Column | business_registration | |||
| column | New Column | capabilities_call | |||
| column | New Column | current_status | |||
| column | New Column | friendly_number | |||
| column | New Column | justcall_line_name | |||
| column | New Column | justcall_number | |||
| column | New Column | number_owner_id | |||
| column | New Column | number_type | |||
| column | New Column | sms_compliance | |||
PHONE_NUMBER_TEAM_MEMBER | |||||
| table | New Table | PHONE_NUMBER_TEAM_MEMBER | |||
PHONE_NUMBER_USER_GROUP | |||||
| table | New Table | PHONE_NUMBER_USER_GROUP | |||
TEAM | |||||
| table | Discontinued Table | TEAM | |||
TEXT_TAG | |||||
| column | Discontinued Column | agent_id | |||
| column | Discontinued Column | color | |||
| column | Discontinued Column | datetime | |||
| column | New Column | color_code | |||
| column | New Column | created_at | |||
| column | New Column | created_by_agent_id | |||
USER_GROUP | |||||
| column | Rename Column | id 🔑 | group_id 🔑 | ||
| column | Discontinued Column | name | |||
Sage Intacct
We have resolved a data integrity issue in the Sage Intacct connector that impacts the GLACCOUNTBALANCE table. We have updated the primary key RECORDNO calculation for this table.
Earlier, we calculated the primary key as a hash of the following columns:
accountnoaccountrecaccounttitlebookidclassdimkeyclassidclassnamecontractdimkeycontractidcontractnamecreatedbycurrencycustomerdimkeycustomeridcustomernamedepartmentidemployeedimkeyemployeeidemployeenameendbalforbalgldimcompensation_typegldimservice_lineitemdimkeyitemiditemnamelocation_idlocationnomodifiedbyopenbalperiodprojectdimkeyprojectidprojectnamerecordnorecord_urltaskdimkeytaskidtasknametotadjcredittotadjdebittotcredittotdebitvendordimkeyvendoridvendornamewhencreated
Now, we calculate the primary key as a hash of the following columns:
accountnoaccountrecbookidclassdimkeyclassidclassnamecontractdimkeycontractidcreatedbycurrencycustomerdimkeycustomeriddepartmentidemployeedimkeyemployeeidgldimcompensation_typegldimservice_lineitemdimkeyitemidlocationidlocationdimkeylocationnoopenbalperiodprojectdimkeyprojectidrecordnorecord_urltaskdimkeytaskidvendordimkeyvendoridwhencreated
To correct historical data in your destination:
- You can initiate a free re-sync for the
GLACCOUNTBALANCEtable until September 30, 2025, from Fivetran. - If you choose not to re-sync, only incremental data from September 1, 2025, will reflect the updated
RECORDNOcalculation.
- Re-syncs will result in a large number of API calls to Sage Intacct, which may lead to additional charges at the source as per the Sage Intacct API pricing model.
GLACCOUNTBALANCEis a high-volume table, so sync times may increase during the re-sync.- You might notice an increase in MAR as we synced previously missed rows.
Shopify
We have added the following new columns to the PRODUCT table:
category_ancestor_idscategory_children_idscategory_full_namecategory_idcategory_is_archivedcategory_is_leafcategory_is_rootcategory_levelcategory_namecategory_parent_id
To ensure these new columns are backfilled with data, please perform a re-sync of the PRODUCT table.
Shortcut
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EPIC_OBJECTIVE | |||||
| table | New Table | EPIC_OBJECTIVE | |||
MILESTONE | |||||
| table | Discontinued Table | MILESTONE | |||
MILESTONE_CATEGORY | |||||
| table | Discontinued Table | MILESTONE_CATEGORY | |||
OBJECTIVE | |||||
| table | New Table | OBJECTIVE | |||
OBJECTIVE_CATEGORY | |||||
| table | New Table | OBJECTIVE_CATEGORY | |||
Slack
We have removed the following tables for connections created on or after September 3, 2025:
CHAT_PERMALINKMESSAGEMESSAGE_ATTACHMENTMESSAGE_BLOCKMESSAGE_BLOCK_ELEMENTMESSAGE_BLOCK_FIELDMESSAGE_FILEMESSAGE_REPLY_USERMESSAGE_REACTION
Teamwork
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSIGNEE_COMPANY_TASK | |||||
| table | New Table | ASSIGNEE_COMPANY_TASK | |||
| column | Primary Key Change | assignee_company_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
ASSIGNEE_TEAM_TASK | |||||
| table | New Table | ASSIGNEE_TEAM_TASK | |||
| column | Primary Key Change | assignee_team_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
ASSIGNEE_USER_TASK | |||||
| table | New Table | ASSIGNEE_USER_TASK | |||
| column | Primary Key Change | assignee_user_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
BOARD_COLUMN | |||||
| table | Discontinued Table | BOARD_COLUMN | |||
CALENDAR_EVENT | |||||
| column | Discontinued Column | at_where | |||
| column | Discontinued Column | attendees_can_edit | |||
| column | Discontinued Column | end_at | |||
| column | Discontinued Column | id 🔑 | No longer primary key | ||
| column | Discontinued Column | last_changed_on | |||
| column | Discontinued Column | owner_id | |||
| column | Discontinued Column | privacy | |||
| column | Discontinued Column | project_users_can_edit | |||
| column | Discontinued Column | reminders | |||
| column | Discontinued Column | repeat | |||
| column | Discontinued Column | show_as_busy | |||
| column | Discontinued Column | start | |||
| column | Discontinued Column | status | |||
| column | Discontinued Column | type_color | |||
| column | Discontinued Column | type_id | |||
| column | Discontinued Column | type_name | |||
| column | Primary Key Change | _fivetran_id 🔑 | New primary key | ||
| column | New Column | added_by | |||
| column | New Column | assigned_to | |||
| column | New Column | end_date | |||
| column | New Column | project | |||
| column | New Column | start_date | |||
| column | New Column | tags | |||
| column | New Column | type | |||
CARD | |||||
| table | Discontinued Table | CARD | |||
CARD_ASSIGNED_PEOPLE | |||||
| table | Discontinued Table | CARD_ASSIGNED_PEOPLE | |||
EVENT_ATTENDER | |||||
| table | Discontinued Table | EVENT_ATTENDER | |||
EVENT_SUBSCRIBER | |||||
| table | Discontinued Table | EVENT_SUBSCRIBER | |||
PROJECT | |||||
| column | Discontinued Column | archived_by_user_id | |||
| column | Discontinued Column | board_data | |||
| column | Discontinued Column | category_color | |||
| column | Discontinued Column | category_name | |||
| column | Discontinued Column | company_color | |||
| column | Discontinued Column | company_is_owner | |||
| column | Discontinued Column | completed_by_user_id | |||
| column | Discontinued Column | completed_on | |||
| column | Discontinued Column | created_on | |||
| column | Discontinued Column | date_archived | |||
| column | Discontinued Column | defaults | |||
| column | Discontinued Column | files_auto_new_version | |||
| column | Discontinued Column | is_project_admin | |||
| column | Discontinued Column | last_changed_on | |||
| column | Discontinued Column | last_worked_on | |||
| column | Discontinued Column | portfolio_board | |||
| column | Discontinued Column | starred | |||
| column | New Column | active_page_billing | |||
| column | New Column | active_page_board | |||
| column | New Column | active_page_comments | |||
| column | New Column | active_page_files | |||
| column | New Column | active_page_finance | |||
| column | New Column | active_page_forms | |||
| column | New Column | active_page_gantt | |||
| column | New Column | active_page_links | |||
| column | New Column | active_page_list | |||
| column | New Column | active_page_messages | |||
| column | New Column | active_page_milestones | |||
| column | New Column | active_page_notebooks | |||
| column | New Column | active_page_proofs | |||
| column | New Column | active_page_riskRegister | |||
| column | New Column | active_page_table | |||
| column | New Column | active_page_tasks | |||
| column | New Column | active_page_tickets | |||
| column | New Column | active_page_time | |||
| column | New Column | allow_notify_anyone | |||
| column | New Column | available_deadlines_found | |||
| column | New Column | available_max_end_date | |||
| column | New Column | available_min_start_date | |||
| column | New Column | available_suggested_end_date | |||
| column | New Column | available_suggested_start_date | |||
| column | New Column | category_id | |||
| column | New Column | completed_at | |||
| column | New Column | completed_by | |||
| column | New Column | created_at | |||
| column | New Column | created_by | |||
| column | New Column | custom_field_value | |||
| column | New Column | direct_file_uploads_enabled | |||
| column | New Column | financial_budget_id | |||
| column | New Column | latest_activity | |||
| column | New Column | logo | |||
| column | New Column | logo_color | |||
| column | New Column | logo_icon | |||
| column | New Column | notify_comment_include_creator | |||
| column | New Column | notify_task_assignee | |||
| column | New Column | owner_id | |||
| column | New Column | skip_weekends | |||
| column | New Column | tag_id | |||
| column | New Column | time_budget_id | |||
| column | New Column | type | |||
| column | New Column | update_id | |||
| column | New Column | updated_at | |||
| column | New Column | updated_by | |||
PROJECT_CUSTOM_FIELD_VALUE | |||||
| table | New Table | PROJECT_CUSTOM_FIELD_VALUE | |||
| column | Primary Key Change | custom_field_value_id 🔑 | New primary key | ||
| column | Primary Key Change | project_id 🔑 | New primary key | ||
PROJECT_OWNER | |||||
| table | Discontinued Table | PROJECT_OWNER | |||
PROJECT_PORTFOLIO_CARD | |||||
| table | New Table | PROJECT_PORTFOLIO_CARD | |||
| column | Primary Key Change | portfolio_card_id 🔑 | New primary key | ||
| column | Primary Key Change | project_id 🔑 | New primary key | ||
PROJECT_TAG | |||||
| column | Discontinued Column | color | |||
| column | Rename Column | id 🔑 | tag_id 🔑 | ||
| column | Discontinued Column | name | |||
| column | Discontinued Column | tag_project_id | |||
PROJECT_USER | |||||
| table | New Table | PROJECT_USER | |||
| column | Primary Key Change | project_id 🔑 | New primary key | ||
| column | Primary Key Change | user_id 🔑 | New primary key | ||
PROJECT_WORKFLOW | |||||
| table | New Table | PROJECT_WORKFLOW | |||
| column | Primary Key Change | project_id 🔑 | New primary key | ||
| column | Primary Key Change | workflow_id 🔑 | New primary key | ||
TASK | |||||
| column | Discontinued Column | can_complete | |||
| column | Discontinued Column | can_edit | |||
| column | Discontinued Column | can_log_time | |||
| column | Discontinued Column | card_id | |||
| column | Discontinued Column | company_id | |||
| column | Discontinued Column | completed | |||
| column | Discontinued Column | content | |||
| column | Discontinued Column | created_on | |||
| column | Discontinued Column | creator_id | |||
| column | Discontinued Column | decimal_order | |||
| column | Discontinued Column | decimal_position | |||
| column | Discontinued Column | dlm | |||
| column | Discontinued Column | due_date_base | |||
| column | Discontinued Column | estimated_minutes | |||
| column | Discontinued Column | harvest_enabled | |||
| column | Discontinued Column | has_dependencies | |||
| column | Discontinued Column | has_predecessors | |||
| column | Discontinued Column | has_reminders | |||
| column | Discontinued Column | has_tickets | |||
| column | Discontinued Column | has_unread_comments | |||
| column | Discontinued Column | last_changed_on | |||
| column | Discontinued Column | orders | |||
| column | Discontinued Column | position | |||
| column | Discontinued Column | private | |||
| column | Discontinued Column | project_id | |||
| column | Discontinued Column | responsible_party_summary | |||
| column | Discontinued Column | tasklist_is_template | |||
| column | Discontinued Column | tasklist_private | |||
| column | Discontinued Column | time_is_logged | |||
| column | Discontinued Column | todo_list_id | |||
| column | Discontinued Column | updater_id | |||
| column | Discontinued Column | user_following_changes | |||
| column | Discontinued Column | user_following_comments | |||
| column | Discontinued Column | view_estimated_time | |||
| column | New Column | accumulated_estimated_minute | |||
| column | New Column | assignee_ids | |||
| column | New Column | capacity | |||
| column | New Column | card | |||
| column | New Column | columns | |||
| column | New Column | completed_at | |||
| column | New Column | completed_by | |||
| column | New Column | completed_on | |||
| column | New Column | created_at | |||
| column | New Column | created_by | |||
| column | New Column | date_updated | |||
| column | New Column | decimal_display_order | |||
| column | New Column | deleted_at | |||
| column | New Column | deleted_by | |||
| column | New Column | description_content_type | |||
| column | New Column | display_order | |||
| column | New Column | due_date_offset | |||
| column | New Column | estimate_minutes | |||
| column | New Column | has_desk_tickets | |||
| column | New Column | has_reminder | |||
| column | New Column | is_archived | |||
| column | New Column | is_blocked | |||
| column | New Column | is_private | |||
| column | New Column | latest_update | |||
| column | New Column | lockdown | |||
| column | New Column | name | |||
| column | New Column | notify | |||
| column | New Column | original_due_date | |||
| column | New Column | out_of_sequence | |||
| column | New Column | proof | |||
| column | New Column | sequence_due_date | |||
| column | New Column | sequence_id | |||
| column | New Column | sequence_root_task | |||
| column | New Column | sequence_start_date | |||
| column | New Column | start_date_offset | |||
| column | New Column | tasklist_id | |||
| column | New Column | template_role_name | |||
| column | New Column | timer | |||
| column | New Column | updated_at | |||
| column | New Column | updated_by | |||
| column | New Column | user_permission_can_add_subtasks | |||
| column | New Column | user_permission_can_complete | |||
| column | New Column | user_permission_can_edit | |||
| column | New Column | user_permission_can_log_time | |||
| column | New Column | user_permission_can_view_est_time | |||
| column | New Column | workflow_stages | |||
TASK_COMPLETE_FOLLOWER | |||||
| table | New Table | TASK_COMPLETE_FOLLOWER | |||
| column | Primary Key Change | complete_follower 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TASK_CRM_DEAL | |||||
| table | New Table | TASK_CRM_DEAL | |||
| column | Primary Key Change | crm_deal 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TASK_DEPENDENCY | |||||
| table | New Table | TASK_DEPENDENCY | |||
| column | Primary Key Change | dependency_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TASK_PREDECESSOR | |||||
| table | New Table | TASK_PREDECESSOR | |||
| column | Primary Key Change | predecessor_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TASK_RESPONSIBLE_PARTY | |||||
| table | Discontinued Table | TASK_RESPONSIBLE_PARTY | |||
TASK_SUB_TASK | |||||
| table | New Table | TASK_SUB_TASK | |||
| column | Primary Key Change | sub_task_id 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TASK_TAG | |||||
| column | Rename Column | id 🔑 | tag_id 🔑 | ||
| column | Discontinued Column | name | |||
| column | Discontinued Column | project_id | |||
TASK_WORKFLOW_STAGE | |||||
| table | New Table | TASK_WORKFLOW_STAGE | |||
| column | Primary Key Change | index 🔑 | New primary key | ||
| column | Primary Key Change | task_id 🔑 | New primary key | ||
TEAM | |||||
| column | Discontinued Column | created_by | |||
| column | Discontinued Column | updated_by | |||
| column | New Column | created_by_user_id | |||
| column | New Column | updated_by_user_id | |||
TIME_TRACKING | |||||
| column | Discontinued Column | can_edit | |||
| column | Discontinued Column | company_id | |||
| column | Discontinued Column | date | |||
| column | Discontinued Column | date_user_perspective | |||
| column | Discontinued Column | hours | |||
| column | Discontinued Column | invoice_no | |||
| column | Discontinued Column | is_billed | |||
| column | Discontinued Column | parent_task_id | |||
| column | Discontinued Column | person_id | |||
| column | Discontinued Column | status | |||
| column | Discontinued Column | task_estimated_time | |||
| column | Discontinued Column | task_is_private | |||
| column | Discontinued Column | task_is_sub_task | |||
| column | Discontinued Column | tasklist_id | |||
| column | Discontinued Column | ticket_id | |||
| column | Discontinued Column | todo_item_id | |||
| column | Discontinued Column | todo_item_name | |||
| column | Discontinued Column | todo_list_id | |||
| column | Discontinued Column | todo_list_name | |||
| column | Discontinued Column | updated_date | |||
| column | New Column | billable | |||
| column | New Column | date_created | |||
| column | New Column | date_deleted | |||
| column | New Column | date_edited | |||
| column | New Column | deleted | |||
| column | New Column | deleted_at | |||
| column | New Column | deleted_by_user_id | |||
| column | New Column | desk_ticket_id | |||
| column | New Column | edited_by_user_id | |||
| column | New Column | exchange_rate | |||
| column | New Column | logged_by_user_id | |||
| column | New Column | project_billing_invoice_id | |||
| column | New Column | rate | |||
| column | New Column | task_id | |||
| column | New Column | task_id_pre_move | |||
| column | New Column | time_logged | |||
| column | New Column | total | |||
| column | New Column | updated_at | |||
| column | New Column | user_id | |||
TIME_TRACKING_ASSIGNED_TEAM | |||||
| table | New Table | TIME_TRACKING_ASSIGNED_TEAM | |||
| column | Primary Key Change | assigned_team_id 🔑 | New primary key | ||
| column | Primary Key Change | time_tracking_id 🔑 | New primary key | ||
TIME_TRACKING_TAG | |||||
| table | Discontinued Table | TIME_TRACKING_TAG | |||
USER_ADDRESS | |||||
| table | Discontinued Table | USER_ADDRESS | |||
USER_PERMISSION | |||||
| table | Discontinued Table | USER_PERMISSION | |||
USER_TAG | |||||
| table | Discontinued Table | USER_TAG | |||
USERS | |||||
| column | Discontinued Column | administrator | |||
| column | Discontinued Column | country_code | |||
| column | Discontinued Column | email_address | |||
| column | Discontinued Column | email_alt_1 | |||
| column | Discontinued Column | email_alt_2 | |||
| column | Discontinued Column | email_alt_3 | |||
| column | Discontinued Column | full_name | |||
| column | Discontinued Column | has_access_to_new_projects | |||
| column | Discontinued Column | im_handle | |||
| column | Discontinued Column | im_service | |||
| column | Discontinued Column | in_owner_company | |||
| column | Discontinued Column | invited | |||
| column | Discontinued Column | invited_date | |||
| column | Discontinued Column | invited_status | |||
| column | Discontinued Column | last_active | |||
| column | Discontinued Column | last_changed_on | |||
| column | Discontinued Column | login_count | |||
| column | Discontinued Column | notes | |||
| column | Discontinued Column | phone | |||
| column | Discontinued Column | phone_number_fax | |||
| column | Discontinued Column | phone_number_home | |||
| column | Discontinued Column | phone_number_mobile | |||
| column | Discontinued Column | phone_number_office | |||
| column | Discontinued Column | phone_number_office_ext | |||
| column | Discontinued Column | pid | |||
| column | Discontinued Column | prefix | |||
| column | Discontinued Column | profile | |||
| column | Discontinued Column | profile_text | |||
| column | Discontinued Column | site_owner | |||
| column | Discontinued Column | text_format | |||
| column | Discontinued Column | twitter | |||
| column | Discontinued Column | two_factor_auth_enabled | |||
| column | Discontinued Column | use_shorthand_durations | |||
| column | Discontinued Column | username | |||
| column | Discontinued Column | uuid | |||
| column | New Column | amount | |||
| column | New Column | avatar_url | |||
| column | New Column | can_access_portfolio | |||
| column | New Column | can_add_projects | |||
| column | New Column | can_manage_portfolio | |||
| column | New Column | company_role_id | |||
| column | New Column | company_type | |||
| column | New Column | created_by_user_id | |||
| column | New Column | currency_id | |||
| column | New Column | email | |||
| column | New Column | is_admin | |||
| column | New Column | is_placeholder_resource | |||
| column | New Column | job_role | |||
| column | New Column | skill | |||
| column | New Column | timezone | |||
| column | New Column | updated_at | |||
| column | New Column | updated_by_user_id | |||
| column | New Column | user_cost | |||
| column | New Column | user_rate | |||
| column | New Column | working_hours_id | |||
USERS_TEAM | |||||
| table | New Table | USERS_TEAM | |||
| column | Primary Key Change | team_id 🔑 | New primary key | ||
| column | Primary Key Change | users_id 🔑 | New primary key | ||
WORKFLOW | |||||
| table | New Table | WORKFLOW | |||
| column | New Column | created_at | |||
| column | New Column | created_by | |||
| column | New Column | default_workflow | |||
| column | Primary Key Change | id 🔑 | New primary key | ||
| column | New Column | lockdown | |||
| column | New Column | name | |||
| column | New Column | project_specific | |||
| column | New Column | status | |||
| column | New Column | updated_at | |||
| column | New Column | updated_by | |||
WORKFLOW_COMPANY | |||||
| table | New Table | WORKFLOW_COMPANY | |||
| column | Primary Key Change | company_id 🔑 | New primary key | ||
| column | Primary Key Change | workflow_id 🔑 | New primary key | ||
WORKFLOW_PROJECT | |||||
| table | New Table | WORKFLOW_PROJECT | |||
| column | Primary Key Change | project_id 🔑 | New primary key | ||
| column | Primary Key Change | workflow_id 🔑 | New primary key | ||
WORKFLOW_STAGE | |||||
| table | New Table | WORKFLOW_STAGE | |||
| column | Primary Key Change | stage_id 🔑 | New primary key | ||
| column | Primary Key Change | workflow_id 🔑 | New primary key | ||
TikTok Ads
We have added two new tables, GMV_ADVERTISER_COUNTRY_REPORT_DAILY and GMV_CAMPAIGN_COUNTRY_REPORT_DAILY.
Transcend
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DATA_APPLICATION | |||||
| table | Discontinued Table | DATA_APPLICATION | |||
DATA_PRACTICE | |||||
| table | Discontinued Table | DATA_PRACTICE | |||
DATA_PRACTICE_CHILDREN | |||||
| table | Discontinued Table | DATA_PRACTICE_CHILDREN | |||
DATA_PRACTICE_CHILDREN_CHILD | |||||
| table | Discontinued Table | DATA_PRACTICE_CHILDREN_CHILD | |||
DATAPOINT | |||||
| column | Discontinued Column | collection_category_id | |||
PRIVACY_CENTER | |||||
| column | Discontinued Column | hide_data_practice | |||
Validio
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INCIDENT | |||||
| column | New Column | incident_group_id | |||
Workday Financial Management
We have updated the data type of the supplier_invoice_reference_number column in the SUPPLIER_CONTRACT table from BOOLEAN to STRING.
We have added the following new child tables to the COMPANY table:
company_alternate_fiscal_schedulecompany_account_translation_currencycompany_allow_accounting_in_arrearscompany_alternate_ledger_currency
We are gradually rolling these changes out to all existing connections.
We have added the following new columns to the COMPANY table:
account_control_rule_set_idaccount_posting_rule_set_idaccount_set_idaccount_translation_rule_set_codeaccounting_date_requiredallow_invoice_accounting_in_arrearsalternate_account_set_idaverage_daily_balance_rule_codeaverage_daily_balance_start_datecurrency_idcurrency_rate_type_codedefault_account_set_iddefault_reporting_book_codedisallow_change_to_operations_transactions_in_closed_periodsenable_automatic_journal_line_numberingfiscal_schedule_codekeep_debit_credit_and_reverse_signprocurement_tax_option_codereverse_debit_credittax_service_nameuse_third_party_tax_service
Workday HCM
We have added a new column, job_family_id, to the WORKER_POSITION_HISTORY and WORKER_POSITION tables.
We have added a new column, job_family_short_code, to the JOB_FAMILY table.
We have changed the sync strategy of the CANDIDATE table. We now support incremental syncs for this table.
Wrike
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
FOLDER_TASK | |||||
| column | New column | shared_id | |||
FOLDER_TASK_SHARED_ID | |||||
| table | Discontinued Table | FOLDER_TASK_SHARED_ID | Data is available in the shared_id column of the FOLDER_TASK table. | ||
SPACE_TASK | |||||
| column | New column | shared_id | |||
SPACE_TASK_SHARED_ID | |||||
| table | Discontinued Table | SPACE_TASK_SHARED_ID | Data is available in the shared_id column of the SPACE_TASK table. | ||
Yahoo Search Ads on Yahoo Japan
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AD | |||||
| column | Discontinued Column | keyword_id | |||
Youtube Analytics
We've updated bulk report types to reflect the latest updates in YouTube Analytics API. Table names have not been updated, but the requested type for all reports that include views has been incremented by one (for example, version a2 is now version a3).
We've also added the engaged_views column to all the updated reports.
The changes are already live for all connections created after June 30, 2025. We are gradually rolling out this change to connections created before that date.
Improvements
Amazon DSP
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the following tables:
AUDIENCEAUDIO_AND_VIDEOCAMPAIGNGEOINVENTORYPRODUCTTECH
We are gradually rolling out this improvement to all connections.
Amazon Selling Partner
We have made the following improvements to the ASP connection setup form:
- Merchant ID/Vendor Code no longer displays when the Vendor Account toggle is active.
- Merchant ID/Vendor Code is renamed to Merchant ID, which is a read-only field and updates automatically from the URL after OAuth authorization.
We are gradually rolling out these changes to all the connectors.
Assembled
We have added support for syncing activities up to 42 days ahead in the ACTIVITY table.
Box
We have made the following changes to the connection setup form:
- Added support to configure archive patterns per table. This is useful when an archive folder contains files following different naming patterns, allowing you to route each pattern to a specific destination table based on its pattern.
- Renamed the Archive Folder Pattern field to Archive File Pattern.
For more information, see our setup instructions
Calendly
We have made the following changes to the sync strategy for the EVENT table and its child tables:
- We no longer capture deletes for them.
- We now perform a rollback sync with a rollback window of 6 months to capture updates for these tables. We perform the rollback sync during every sync.
We are gradually rolling out these changes to all existing connections.
CockroachDB
Our CockroachDB connector is now generally available. Read our CockroachDB connector documentation.
Coupa
We now additionally sync the TAG and TAGGING tables from the REQUISITION_HEADER endpoint. To backfill historical data, you can trigger a re-sync for these tables. MAR will be free for the TAG and TAGGING tables only.
Databricks destination
You can now use a service principal to authenticate external Azure staging in Hybrid Deployment.
Dropbox
We now support syncing files to multiple destination tables and handling file patterns in Merge Mode. To support these features, we have made the following changes to the connection setup form:
- Added the Files field and sub-fields Table name and File pattern, that enable you to define destination tables and specify the file pattern names.
- Renamed the Destination table field to Table group name to enable unique identification of connections that share the same destination schema name.
For more information, see our setup instructions. We are gradually rolling out these enhancements to all existing connections.
Fivetran Platform
We now show a warning when the Google Cloud Storage bucket used for log events cannot be accessed from the Hybrid Deployment environment.
- The warning includes the underlying error message to help troubleshooting.
- Account- and destination-related metadata continues to sync; log event ingestion resumes automatically once access is restored.
If you see this warning, verify that connection from your Hybrid environment can reach the storage endpoint.
Formstack
We now perform a rollback sync with a rollback window of 3 months to capture updates for the FORM_SUBMISSION table. We perform the rollback sync during every sync.
FTP
We now support syncing files to multiple destination tables and handling file patterns in Merge Mode. To support these features, we have made the following changes to the connection setup form:
Added the Files field and sub-fields Table name and File pattern, that enable you to define destination tables and specify the file pattern names.
Renamed the Destination table field to Table group name to enable unique identification of connections that share the same destination schema name.
For more information, see our setup instructions and REST API configuration. We are gradually rolling out these enhancements to all existing connections.
We have made the following changes to the connection setup form:
- Added support to configure archive patterns per table. This is useful when an archive folder contains files following different naming patterns, allowing you to route each pattern to a specific destination table based on its pattern.
- Renamed the Archive Folder Pattern field to Archive File Pattern.
For more information, see our setup instructions
Help Scout
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the following tables:
DOC_REPORT_FAILED_SEARCHDOC_REPORT_POPULAR_SEARCHDOC_REPORT_TOP_ARTICLEDOC_REPORT_TOP_CATEGORYDOC_REPORT
We are gradually rolling out this improvement to all connections.
Impact Brand
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the ACTION_EVENT and ACTION_LOCKING tables.
We are gradually rolling out this improvement to all connections.
Jibble
We have changed the sync strategy for the TIME_ENTRY table. We now re-import the table once a month to capture updates. Previously, we incrementally sync it to capture both new records and updates.
Microsoft Dynamics 365 Finance and Operations
The Microsoft Dynamics 365 Finance and Operations connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
MongoDB
We've added support for the Fivetran Proxy Agent connection method to the MongoDB connector. You can now use Proxy Agent to connect to your MongoDB or MongoDB Sharded instance.
For more information, see our MongoDB setup instructions and MongoDB Sharded setup instructions
MySQL destination
We now convert the LOCALDATETIME data type to DATETIME(6) in your destination, instead of DATETIME. This change increases timestamp precision from seconds to microseconds, helping us store more accurate date and time values.
This change applies to all new tables and columns created on or after September 12, 2025.
Ordway
You can now specify the name of the Ordway webhook you want Fivetran to use. To facilitate this change, we have made the following changes:
- added a new field, Webhook name, to the connection setup form
- added a new REST API parameter,
webhook_name, to the REST API connection configuration
For more information, see our setup instructions and REST API configuration.
PayPal
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the following tables:
BALANCE_DETAILBALANCEINCENTIVETRANSACTION_ITEM_CHECKOUT_OPTIONTRANSACTION_ITEM_DETAILTRANSACTION_ITEM_TAX_AMOUNTTRANSACTION
We are gradually rolling out this improvement to all connections.
Pendo
Our Pendo connector now supports projects in the JPN region and AU region. To let a connector fetch data from Pendo's JPN or AU data center, you must change the integration key for the connector to one that is compatible with respective endpoint. Generate a compatible integration key from app.jpn.pendo.io for JPN region and app.au.pendo.io for AU region.
Placer.ai
We now re-import the VISIT_BY_TREND table once a week to capture updates.
Salesforce
We have added new system tables, FIVETRAN_ROLLUP_SUMMARY and FIVETRAN_ROLLUP_SUMMARY_FILTER, to store the Salesforce rollup summary field definitions.
These tables count towards free Monthly Active Rows (MAR).
We will no longer populate empty rollup summary field definitions into the FIVETRAN_FORMULA table from November 1, 2025.
Sprout Social
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the following tables:
FACEBOOK_PROFILE_ANALYTICFACEBOOK_PROFILE_POSTINSTAGRAM_PROFILE_ANALYTICINSTAGRAM_PROFILE_POSTLINKEDIN_PROFILE_ANALYTICLINKEDIN_PROFILE_POSTPINTEREST_PROFILE_ANALYTICPINTEREST_PROFILE_POSTTIKTOK_PROFILE_ANALYTICTIKTOK_PROFILE_POSTTWITTER_PROFILE_ANALYTICTWITTER_PROFILE_POSTYOUTUBE_PROFILE_ANALYTICYOUTUBE_PROFILE_POST
We are gradually rolling out this improvement to all connections.
Statsig
We have changed our connection re-sync strategy. During a re-import, we no longer delete historical records for tables with a retention period at the source because we won't be able to retrieve the older records.
This change applies to the following tables:
AUDIT_LOG_CHANGE_RULE_CONDITIONAUDIT_LOG_CHANGE_RULEAUDIT_LOG
We are gradually rolling out this improvement to all connections.
Stripe
We now support subscriptions with multiple discounts. We retrieve the discounts using the discounts array into the SUBSCRIPTION_DISCOUNT and DISCOUNT tables. Previously, we retrieved a single discount using the discount field.
If you notice discounts are missing, trigger a re-sync on the SUBSCRIPTION_ITEM table. This could cause a slight increase in your MAR because the sync will now include those discounts.
Veeva Vault
We have upgraded our Veeva Vault connector from version 25.1 to 25.2 of the Veeva Vault API. For more information, see Veeva Vault's documentation.
REST API Improvements
User group role name alignment
We now display replacement role name for the deprecated roles in the role field in the List all users within a group endpoint response.