June 2026
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.9.2 of the fivetran-connector-sdk PyPI package. This release includes the following updates:
- The
fivetran debugcommand now logs peak memory usage at the end of a debug run. - Added validation during
fivetran init. - Minor enhancements and improvements.
We have released version 2.9.1 of the fivetran-connector-sdk PyPI package. This release includes the following updates:
fivetran initnow supports Copilot plugins allowing users to leverage AI capabilities for faster and more efficient connector development.- We've deprecated the
--forceand-fflags and introduced a new--non-interactiveflag for better clarity and user experience. - Updated the CLI to point to renamed repositories.
- Minor enhancements and improvements.
- Updated testers.
We have released version 2.9.0 of the fivetran-connector-sdk PyPI package. This release includes the following updates:
- Updated
fivetran initcommand to install fivetran-connector-sdk@fivetran-connector-sdk-ai plugin, which provides AI-powered features for connector development. - Improved prompts for dependency validations during package and deploy commands.
- Minor enhancements and improvements.
- Updated testers.
Lite Connectors
Lite connectors are now available for the following sources:
Managed Data Lake Service
You can now update the HTTP path of the Databricks cluster associated with a Unity Catalog for existing data lakes. To ensure compatibility, the new HTTP path must belong to a cluster in the same Unity Catalog and Databricks workspace.
Syncing empty columns
Our Files connectors now support creating empty columns and columns with null values in your destination. During the initial sync, we create these empty columns with the STRING data type. However, if the column later contains non-null values in subsequent syncs, we update the column data type based on the data type we infer from the schema. Previously, we did not support creating empty columns or columns with null values in your destination.
We support this enhancement only for the following File connectors set up using BigQuery, Databricks, and Snowflake as destinations:
- Amazon S3
- Azure Blob Storage
- Box
- Dropbox
- FTP
- Google Cloud Storage
- S3-Compatible Storage
- SharePoint
- SFTP
We are gradually rolling out this enhancement to all existing connections.
Transformations for dbt Core
Automatic dbt Core patch version updates
We have added a new Automatically use latest patch version toggle to the dbt Core project setup form.
When enabled, the dbt Core Version dropdown shows minor versions with the current latest patch in parentheses (for example, 1.9 (1.9.10), 1.10 (1.10.22)). Fivetran automatically uses the latest patch release within the selected minor version as new patches become available.
When disabled, the dbt Core Version dropdown shows full patch versions (for example, 1.9.4, 1.9.8, 1.10.3), and you must select the exact version.
You can toggle between automatic and manual patch version management at any time. To access this setting, do the following:
- In the Fivetran dashboard, click Transformations.
- Click Manage projects.
- In the transformation list, click the three dots on the right side of the relevant dbt project.
- Click Edit connection settings.
Updated Quickstart data model packages
We have updated the Quickstart packages for the following connectors:
- Connectors supporting the Ad Reporting data model to version 2.7.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Connectors supporting the App Reporting data model to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Connectors supporting the Shopify Holistic Reporting data model to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 3, 2026.
- Connectors supporting the Social Media Reporting data model to version 1.6.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 3, 2026.
- Connectors supporting the Unified RAG data model to version 0.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- AWS Cost and Usage Reports to version 0.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Amazon Ads to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Amazon Selling Partner to version 0.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Amplitude to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Apple App Store to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Apple Search Ads to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Asana to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Facebook Ads to version 1.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Facebook Pages to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- GitHub to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Google Ads to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Google Play to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Greenhouse to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- HubSpot to version 1.8.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Instagram Business to version 1.2.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Intercom to version 1.7.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Iterable to version 1.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Jira to version 1.10.1. We are gradually rolling out this change. All Quickstart transformations will be updated by August 3, 2026.
- Klaviyo to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Lever to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- LinkedIn Ad Analytics to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- LinkedIn Company Pages to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Mailchimp to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Marketo to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Microsoft Advertising to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Mixpanel to version 0.17.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- NetSuite SuiteAnalytics to version 1.7.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Pardot to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Pendo to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Pinterest Ads to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Qualtrics to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- QuickBooks to version 1.8.1. We are gradually rolling out this change. All Quickstart transformations will be updated by August 9, 2026.
- Recharge to version 1.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Recurly to version 1.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Reddit Ads to version 1.5.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Sage Intacct to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Salesforce Marketing Cloud to version 0.6.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- ServiceNow to version 1.0.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Shopify to version 1.9.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Snapchat Ads to version 1.3.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- StackAdapt to version 0.2.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Stripe to version 1.8.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- TikTok Ads to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Twilio to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Workday HCM to version 1.0.1. We are gradually rolling out this change. All Quickstart transformations will be updated by August 8, 2026.
- X Organic to version 1.2.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Xero to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- YouTube Analytics to version 1.2.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Zendesk Support to version 1.7.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
- Zuora Sandbox to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 4, 2026.
- Zuora to version 1.4.0. We are gradually rolling out this change. All Quickstart transformations will be updated by August 2, 2026.
Schema changes
15Five
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
HIGH_FIVE | |||||
| table | New Table | HIGH_FIVE | |||
HIGH_FIVE_EMAIL_RECEIVER | |||||
| table | New Table | HIGH_FIVE_EMAIL_RECEIVER | |||
HIGH_FIVE_RECEIVER | |||||
| table | New Table | HIGH_FIVE_RECEIVER | |||
REVIEW_CYCLE | |||||
| table | New Table | REVIEW_CYCLE | |||
REVIEW_CYCLE_PARTICIPANT | |||||
| table | New Table | REVIEW_CYCLE_PARTICIPANT | |||
Aircall
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AIRCALL_TO_PARTNER_CAMPAIGN | |||||
| table | Discontinued Table | AIRCALL_TO_PARTNER_CAMPAIGN | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
MESSAGE | |||||
| table | New Table | MESSAGE | |||
Alchemer
We have added a new column, parent, to the SURVEY_DATA table.
Amazon DSP
We have added the following new columns to the CAMPAIGN table:
detail_page_viewsvideo_ad_completevideo_ad_first_quartilevideo_ad_start
We are gradually rolling out this change to all existing connections.
Amazon Selling Partner
Effective June 25, 2026, we are updating the primary keys and composite primary keys for the following tables to resolve data integrity issues and make each record uniquely identifiable:
| Table name | Current primary key columns | New primary key columns | Notes |
|---|---|---|---|
COMPETITIVE_PRICE_TYPE | asin and id | asin, id, and marketplace_id | |
CPT_TRADE_IN_VALUE | asin | asin and marketplace_id | |
ITEM_BUY_BOX_PRICE_TYPE | asin | asin, condition, and marketplace_id | |
ITEM_OFFER_COUNT_TYPE | asin and type | asin, condition, marketplace_id, and type | |
ITEM_OFFER_DETAIL | asin, index, and subcondition | asin, index, marketplace_id, and subcondition | |
ITEM_OFFER_LOWEST_PRICE_TYPE | asin | asin, condition, and marketplace_id | |
ITEM_OFFER_SUMMARY | asin | asin, condition, marketplace_id | |
ITEM_QUANTITY_DISCOUNT_PRICE_TYPE | asin | asin, condition, and marketplace_id | |
ITEM_SALES_RANK_TYPE | asin | asin and marketplace_id | |
SETTLEMENT_REPORT | amount_description, fulfillment_id, order_id, settlement_id, shipment_id, and transaction_type | _fivetran_id | The _fivetran_id column is a hash of all columns in the report. |
On June 25, 2026, we will re-sync all the affected tables. During the re-sync, you may experience longer sync times depending on the volume of data in the affected tables. Before June 25, 2026, review and update any downstream queries, models, and workflows that reference these tables to use the new primary key columns. Failing to do so may lead to missing or incomplete data in your data pipelines.
We have added two new columns, amount_charged and qty_charged, to the LONG_TERM_STORAGE_FEE_CHARGES_REPORT table.
Apollo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DEAL | |||||
| table | New Table | DEAL | |||
DEAL_STAGE | |||||
| table | New Table | DEAL_STAGE | |||
Apple App Store
We've added a new table, APP_STORE_RETENTION_MESSAGING. The table contains data about how users interact with retention messages during the subscription cancellation flow, including event counts broken down by subscription tier, message type, device, territory, and platform version.
AppLovin
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ADVERTISER_REPORT | |||||
| column | New Column | chka_usd_0d | |||
| column | New Column | chka_usd_14d | |||
| column | New Column | chka_usd_7d | |||
| column | New Column | cost_per_target_event_0d | |||
| column | New Column | cpp_0d | |||
| column | New Column | cpp_14d | |||
| column | New Column | cpp_7d | |||
| column | New Column | nc_d0_checkout | |||
| column | New Column | nc_d0_checkout_rev | |||
| column | New Column | nc_d0_cpp | |||
| column | New Column | nc_d0_roas | |||
| column | New Column | nc_percent_d0_checkout | |||
| column | New Column | nc_percent_d0_checkout_rev | |||
| column | New Column | roas_0d | |||
| column | New Column | roas_14d | |||
| column | New Column | roas_28d | |||
| column | New Column | sales_0d | |||
| column | New Column | sales_14d | |||
| column | New Column | sales_28d | |||
| column | New Column | target_event_count_0d | |||
PROBABILISTIC_REPORT | |||||
| column | New Column | chka_usd_0d | |||
| column | New Column | chka_usd_14d | |||
| column | New Column | chka_usd_7d | |||
| column | New Column | cost_per_target_event_0d | |||
| column | New Column | cpp_0d | |||
| column | New Column | cpp_14d | |||
| column | New Column | cpp_7d | |||
| column | New Column | nc_d0_checkout | |||
| column | New Column | nc_d0_checkout_rev | |||
| column | New Column | nc_d0_cpp | |||
| column | New Column | nc_d0_roas | |||
| column | New Column | nc_percent_d0_checkout | |||
| column | New Column | nc_percent_d0_checkout_rev | |||
| column | New Column | roas_0d | |||
| column | New Column | roas_14d | |||
| column | New Column | roas_7d | |||
| column | New Column | sales_0d | |||
| column | New Column | sales_14d | |||
| column | New Column | sales_28d | |||
| column | New Column | target_event_count_0d | |||
Birdeye
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTACT_MAPPING | |||||
| column | Primary Key Change | mapping_business_id 🔑 | mapping_business_id | No longer a primary key. | |
| column | Primary Key Change | mapping_customer_id 🔑 | mapping_customer_id | No longer a primary key. | |
| column | Primary Key Change | index 🔑 | Added to primary key. | ||
Bitly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
QR_CODE_PNG | |||||
| table | Discontinued table | QR_CODE_PNG | |||
QR_CODE_SVG | |||||
| table | Discontinued table | QR_CODE_SVG | |||
Brevo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TRANSACTIONAL_EMAIL_EVENT | |||||
| table | New Table | TRANSACTIONAL_EMAIL_EVENT | |||
Brightpearl
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
JOURNAL | |||||
| table | New Table | JOURNAL | |||
JOURNAL_TRANSACTION | |||||
| table | New Table | JOURNAL_TRANSACTION | |||
NOMINAL_CODE | |||||
| table | New Table | NOMINAL_CODE | |||
TAX_CODE | |||||
| table | New Table | TAX_CODE | |||
Brivo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTROL_PANEL | |||||
| table | New Table | CONTROL_PANEL | |||
CREDENTIAL | |||||
| table | New Table | CREDENTIAL | |||
CREDENTIAL_FIELD_VALUE | |||||
| table | New Table | CREDENTIAL_FIELD_VALUE | |||
HOLIDAY | |||||
| table | New Table | HOLIDAY | |||
USER_CREDENTIAL | |||||
| table | New Table | USER_CREDENTIAL | |||
Calendly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EVENT | |||||
| column | New Column | location_extra | |||
| column | New Column | location_id | |||
| column | New Column | location_join_url | |||
| column | New Column | location_password | |||
| column | New Column | location_settings | |||
| column | New Column | location_status | |||
CallRail
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
MILESTONE | |||||
| column | Primary Key Change | form_submission 🔑 | form_submission | No longer a primary key. | |
Centra
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SHIPMENT | |||||
| table | New Table | SHIPMENT | |||
SHIPMENT_ALLOCATION | |||||
| table | New Table | SHIPMENT_ALLOCATION | |||
SHIPMENT_APPLIED_TAX_RULE | |||||
| table | New Table | SHIPMENT_APPLIED_TAX_RULE | |||
SHIPMENT_INVOICE | |||||
| table | New Table | SHIPMENT_INVOICE | |||
SHIPMENT_INVOICE_LINE | |||||
| table | New Table | SHIPMENT_INVOICE_LINE | |||
SHIPMENT_LINE | |||||
| table | New Table | SHIPMENT_LINE | |||
SHIPMENT_RETURN | |||||
| table | New Table | SHIPMENT_RETURN | |||
Cin7 Core
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
FACTORY_CALENDAR | |||||
| table | New Table | FACTORY_CALENDAR | |||
FACTORY_CALENDAR_DAY | |||||
| table | New Table | FACTORY_CALENDAR_DAY | |||
FACTORY_CALENDAR_SPECIAL_DAY | |||||
| table | New Table | FACTORY_CALENDAR_SPECIAL_DAY | |||
PRODUCT_FAMILY_PRODUCTION_BOM | |||||
| table | New Table | PRODUCT_FAMILY_PRODUCTION_BOM | |||
PRODUCT_FAMILY_PRODUCTION_BOM_OPERATION | |||||
| table | New Table | PRODUCT_FAMILY_PRODUCTION_BOM_OPERATION | |||
PRODUCT_PRODUCTION_BOM | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM | |||
PRODUCT_PRODUCTION_BOM_COMPONENT | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM_COMPONENT | |||
PRODUCT_PRODUCTION_BOM_NOTE | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM_NOTE | |||
PRODUCT_PRODUCTION_BOM_OPERATION | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM_OPERATION | |||
PRODUCT_PRODUCTION_BOM_OUTPUT_PRODUCT | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM_OUTPUT_PRODUCT | |||
PRODUCT_PRODUCTION_BOM_RESOURCE | |||||
| table | New Table | PRODUCT_PRODUCTION_BOM_RESOURCE | |||
PRODUCTION_BOM_FINISHED_PRODUCT | |||||
| table | New Table | PRODUCTION_BOM_FINISHED_PRODUCT | |||
PRODUCTION_BOM_OPERATION_LINK | |||||
| table | New Table | PRODUCTION_BOM_OPERATION_LINK | |||
PRODUCTION_BOM_RESOURCE | |||||
| table | New Table | PRODUCTION_BOM_RESOURCE | |||
PRODUCTION_BOM_VARIATION_COMPONENT | |||||
| table | New Table | PRODUCTION_BOM_VARIATION_COMPONENT | |||
PRODUCTION_ORDER | |||||
| table | New Table | PRODUCTION_ORDER | |||
PRODUCTION_ORDER_SOURCE_TASK | |||||
| table | New Table | PRODUCTION_ORDER_SOURCE_TASK | |||
PRODUCTION_RESOURCE | |||||
| table | New Table | PRODUCTION_RESOURCE | |||
PRODUCTION_RUN | |||||
| table | New Table | PRODUCTION_RUN | |||
PRODUCTION_RUN_OPERATION | |||||
| table | New Table | PRODUCTION_RUN_OPERATION | |||
PRODUCTION_RUN_OPERATION_COMPONENT | |||||
| table | New Table | PRODUCTION_RUN_OPERATION_COMPONENT | |||
PRODUCTION_RUN_RESOURCE | |||||
| table | New Table | PRODUCTION_RUN_RESOURCE | |||
PRODUCTION_RUN_TRACEABILITY | |||||
| table | New Table | PRODUCTION_RUN_TRACEABILITY | |||
SUSPEND_REASON | |||||
| table | New Table | SUSPEND_REASON | |||
SUSPEND_REASON_WORKCENTER | |||||
| table | New Table | SUSPEND_REASON_WORKCENTER | |||
WORK_CENTER | |||||
| table | New Table | WORK_CENTER | |||
WORK_CENTER_LOCATION | |||||
| table | New Table | WORK_CENTER_LOCATION | |||
commercetools
We have added two new tables, PRODUCT_TYPE and PRODUCT_TYPE_ATTRIBUTE.
We have added the following new columns to the PRODUCT_VARIANT_PRICES table:
discounted_value_cent_amountdiscounted_value_currency_codediscounted_value_fraction_digitsdiscounted_value_precise_amountdiscounted_value_type
We are gradually rolling out these change to all existing connections.
Confluence
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PAGE_ANCESTOR | |||||
| table | New Table | PAGE_ANCESTOR | |||
PAGE_LABEL | |||||
| column | New Column | name | |||
| column | New Column | prefix | |||
PAGE_LIKE | |||||
| table | New Table | PAGE_LIKE | |||
Coupa
We have added a new table, EXTERNAL_PAYMENT. We are gradually rolling out this change to all existing connections.
Cvent
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ATTENDEE_LINK | |||||
| table | New Table | ATTENDEE_LINK | |||
CONTACT_CUSTOM_FIELD | |||||
| table | New Table | CONTACT_CUSTOM_FIELD | |||
CUSTOM_FIELD | |||||
| table | New Table | CUSTOM_FIELD | |||
PLAYER | |||||
| table | New Table | PLAYER | |||
WEBCAST | |||||
| table | New Table | WEBCAST | |||
dbt Cloud
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AUTH_PROVIDER_USER_GROUPS | |||||
| column | Primary Key Change | users_id 🔑 | users_id | No longer a primary key. | |
IP_RESTRICTION | |||||
| table | New Table | IP_RESTRICTION | |||
IP_RESTRICTION_CIDR | |||||
| table | New Table | IP_RESTRICTION_CIDR | |||
OAUTH_CONFIGURATION | |||||
| table | New Table | OAUTH_CONFIGURATION | |||
PERMISSION_STATEMENT | |||||
| column | Primary Key Change | permission_id 🔑 | permission_id | No longer a primary key. | |
WEBHOOK_EVENT | |||||
| table | New Table | WEBHOOK_EVENT | |||
Dixa
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
AGENT_PRESENCE | |||||
| table | New Table | AGENT_PRESENCE | |||
AGENT_PRESENCE_ACTIVE_CHANNEL | |||||
| table | New Table | AGENT_PRESENCE_ACTIVE_CHANNEL | |||
Docebo
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COURSE_ENROLLMENT_DETAILS | |||||
| table | New Table | COURSE_ENROLLMENT_DETAILS | |||
Drata
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONTROL | |||||
| column | Discontinued Column | has_evidence | |||
| column | Discontinued Column | has_owner | |||
| column | Discontinued Column | has_ticket | |||
| column | Discontinued Column | is_monitored | |||
| column | Discontinued Column | is_ready | |||
| column | New Column | activity | |||
| column | New Column | control_template_id | |||
| column | New Column | created_at | |||
| column | New Column | flag_has_evidence | |||
| column | New Column | flag_has_owner | |||
| column | New Column | flag_has_policy | |||
| column | New Column | flag_has_ticket | |||
| column | New Column | flag_is_monitored | |||
| column | New Column | flag_is_ready | |||
| column | New Column | question | |||
| column | New Column | updated_at | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
CONTROL_CUSTOM_FIELD | |||||
| table | New Table | CONTROL_CUSTOM_FIELD | |||
CONTROL_MAPPED_REQUIREMENT | |||||
| column | New Column | created_at | |||
| column | New Column | external_id | |||
| column | New Column | updated_at | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
CONTROL_OWNER | |||||
| column | Discontinued Column | avatar_url | |||
| column | Discontinued Column | drata_terms_agreed_at | |||
| column | Discontinued Column | job_title | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
MONITOR | |||||
| column | Discontinued Column | auto_enabled_at | |||
| column | Discontinued Column | check_status | |||
| column | Discontinued Column | disabled_message | |||
| column | Discontinued Column | disabling_user | |||
| column | Discontinued Column | disabling_user_id | |||
| column | Discontinued Column | graph | |||
| column | Discontinued Column | last_check | |||
| column | Discontinued Column | priority | |||
| column | New Column | disabled_by_user_id | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
MONITOR_CONTROL | |||||
| column | Discontinued Column | activity | |||
| column | Discontinued Column | archived_at | |||
| column | Discontinued Column | question | |||
| column | Discontinued Column | slug | |||
| column | New Column | created_at | |||
| column | New Column | is_ready | |||
| column | New Column | updated_at | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
MONITOR_INSTANCE | |||||
| column | Discontinued Column | autopilot_task_type | |||
| column | Discontinued Column | check_frequency | |||
| column | Discontinued Column | enabled | |||
| column | Discontinued Column | evidence_collection_description | |||
| column | Discontinued Column | failed_test_description | |||
| column | Discontinued Column | remedy_description | |||
| column | Discontinued Column | url | |||
| column | New Column | collection_description | |||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
MONITOR_INSTANCE_CHECK_TYPE | |||||
| table | Discontinued Table | MONITOR_INSTANCE_CHECK_TYPE | |||
MONITOR_INSTANCE_EXCLUSION | |||||
| column | Discontinued Column | monitor_id 🔑 | No longer a primary key | ||
| column | Primary Key Change | test_id 🔑 | New primary key | ||
| column | Primary Key Change | workspace_id 🔑 | New primary key | ||
MONITOR_INSTANCE_METADATA | |||||
| table | Discontinued Table | MONITOR_INSTANCE_METADATA | |||
MONITOR_INSTANCE_METADATA_EXCLUSION | |||||
| table | Discontinued Table | MONITOR_INSTANCE_METADATA_EXCLUSION | |||
MONITOR_INSTANCE_METADATA_PASS_FAIL | |||||
| table | Discontinued Table | MONITOR_INSTANCE_METADATA_PASS_FAIL | |||
MONITORING_TEST_FAIL | |||||
| table | New Table | MONITORING_TEST_FAIL | |||
POLICY | |||||
| table | New Table | POLICY | |||
POLICY_CONTROL | |||||
| table | New Table | POLICY_CONTROL | |||
POLICY_GRACE_PERIOD_SLA | |||||
| table | New Table | POLICY_GRACE_PERIOD_SLA | |||
POLICY_GROUP | |||||
| table | New Table | POLICY_GROUP | |||
POLICY_P3_MATRIX_SLA | |||||
| table | New Table | POLICY_P3_MATRIX_SLA | |||
POLICY_VERSION | |||||
| table | New Table | POLICY_VERSION | |||
POLICY_VERSION_GRACE_PERIOD_SLA | |||||
| table | New Table | POLICY_VERSION_GRACE_PERIOD_SLA | |||
POLICY_VERSION_P3_MATRIX_SLA | |||||
| table | New Table | POLICY_VERSION_P3_MATRIX_SLA | |||
POLICY_VERSION_WEEK_TIME_FRAME_SLA | |||||
| table | New Table | POLICY_VERSION_WEEK_TIME_FRAME_SLA | |||
POLICY_WEEK_TIME_FRAME_SLA | |||||
| table | New Table | POLICY_WEEK_TIME_FRAME_SLA | |||
RISK | |||||
| table | New Table | RISK | |||
RISK_CATEGORY | |||||
| table | New Table | RISK_CATEGORY | |||
RISK_CONTROL | |||||
| table | New Table | RISK_CONTROL | |||
RISK_CUSTOM_FIELD | |||||
| table | New Table | RISK_CUSTOM_FIELD | |||
RISK_DOCUMENT | |||||
| table | New Table | RISK_DOCUMENT | |||
RISK_NOTE | |||||
| table | New Table | RISK_NOTE | |||
RISK_OWNER | |||||
| table | New Table | RISK_OWNER | |||
RISK_REGISTER | |||||
| table | New Table | RISK_REGISTER | |||
RISK_REGISTER_OWNER | |||||
| table | New Table | RISK_REGISTER_OWNER | |||
RISK_REVIEWER | |||||
| table | New Table | RISK_REVIEWER | |||
RISK_TASK | |||||
| table | New Table | RISK_TASK | |||
RISK_TICKET | |||||
| table | New Table | RISK_TICKET | |||
Employment Hero
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PAYSLIP_DISPLAYED_ACCRUED_LEAVE | |||||
| table | New Table | PAYSLIP_DISPLAYED_ACCRUED_LEAVE | |||
PAYSLIP_DISPLAYED_LEAVE_BALANCE | |||||
| table | New Table | PAYSLIP_DISPLAYED_LEAVE_BALANCE | |||
Facebook Ads
We have deprecated the dma breakdown. Meta has removed it from their Ads Insights API. Custom reports that contain the dma breakdown will stop syncing.
We have deprecated the DEMOGRAPHICS_DMA_REGION prebuilt report because it relies on the dma breakdown. If you have this report configured, it will no longer sync data. We recommend switching to the DEMOGRAPHICS_COMSCORE_MARKET prebuilt report instead.
Forethought
We've added the following new tables:
WORKFLOW.EVENT_CONFIGURATION.PROPERTY.AI_QA_INSIGHT.CUSTOM_EVENT.EMAIL_CONVERSATION.TICKET_REPLY.
We have added new columns, detected_workflows, ending_sentiment_score, relevance_rating, relevance_reasoning, user_engagement, dropoff_reasoning, is_eligible, voice_metric_call_start_time, voice_metric_call_end_time, voice_metric_call_duration, voice_metric_sentiment, voice_metric_avg_response_time, and voice_metric_is_outbound, to the CONVERSATION_HISTORY table.
Front
We've added the following new tables:
MESSAGE_TEMPLATEMESSAGE_TEMPLATE_ATTACHMENTMESSAGE_TEMPLATE_FOLDERMESSAGE_TEMPLATE_INBOX
Genesys
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ACTIVITY_CODE | |||||
| table | New Table | ACTIVITY_CODE | |||
ACTIVITY_CODE_SECONDARY_PRESENCE | |||||
| table | New Table | ACTIVITY_CODE_SECONDARY_PRESENCE | |||
CONVERSATION | |||||
| table | Discontinued Table | CONVERSATION | |||
CONVERSATION_DIVISION | |||||
| table | Discontinued Table | CONVERSATION_DIVISION | |||
CONVERSATION_DIVISION_ENTITY | |||||
| table | Discontinued Table | CONVERSATION_DIVISION_ENTITY | |||
CONVERSATION_ID | |||||
| table | Discontinued Table | CONVERSATION_ID | |||
CONVERSATION_PARTICIPANT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT | |||
CONVERSATION_PARTICIPANT_CALL | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALL | |||
CONVERSATION_PARTICIPANT_CALL_DISCONNECT_REASON | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALL_DISCONNECT_REASON | |||
CONVERSATION_PARTICIPANT_CALL_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALL_SEGMENT | |||
CONVERSATION_PARTICIPANT_CALL_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALL_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_CALLBACK | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALLBACK | |||
CONVERSATION_PARTICIPANT_CALLBACK_NUMBER | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALLBACK_NUMBER | |||
CONVERSATION_PARTICIPANT_CALLBACK_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALLBACK_SEGMENT | |||
CONVERSATION_PARTICIPANT_CALLBACK_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CALLBACK_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_CHAT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CHAT | |||
CONVERSATION_PARTICIPANT_CHAT_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CHAT_SEGMENT | |||
CONVERSATION_PARTICIPANT_CHAT_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CHAT_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION | |||
CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_CONTROLLING | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_CONTROLLING | |||
CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_SEGMENT | |||
CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_COBROWSE_SESSION_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_CONVERSATION_ROUTING_DATA_SCORED_AGENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_ROUTING_DATA_SCORED_AGENT | |||
CONVERSATION_PARTICIPANT_CONVERSATION_ROUTING_DATA_SKILLS | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_CONVERSATION_ROUTING_DATA_SKILLS | |||
CONVERSATION_PARTICIPANT_EMAIL | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EMAIL | |||
CONVERSATION_PARTICIPANT_EMAIL_DRAFT_ATTACHMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EMAIL_DRAFT_ATTACHMENT | |||
CONVERSATION_PARTICIPANT_EMAIL_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EMAIL_SEGMENT | |||
CONVERSATION_PARTICIPANT_EMAIL_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EMAIL_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_EVALUATION | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION | |||
CONVERSATION_PARTICIPANT_EVALUATION_ANSWERS_QUESTION_GROUP_SCORE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION_ANSWERS_QUESTION_GROUP_SCORE | |||
CONVERSATION_PARTICIPANT_EVALUATION_ANSWERS_TRANSCRIPT_TOPIC | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION_ANSWERS_TRANSCRIPT_TOPIC | |||
CONVERSATION_PARTICIPANT_EVALUATION_AUTHORIZED_ACTION | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION_AUTHORIZED_ACTION | |||
CONVERSATION_PARTICIPANT_EVALUATION_FORM_QUESTION_GROUP | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION_FORM_QUESTION_GROUP | |||
CONVERSATION_PARTICIPANT_EVALUATION_MEDIA_TYPE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_EVALUATION_MEDIA_TYPE | |||
CONVERSATION_PARTICIPANT_MEDIA_ROLE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_MEDIA_ROLE | |||
CONVERSATION_PARTICIPANT_MESSAGE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_MESSAGE | |||
CONVERSATION_PARTICIPANT_MESSAGE_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_MESSAGE_SEGMENT | |||
CONVERSATION_PARTICIPANT_MESSAGE_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_MESSAGE_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_SCREENSHARE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SCREENSHARE | |||
CONVERSATION_PARTICIPANT_SCREENSHARE_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SCREENSHARE_SEGMENT | |||
CONVERSATION_PARTICIPANT_SCREENSHARE_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SCREENSHARE_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_SENT_MESSAGE | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SENT_MESSAGE | |||
CONVERSATION_PARTICIPANT_SENT_MESSAGE_MEDIA | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SENT_MESSAGE_MEDIA | |||
CONVERSATION_PARTICIPANT_SENT_MESSAGE_STICKER | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SENT_MESSAGE_STICKER | |||
CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION | |||
CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION_SEGMENT | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION_SEGMENT | |||
CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_SOCIAL_EXPRESSION_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_VIDEO | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_VIDEO | |||
CONVERSATION_PARTICIPANT_VIDEO_MS_ID | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_VIDEO_MS_ID | |||
CONVERSATION_PARTICIPANT_VIDEO_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_VIDEO_WRAPUP_TAG | |||
CONVERSATION_PARTICIPANT_WRAPUP_TAG | |||||
| table | Discontinued Table | CONVERSATION_PARTICIPANT_WRAPUP_TAG | |||
CONVERSATION_RECENT_TRANSFER | |||||
| table | Discontinued Table | CONVERSATION_RECENT_TRANSFER | |||
HEAD_COUNT_FORECAST_ENTITIES | |||||
| table | New Table | HEAD_COUNT_FORECAST_ENTITIES | |||
HISTORICAL_ADHERENCE | |||||
| table | New Table | HISTORICAL_ADHERENCE | |||
HISTORICAL_ADHERENCE_ACTUAL | |||||
| table | New Table | HISTORICAL_ADHERENCE_ACTUAL | |||
HISTORICAL_ADHERENCE_DAY_METRICS | |||||
| table | New Table | HISTORICAL_ADHERENCE_DAY_METRICS | |||
HISTORICAL_ADHERENCE_EXCEPTION_INFO | |||||
| table | New Table | HISTORICAL_ADHERENCE_EXCEPTION_INFO | |||
HISTORICAL_SHRINKAGE | |||||
| table | New Table | HISTORICAL_SHRINKAGE | |||
HISTORICAL_SHRINKAGE_ACTIVITY_CATEGORY | |||||
| table | New Table | HISTORICAL_SHRINKAGE_ACTIVITY_CATEGORY | |||
HISTORICAL_SHRINKAGE_FOR_ACTIVITY_CODE | |||||
| table | New Table | HISTORICAL_SHRINKAGE_FOR_ACTIVITY_CODE | |||
INTRADAY_PLANNING | |||||
| table | New Table | INTRADAY_PLANNING | |||
INTRADAY_PLANNING_ROUTEPATH | |||||
| table | New Table | INTRADAY_PLANNING_ROUTEPATH | |||
MANAGEMENT_UNIT | |||||
| table | New Table | MANAGEMENT_UNIT | |||
SCHEDULE | |||||
| table | New Table | SCHEDULE | |||
SCHEDULE_MANAGEMENT_UNIT | |||||
| table | New Table | SCHEDULE_MANAGEMENT_UNIT | |||
SCHEDULE_MANAGEMENT_UNIT_AGENT | |||||
| table | New Table | SCHEDULE_MANAGEMENT_UNIT_AGENT | |||
SCHEDULE_MESSAGE_SEVERITY_COUNT | |||||
| table | New Table | SCHEDULE_MESSAGE_SEVERITY_COUNT | |||
SPEECH_AND_TEXT_ANALYTICS | |||||
| table | New Table | SPEECH_AND_TEXT_ANALYTICS | |||
SPEECH_AND_TEXT_ANALYTICS_PARTICIPANT | |||||
| table | New Table | SPEECH_AND_TEXT_ANALYTICS_PARTICIPANT | |||
SPEECH_AND_TEXT_ANALYTICS_TRANSCRIPT | |||||
| table | New Table | SPEECH_AND_TEXT_ANALYTICS_TRANSCRIPT | |||
WORKFORCE_MANAGEMENT_INTRADAY | |||||
| table | New Table | WORKFORCE_MANAGEMENT_INTRADAY | |||
WORKFORCE_MANAGEMENT_INTRADAY_GROUP | |||||
| table | New Table | WORKFORCE_MANAGEMENT_INTRADAY_GROUP | |||
WORKFORCE_MANAGEMENT_UNIT_AGENT | |||||
| table | New Table | WORKFORCE_MANAGEMENT_UNIT_AGENT | |||
GitHub
We have added two new columns, epss_percentage and epss_percentile, to the SECURITY_ADVISORY table.
Also, we've added the following new columns to the PULL_REQUEST_REVIEW_COMMENTS table:
lineoriginal_linestart_lineoriginal_start_line
GitLab
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
GROUPS_EPIC_BOARD | |||||
| table | New Table | GROUPS_EPIC_BOARD | |||
GROUPS_EPIC_BOARD_LABEL | |||||
| table | New Table | GROUPS_EPIC_BOARD_LABEL | |||
GROUPS_EPIC_BOARD_LIST | |||||
| table | New Table | GROUPS_EPIC_BOARD_LIST | |||
GROUPS_ISSUE | |||||
| table | New Table | GROUPS_ISSUE | |||
GROUPS_ITERATION | |||||
| table | New Table | GROUPS_ITERATION | |||
Gladly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
VOICE_TRANSCRIPT | |||||
| table | New Table | VOICE_TRANSCRIPT | |||
VOICE_TRANSCRIPT_PARAGRAPH | |||||
| table | New Table | VOICE_TRANSCRIPT_PARAGRAPH | |||
GoFundMe Pro
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CAMPAIGN_SOURCE_TRACKING_CODE | |||||
| table | New Table | CAMPAIGN_SOURCE_TRACKING_CODE | |||
SOURCE_TRACKING_CODE | |||||
| table | Discontinued Table | SOURCE_TRACKING_CODE | |||
Google Ads
We have added the following new columns to the DEMAND_GEN_MULTI_ASSET_AD_HISTORY table:
logo_imagesmarketing_imagesportrait_marketing_imagessquare_marketing_images
Google Calendar
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CALENDAR_LIST | |||||
| column | New Column | data_owner | |||
EVENT | |||||
| column | New Column | birthday_properties_contact | |||
| column | New Column | birthday_properties_custom_type_name | |||
| column | New Column | birthday_properties_type | |||
| column | New Column | color_id | |||
| column | New Column | focus_time_properties_auto_decline_mode | |||
| column | New Column | focus_time_properties_chat_status | |||
| column | New Column | focus_time_properties_decline_message | |||
| column | New Column | out_of_office_properties_auto_decline_mode | |||
| column | New Column | out_of_office_properties_decline_message | |||
| column | New Column | working_location_properties_custom_location_label | |||
| column | New Column | working_location_properties_home_office | |||
| column | New Column | working_location_properties_office_location_building_id | |||
| column | New Column | working_location_properties_office_location_desk_id | |||
| column | New Column | working_location_properties_office_location_floor_id | |||
| column | New Column | working_location_properties_office_location_floor_section_id | |||
| column | New Column | working_location_properties_office_location_label | |||
| column | New Column | working_location_properties_type | |||
Healthie
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
APPOINTMENT_TYPE_SETTING_CALENDAR_COLOR_SCHEME_COLOR_CODE | |||||
| column | Discontinued Column | calendar_color_scheme_id 🔑 | No longer a primary key. | ||
CONVERSATION | |||||
| table | New Table | CONVERSATION | |||
CONVERSATION_MEMBERSHIP | |||||
| column | Discontinued Column | conversation_closed_by_id | |||
| column | Discontinued Column | conversation_closed_date | |||
| column | Discontinued Column | conversation_community_chat_prefix | |||
| column | Discontinued Column | conversation_created_at | |||
| column | Discontinued Column | conversation_dietitian_id | |||
| column | Discontinued Column | conversation_includes_multiple_clients | |||
| column | Discontinued Column | conversation_is_hidden_for_client | |||
| column | Discontinued Column | conversation_last_message_content | |||
| column | Discontinued Column | conversation_last_note_viewed_id | |||
| column | Discontinued Column | conversation_name | |||
| column | Discontinued Column | conversation_owner_id | |||
| column | Discontinued Column | conversation_patient_id | |||
| column | Discontinued Column | conversation_updated_at | |||
| column | Discontinued Column | conversation_user_group_id | |||
CONVERSATION_NOTE | |||||
| column | Discontinued Column | attached_audio_url | |||
| column | Discontinued Column | attached_image_url | |||
| column | Discontinued Column | content | |||
| column | Discontinued Column | created_at | |||
| column | Discontinued Column | deleted_by_user | |||
| column | Discontinued Column | document_id | |||
| column | Discontinued Column | image_name | |||
| column | Discontinued Column | is_autoresponse | |||
| column | Discontinued Column | recipient_id | |||
| column | Discontinued Column | scheduled_at | |||
| column | Discontinued Column | task_id | |||
| column | Discontinued Column | updated_at | |||
| column | Discontinued Column | user_id | |||
| column | Discontinued Column | viewed | |||
NOTE | |||||
| table | New Table | NOTE | |||
Intercom
We have added two new columns, url and custom_domain, to the HELP_CENTER_HISTORY table.
Iterable
We've added two new tables, CAMPAIGN_METRICS_WEEKLY and CAMPAIGN_METRICS_MONTHLY.
Jotform
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TEAM_SUBMISSION | |||||
| column | Primary Key Change | form_id | form_id 🔑 | Added to the primary key. | |
TEAM_SUBMISSION_ANSWER | |||||
| column | Primary Key Change | form_id | form_id 🔑 | Added to the primary key. | |
Katana
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BOM_ROW | |||||
| table | New Table | BOM_ROW | |||
MATERIAL_SUPPLIER_ITEM_CODE | |||||
| column | Primary Key Change | material_id 🔑 | material_id | No longer a primary key. | |
OUTSOURCE_PURCHASE_BATCH_TRANSACTION | |||||
| column | Primary Key Change | batch_id 🔑 | batch_id | No longer a primary key. | |
| column | New Column | index 🔑 | |||
PURCHASE_ORDER_ROW_BATCH_TRANSACTION | |||||
| column | Primary Key Change | batch_id 🔑 | batch_id | No longer a primary key. | |
| column | New Column | index 🔑 | |||
RECIPE | |||||
| table | Discontinued Table | RECIPE | |||
STOCK_ADJUSTMENT_ROW_BATCH_TRANSACTION | |||||
| column | Primary Key Change | batch_id 🔑 | batch_id | No longer a primary key. | |
| column | New Column | index 🔑 | |||
LaunchDarkly
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
FEATURE_FLAG_STATUS | |||||
| table | New Table | FEATURE_FLAG_STATUS | |||
FLAG_EVENT | |||||
| table | New Table | FLAG_EVENT | |||
FLAG_EVENT_EXPERIMENT_ITEM | |||||
| table | New Table | FLAG_EVENT_EXPERIMENT_ITEM | |||
Lever
We have added a new column, sourced_by, to the OPPORTUNITY table.
We have added a new column, department, to the REQUISITION table.
LinkedIn Ad Analytics
We've added the following new columns to the CAMPAIGN_HISTORY table:
connected_television_onlyoptimization_preference_frequency_optimization_preference_frequencyoptimization_preference_frequency_optimization_preference_optimization_typeoptimization_preference_frequency_optimization_preference_time_span_durationoptimization_preference_frequency_optimization_preference_time_span_unit
LinkedIn Company Pages
We have added the TIME_BOUND_VIDEO_ANALYTICS table which provides video performance metrics for video posts.
Lucca
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
USER_LOCATION | |||||
| table | New Table | USER_LOCATION | |||
WORK_CONTRACT | |||||
| table | New Table | WORK_CONTRACT | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
LEAVE_ACCOUNT | |||||
| column | Discontinued Column | leave_profile_entitlements | |||
MaintainX
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSET | |||||
| column | New Column | downtime_type | |||
| column | New Column | started_at | |||
| column | New Column | status | |||
| column | New Column | status_created_at | |||
| column | New Column | status_description | |||
| column | New Column | status_id | |||
| column | New Column | status_updated_at | |||
Maxio Chargify
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
OFFER_DISCOUNTS | |||||
| column | Primary Key Change | coupon_id 🔑 | coupon_id | No longer a primary key. | |
| column | New Column | index 🔑 | Added to primary key. | ||
SUBSCRIPTION_COUPON | |||||
| table | Discontinued Table | SUBSCRIPTION_COUPON | |||
Microsoft Advertising
We've added the following new columns to the AD_PERFORMANCE_DAILY_REPORT and AD_PERFORMANCE_HOURLY_REPORT tables:
average_cpvaverage_watch_time_per_video_viewcompleted_video_viewstotal_watch_time_in_msvideo_completion_ratevideo_views_at_25_percentvideo_views_at_50_percentvideo_views_at_75_percentvideo_viewsview_through_rate
We have added the following new tables:
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT_UPCOMINGPRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT_UPCOMINGPRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT_UPCOMINGPRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORT_UPCOMING
Tables with the suffix, _UPCOMING, are new versions of existing tables. From June 10, 2026 through July 14, 2026, we will sync data to both the legacy tables and their corresponding new versions with the _UPCOMING suffix.
New tables use _fivetran_id as a primary key instead of the composite primary key in the legacy tables. For more information about primary keys and columns for this connector, see our Microsoft Ads Prebuilt Reports documentation.
The new tables with the _UPCOMING suffix will not count toward your paid MAR until July 14, 2026.
Microsoft Entra ID
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DEVICE_INSTALL_STATUS_BY_APP | |||||
| table | New Table | DEVICE_INSTALL_STATUS_BY_APP | |||
Microsoft Teams
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SESSION | |||||
| column | Primary Key Change | start_date_time | start_date_time 🔑 | Added to primary key | |
SESSION_MEDIA | |||||
| column | Primary Key Change | session_start_date_time 🔑 | New primary key | ||
SESSION_MEDIA_STREAM | |||||
| column | Primary Key Change | session_start_date_time 🔑 | New primary key | ||
MNTN
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ANALYTICS_BY_COUNTRY | |||||
| column | Discontinued Column | cost_per_acquisition | |||
| column | Discontinued Column | return_on_ad_spend | |||
| column | Discontinued Column | return_on_investment | |||
ANALYTICS_BY_STATE | |||||
| column | Discontinued Column | cost_per_acquisition | |||
| column | Discontinued Column | return_on_ad_spend | |||
| column | Discontinued Column | return_on_investment | |||
SEGMENT | |||||
| column | Discontinued Column | cost_per_acquisition | |||
| column | Discontinued Column | return_on_ad_spend | |||
| column | Discontinued Column | return_on_investment | |||
| column | New Column | existing_site_visitor | |||
| column | New Column | existing_user_reached | |||
| column | New Column | new_site_visitor | |||
| column | New Column | new_user_reached | |||
| column | New Column | site_visitor | |||
SEGMENT_INFO | |||||
| column | Discontinued Column | cost_per_acquisition | |||
| column | Discontinued Column | return_on_ad_spend | |||
| column | Discontinued Column | return_on_investment | |||
Navan
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TRANSACTION | |||||
| column | Discontinued Column | adjustment_description | |||
| column | Discontinued Column | admin_note | |||
| column | Rename Column | amount_rejected | rejected_amount | ||
| column | Discontinued Column | amount_repaid | |||
| column | Discontinued Column | billable_entity | |||
| column | Discontinued Column | card_nickname | |||
| column | Discontinued Column | card_owner | |||
| column | Discontinued Column | cardholder_guest | |||
| column | Discontinued Column | est_doc_date | |||
| column | Discontinued Column | est_doc_link | |||
| column | Discontinued Column | est_doc_number | |||
| column | Discontinued Column | hotel_payment_type | |||
| column | Discontinued Column | inviter_cost_center | |||
| column | Discontinued Column | inviter_department | |||
| column | Discontinued Column | inviter_email | |||
| column | Discontinued Column | inviter_employee_id | |||
| column | Discontinued Column | inviter_name | |||
| column | Discontinued Column | inviter_region | |||
| column | Discontinued Column | inviter_subsidiary | |||
| column | Discontinued Column | item_id 🔑 | Data is available in the line_item_id column of the TRANSACTION_LINE_ITEM table. | ||
| column | Primary Key Change | item_id 🔑 | No longer a primary key. | ||
| column | Discontinued Column | item_title | Data is available in the name column of the TRANSACTION_LINE_ITEM table. | ||
| column | Rename Column | legal_entity_amount | billable_entity_amount | ||
| column | Rename Column | legal_entity_currency | billable_entity_currency | ||
| column | Discontinued Column | net_amount | Data is available in the net_amount column of the TRANSACTION_LINE_ITEM table. | ||
| column | Discontinued Column | net_amount_1 | Data is available in the net_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | net_amount_2 | Data is available in the net_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | net_amount_3 | Data is available in the net_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | original_txn_id | |||
| column | Discontinued Column | requested_amount | |||
| column | Discontinued Column | ta_invoice | |||
| column | Discontinued Column | tax_amount_1 | Data is available in the tax_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_amount_2 | Data is available in the tax_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_amount_3 | Data is available in the tax_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_total | Data is available in the total_amount column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_type_1 | Data is available in the tax_type column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_type_2 | Data is available in the tax_type column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Discontinued Column | tax_type_3 | Data is available in the tax_type column of the TRANSACTION_TAX_LINE_DETAIL table. | ||
| column | Rename Column | transaction_department | department | ||
| column | Rename Column | transaction_region | region | ||
| column | Rename Column | transaction_subsidiary | subsidiary | ||
| column | Rename Column | travelers_employee_id | traveler_employee_id | ||
| column | Discontinued Column | vcf_transaction_reference_number | |||
| column | New Column | card_program_name | |||
| column | New Column | detail_type | |||
| column | New Column | erp_effective_date | |||
| column | New Column | erp_sync_status | |||
| column | New Column | itemized | |||
| column | New Column | reverse_charge | |||
| column | New Column | transaction_date | |||
| column | New Column | transaction_type | |||
TRANSACTION_LINE_ITEM | |||||
| table | New Table | TRANSACTION_LINE_ITEM | |||
TRANSACTION_TAX_LINE_DETAIL | |||||
| table | New Table | TRANSACTION_TAX_LINE_DETAIL | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BOOKING_SEGMENT | |||||
| column | New Column | cabin | |||
| column | New Column | cabin_purchased | |||
Okta
We've added the following new tables:
GROUP_PUSH_MAPPINGREALMREALM_ASSIGNMENT
We've added the following new columns to the USERS table:
realm_idprofile_functionprofile_bob_departmentprofile_internal_lifecycle_status.
We have added the following new columns to the POLICY_RULE table:
risk_behaviors_conditionrisk_score_level_conditionidentity_provider_conditionplatform_include_conditionplatform_exclude_conditionuser_identifier_patterns_conditionapp_include_conditionapp_exclude_conditionsignon_factor_prompt_modesignon_factor_lifetimeenroll_selfpassword_change_accesspassword_reset_accesspassword_reset_primary_methodspassword_reset_stepup_requiredpassword_unlock_accessidp_providersidp_selection_typeidp_should_fallback_to_oktaprofile_enrollment_accessprofile_enrollment_unknown_user_actionprofile_enrollment_activation_email_verificationprofile_enrollment_ui_schema_idprofile_enrollment_progressive_profiling_actionprofile_enrollment_pre_registration_inline_hooksprofile_enrollment_target_group_idsprofile_enrollment_profile_attributesapp_signon_accessapp_signon_verification_factor_modeapp_signon_verification_typeapp_signon_verification_reauthenticate_inapp_signon_verification_constraints
We are gradually rolling out this change to all existing connections.
Ometria
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PROFILE | |||||
| column | New Column | date_predicted_next_purchase | |||
PandaDoc
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DOCUMENT_TOKEN | |||||
| column | Primary Key Change | name 🔑 | name | No longer a primary key. | |
| column | New Column | index 🔑 | Added to primary key. | ||
Pipedrive
We now sync the employee_count column of the ORGANIZATION table as LONG. Previously, we synced the column as INT.
PostgreSQL
For PostgreSQL connections using Query-Based incremental sync without delete capture, the _fivetran_deleted column now contains false instead of null.
Productboard
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COMPANY_CUSTOM_FIELD | |||||
| table | New Table | COMPANY_CUSTOM_FIELD | |||
Pylon Support Platform
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ISSUE_THREAD | |||||
| table | New Table | ISSUE_THREAD | |||
Recharge
We have added a new column, currency, to the CHARGE table.
We have added a new column, presentment_currency, to the SUBSCRIPTION table.
Reddit Ads
We've added the following new columns to the BUSINESS_ACCOUNT table:
app_attribution_typeapp_click_attribution_windowapp_view_attribution_windowprimary_contact_member_idspend_cap_type
Salesforce
We've added a new table, APEX_CODE_COVERAGE_AGGREGATE.
We're gradually rolling out this change to all connections.
Salesforce Marketing Cloud
We've added a new table, CLOUD_PAGE. The table contains Cloud Pages, which are web pages and microsites created and hosted in Salesforce Marketing Cloud. Syncing this table will count towards free MAR until June 21, 2026.
Salesloft
We have added a new table, CONVERSATION.
Salsify
We have added two new tables, ATTRIBUTE and ATTRIBUTE_VALUE. We are gradually rolling out this change to all existing connections.
SAP Concur
We have added the following new columns to the EXPENSE_ENTRY table:
employee_bank_account_idexpense_type_codeform_idhas_applied_cash_advancehas_imageis_billablejourney_business_distancejourney_end_locationjourney_number_of_passengersjourney_odometer_endjourney_odometer_startjourney_personal_distancejourney_start_locationjourney_unit_of_measurelocation_idtrip_idvendor_list_item_idvendor_list_item_name
We have added a new column, id, to the ENTRY_ATTENDEE_ASSOCIATION table.
We have added two new tables, LIST_ITEM and LIST_ITEM_MEMBER_LIST.
SAP SuccessFactors
We have added the following new tables:
CALIBRATION_SESSIONCALIBRATION_SESSION_SUBJECTCALIBRATION_SUBJECT_RANKCALIBRATION_TEMPLATEEMP_JOB_RELATIONSHIPFORM_AUDIT_TRAILFORM_BEHAVIOR_RATING_COMMENTFORM_COMPETENCY_BEHAVIORFORM_CONTENTFORM_HEADERFORM_INTRODUCTION_SECTIONFORM_OBJ_COMP_SUMMARY_SECTIONFORM_OBJECTIVEFORM_OBJECTIVE_COMMENTFORM_OBJECTIVE_DETAILSFORM_OBJECTIVE_OTHER_DETAILS_ITEMFORM_OBJECTIVE_OTHER_DETAILS_ITEM_COLFORM_OBJECTIVE_OTHER_DETAILS_ITEM_VALUE_CELLFORM_OBJECTIVE_SECTIONFORM_PERF_POT_SUMMARY_SECTIONFORM_RATING_SCALEFORM_RATING_SCALE_VALUEFORM_REVIEW_FEEDBACKFORM_SIGNATUREFORM_SUMMARY_SECTIONFORM_USER_INFORMATION_SECTIONPER_ADDRESS_DEFLTPER_EMERGENCY_CONTACTPER_PERSON_RELATIONSHIPPER_PHONE
Shopify
We've added the following new tables to sync Shopify Markets data:
MARKETMARKET_CATALOGMARKET_CONDITIONMARKET_CONDITION_COMPANY_LOCATIONMARKET_CONDITION_LOCATIONMARKET_CONDITION_REGIONMARKET_REGION
We have added the following new tables:
GIFT_CARD_TRANSACTIONGIFT_CARD_TRANSACTION_METAFIELDORDER_LINE_DUTYORDER_LINE_DUTY_TAX_LINEPRICE_LISTPRICE_LIST_PRICERETURN_EXCHANGE_LINE_ITEMRETURN_EXCHANGE_LINE_ITEM_ORDER_LINE
The price_list_id column in the CATALOG table now has a foreign key relationship to the PRICE_LIST table.
We have added the following new columns to the RETURN_LINE_ITEM table:
restocking_fee_amount_set_pres_amountrestocking_fee_amount_set_pres_currency_coderestocking_fee_amount_set_shop_amountrestocking_fee_amount_set_shop_currency_coderestocking_fee_idrestocking_fee_percentage
We have added the following new columns to the TRANSACTION table:
currency_exchange_adjustmentcurrency_exchange_currencycurrency_exchange_final_amountcurrency_exchange_idcurrency_exchange_original_amount
Showpad
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COMMENT | |||||
| table | New Table | COMMENT | |||
CRM_SHARE_RECORD | |||||
| table | New Table | CRM_SHARE_RECORD | |||
CRM_SHARED_SPACE_RECORD | |||||
| table | New Table | CRM_SHARED_SPACE_RECORD | |||
DIVISION_PERMISSION | |||||
| table | New Table | DIVISION_PERMISSION | |||
MAP | |||||
| table | New Table | MAP | |||
MAP_PARTICIPANT | |||||
| table | New Table | MAP_PARTICIPANT | |||
RECOMMENDATION_ASSET_NEW | |||||
| table | New Table | RECOMMENDATION_ASSET_NEW | |||
RECOMMENDATION_RULE | |||||
| table | New Table | RECOMMENDATION_RULE | |||
RECOMMENDATION_RULE_CONDITION | |||||
| table | New Table | RECOMMENDATION_RULE_CONDITION | |||
RECOMMENDATION_RULE_TAGS_ALL | |||||
| table | New Table | RECOMMENDATION_RULE_TAGS_ALL | |||
RECOMMENDATION_RULE_TAGS_ANY | |||||
| table | New Table | RECOMMENDATION_RULE_TAGS_ANY | |||
RECOMMENDATION_RULE_TAGS_NONE | |||||
| table | New Table | RECOMMENDATION_RULE_TAGS_NONE | |||
SHARED_SPACE_QUICK_ACTION | |||||
| table | New Table | SHARED_SPACE_QUICK_ACTION | |||
SHARED_SPACE_TEMPLATE | |||||
| table | New Table | SHARED_SPACE_TEMPLATE | |||
TICKET | |||||
| table | New Table | TICKET | |||
USER_PERMISSION | |||||
| table | New Table | USER_PERMISSION | |||
Skilljar
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COURSE | |||||
| column | New Column | created_at | |||
| column | New Column | modified_at | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COURSE_SERIES_PUBLISHED_COURSE | |||||
| table | New Table | COURSE_SERIES_PUBLISHED_COURSE | |||
PATH_ITEM | |||||
| table | New Table | PATH_ITEM | |||
Snapchat Ads
We have added the following new tables:
AD_SQUAD_DELIVERY_STATUSAD_SQUAD_PLACEMENT_V2_PLATFORMAD_SQUAD_PLACEMENT_V2_SNAPCHAT_POSITION
We have added two new columns, event_sources and placement_v2_config, to the AD_SQUAD_HISTORY table.
sticky.io
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PROSPECT_VIEW | |||||
| table | New Table | PROSPECT_VIEW | To backfill the historical records, trigger a re-sync. | ||
PROSPECT_VIEW_CUSTOM_FIELD | |||||
| table | New Table | PROSPECT_VIEW_CUSTOM_FIELD | To backfill the historical records, trigger a re-sync. | ||
PROSPECT_VIEW_CUSTOM_FIELD_VALUE | |||||
| table | New Table | PROSPECT_VIEW_CUSTOM_FIELD_VALUE | To backfill the historical records, trigger a re-sync. | ||
Stripe
We have added a new table, BILLING_METER. We are gradually rolling out this change to all existing connections.
We now sync discounts associated with subscription items to the DISCOUNT table.
We have added the following new tables to support Payment Links:
PAYMENT_LINKPAYMENT_LINK_CUSTOM_FIELDPAYMENT_LINK_CUSTOM_FIELD_DROPDOWN_OPTIONPAYMENT_LINK_INVOICE_CREATION_INVOICE_DATA_ACCOUNT_TAXPAYMENT_LINK_INVOICE_CREATION_INVOICE_DATA_CUSTOM_FIELDPAYMENT_LINK_LINE_ITEMPAYMENT_LINK_PAYMENT_METHOD_TYPEPAYMENT_LINK_SHIPPING_OPTION
Talkdesk
We've added a new table, ADVANCED_DIALER_CALL.
We have added a new column, team_name, to the USER_STATUS table. We are gradually rolling out this change to all existing connections.
Toggl Track
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
TIME_ENTRY_TAG | |||||
| column | Primary Key Change | time_entry_id 🔑 | time_entry_id | No longer a primary key. | |
| column | New Column | user_id | |||
Validio
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SOURCE | |||||
| column | Discontinued Column | config_look_back_day | Validio deprecated the column. | ||
Visma
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
GENERAL_LEDGER_BALANCE | |||||
| column | New Column | account_type | |||
SUPPLIER_INVOICE_LINE | |||||
| column | New Column | account_type | |||
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
JOURNAL_TRANSACTION | |||||
| column | Primary Key Change | financial_period_id 🔑 | financial_period_id | No longer a primary key. | |
JOURNAL_TRANSACTION_ATTACHMENT | |||||
| column | Primary Key Change | financial_period_id 🔑 | financial_period_id | No longer a primary key. | |
JOURNAL_TRANSACTION_LINE | |||||
| column | Primary Key Change | financial_period_id 🔑 | financial_period_id | No longer a primary key. | |
JOURNAL_TRANSACTION_LINE_ATTACHMENT | |||||
| column | Primary Key Change | financial_period_id 🔑 | financial_period_id | No longer a primary key. | |
JOURNAL_TRANSACTION_LINE_SUB_ACCOUNT_SEGMENT | |||||
| column | Primary Key Change | financial_period_id 🔑 | financial_period_id | No longer a primary key. | |
SUPPLIER | |||||
| column | Primary Key Change | number 🔑 | number | No longer a primary key. | |
SUPPLIER_INVOICE | |||||
| column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | Primary key calculation change. | |
When I Work
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SHIFT_BREAK_AUDIT | |||||
| column | New Column | created_at | |||
| column | New Column | updated_at | |||
Workable
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EMPLOYEE | |||||
| table | New Table | EMPLOYEE | |||
EMPLOYEE_DOCUMENT | |||||
| table | New Table | EMPLOYEE_DOCUMENT | |||
EMPLOYEE_FIELD | |||||
| table | New Table | EMPLOYEE_FIELD | |||
EMPLOYEE_FIELD_CHOICE | |||||
| table | New Table | EMPLOYEE_FIELD_CHOICE | |||
Workday Financial Management
We have made the following changes to the ORGANIZATION table:
- Added a new column,
code, to store organization codes. Previously, we synced these codes into theorganization_codecolumn. - Stopped syncing organization codes into the
organization_codecolumn. The existing organization codes stored in this column are now available in thecodecolumn.
We have added the following new tables, BUSINESS_UNIT, BUSINESS_UNIT_HIERARCHY, and BUSINESS_UNIT_HIERARCHY_CONTAINS_BUSINESS_UNIT.
We have added the following new tables:
BANK_STATEMENTBANK_STATEMENT_SUMMARYBANK_STATEMENT_TRANSACTIONFUNDS_AVAILABILITY_DATA
We have added the following new fund management tables:
FUNDFUND_HIERARCHYFUND_HIERARCHY_FUNDS_REFERENCEFUND_TYPE
Xandr
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
BUDGET_INTERVAL_CREATIVE | |||||
| column | Discontinued Column | line_item_insertion_order_id 🔑 | No longer a primary key. | ||
LINE_ITEM_INSERTION_ORDER_BUDGET_INTERVAL | |||||
| column | Discontinued Column | line_item_insertion_order_id 🔑 | No longer a primary key. | ||
Younium
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
SUBSCRIPTION_PRODUCT_CHARGE | |||||
| column | New Column | deferred_revenue_account | |||
| column | New Column | recognized_revenue_account | |||
Zip
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
APPROVAL | |||||
| column | New Column | active_duration_seconds | |||
| column | New Column | active_elapsed_seconds | |||
| column | New Column | total_duration_seconds | |||
| column | New Column | total_elapsed_seconds | |||
Zoho Recruit
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ACCOUNT | |||||
| table | Discontinued Table | ACCOUNT | |||
ACCOUNT_DRAFT | |||||
| table | New Table | ACCOUNT_DRAFT | |||
ACCOUNT_SAVE | |||||
| table | New Table | ACCOUNT_SAVE | |||
ACCOUNT_TAG | |||||
| table | Discontinued Table | ACCOUNT_TAG | |||
ACCOUNT_TAG_DRAFT | |||||
| table | New Table | ACCOUNT_TAG_DRAFT | |||
ACCOUNT_TAG_SAVE | |||||
| table | New Table | ACCOUNT_TAG_SAVE | |||
CANDIDATE | |||||
| table | Discontinued Table | CANDIDATE | |||
CANDIDATE_ASSOCIATE_TAG_DRAFT | |||||
| table | New Table | CANDIDATE_ASSOCIATE_TAG_DRAFT | |||
CANDIDATE_ASSOCIATE_TAG_SAVE | |||||
| table | New Table | CANDIDATE_ASSOCIATE_TAG_SAVE | |||
CANDIDATE_DRAFT | |||||
| table | New Table | CANDIDATE_DRAFT | |||
CANDIDATE_SAVE | |||||
| table | New Table | CANDIDATE_SAVE | |||
CANDIDATE_TAG | |||||
| table | Discontinued Table | CANDIDATE_TAG | |||
INTERVIEW | |||||
| table | Discontinued Table | INTERVIEW | |||
INTERVIEW_DRAFT | |||||
| table | New Table | INTERVIEW_DRAFT | |||
INTERVIEW_SAVE | |||||
| table | New Table | INTERVIEW_SAVE | |||
INTERVIEW_TAG | |||||
| table | Discontinued Table | INTERVIEW_TAG | |||
INTERVIEW_TAG_DRAFT | |||||
| table | New Table | INTERVIEW_TAG_DRAFT | |||
INTERVIEW_TAG_SAVE | |||||
| table | New Table | INTERVIEW_TAG_SAVE | |||
INTERVIEWER | |||||
| table | Discontinued Table | INTERVIEWER | |||
INTERVIEWER_DRAFT | |||||
| table | New Table | INTERVIEWER_DRAFT | |||
INTERVIEWER_SAVE | |||||
| table | New Table | INTERVIEWER_SAVE | |||
JOB_OPENING | |||||
| table | Discontinued Table | JOB_OPENING | |||
JOB_OPENING_ASSIGNED_RECRUITER | |||||
| table | Discontinued Table | JOB_OPENING_ASSIGNED_RECRUITER | |||
JOB_OPENING_ASSIGNED_RECRUITER_DRAFT | |||||
| table | New Table | JOB_OPENING_ASSIGNED_RECRUITER_DRAFT | |||
JOB_OPENING_ASSIGNED_RECRUITER_SAVE | |||||
| table | New Table | JOB_OPENING_ASSIGNED_RECRUITER_SAVE | |||
JOB_OPENING_DRAFT | |||||
| table | New Table | JOB_OPENING_DRAFT | |||
JOB_OPENING_SAVE | |||||
| table | New Table | JOB_OPENING_SAVE | |||
JOB_OPENING_TAG | |||||
| table | Discontinued Table | JOB_OPENING_TAG | |||
JOB_OPENING_TAG_DRAFT | |||||
| table | New Table | JOB_OPENING_TAG_DRAFT | |||
JOB_OPENING_TAG_SAVE | |||||
| table | New Table | JOB_OPENING_TAG_SAVE | |||
VENDOR | |||||
| table | Discontinued Table | VENDOR | |||
VENDOR_DRAFT | |||||
| table | New Table | VENDOR_DRAFT | |||
VENDOR_SAVE | |||||
| table | New Table | VENDOR_SAVE | |||
VENDOR_TAG | |||||
| table | Discontinued Table | VENDOR_TAG | |||
VENDOR_TAG_SAVE | |||||
| table | New Table | VENDOR_TAG_SAVE | |||
Zoom
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
PHONE_CALL_PATH | |||||
| column | Discontinued Column | waiting_time | |||
| column | New Column | callee_did_number | |||
| column | New Column | callee_email | |||
| column | New Column | callee_ext_id | |||
| column | New Column | callee_ext_number | |||
| column | New Column | callee_ext_type | |||
| column | New Column | callee_name | |||
| column | New Column | caller_did_number | |||
| column | New Column | caller_email | |||
| column | New Column | caller_ext_number | |||
| column | New Column | caller_ext_type | |||
| column | New Column | caller_name | |||
| column | New Column | cost_center | |||
| column | New Column | wait_time | |||
Zuora
We have added the following tables for the connections configured with the Sync Zuora Billing and Sync both Billing and Revenue sync modes:
REVENUECONTRACTBILLSFACTSREVENUECONTRACTVCFACTSREVENUECONTRACTMJENTRIESFACTSREVENUECONTRACTLINESFACTSREVENUECONTRACTCOSTFACTSREVENUECONTRACTAPPROVALSREVENUECONTRACTCOSTDIMENSIONSREVENUECONTRACTHOLDSREVENUECONTRACTMJENTRIESDIMENSIONSREVENUECONTRACTVCDIMENSIONSREVENUECONTRACTNETTINGSTATUSREVENUECALENDARREVENUECONTRACTREVENUECONTRACTACCOUNTINGENTRIESREVENUECONTRACTACCOUNTINGSEGMENTSREVENUECONTRACTACCOUNTINGTYPEREVENUECONTRACTACTIONSREVENUECONTRACTBILLSDIMENSIONSREVENUEPERIODSREVENUECONTRACTLINESDIMENSIONS
We are gradually rolling out this change to all existing connections.
We have added a new column, discountamount, to the INVOICE_ITEM table.
Improvements
360Learning
Due to 360Learning’s deprecation of API v1, we have removed API key authentication and updated this connector to support only OAuth 2.0. For more information on how to migrate from API v1 to API v2, see 360Learning's migration guides. If you have an existing connection that uses an API key, you must reconfigure it to use OAuth 2.0. For more information, see our setup guide.
Adobe Analytics Data Feed
The Adobe Analytics Data Feed connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Assembled
We have updated the sync strategy for the TIME_OFF_REQUEST and TIME_OFF_UPDATE tables. In addition to incremental syncs, we now re-import these tables weekly to capture updates and deletes. We are gradually rolling out this change to all existing connections.
AWS MSK
The AWS MSK connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure DevOps
We have updated the sync strategy for the WORK_ITEM_REVISION table. We now incrementally sync work item revisions using a time-based cursor, so only new or updated revisions are fetched during each sync.
BigCommerce
We've updated the sync strategy for the ORDERS table to use a trailing cursor with a 12-hour offset. This ensures that recently modified orders are not missed due to upstream processing delays.
Billing Platform
We have updated our sync strategy and now incrementally sync the following tables:
ACCOUNTACCOUNT_PACKAGEACCOUNT_PRODUCTACTIVITYACTIVITY_COLLECTORBILLING_IDENTIFIERBILLING_PROFILECOLLECTOR_FIELDCONTRACTCONTRACT_CURRENCYCONTRACT_RATEDUNNING_INTERVALINVOICEINVOICE_TEMPLATEPAYMENTREVREC_CONTRACTTIME_ZONEUSERS
Previously, we re-imported these tables daily.
Bizzabo
We've improved the sync strategy for the REGISTRATION table to support delete detection. Registrations with a validity value of invalid are now captured as deleted records in your destination.
Ceridian Dayforce
We now sync future data for up to 6 months from the current date for the EMPLOYEE_MANAGER and WORK_ASSIGNMENT tables.
We have changed the sync strategy for the EMPLOYEE and EMPLOYEE_TIME_AWAY_FROM_WORK tables. We now perform a rollback sync for these tables during every sync. The rollback window is 30 days, allowing us to capture updates made within that period. Previously, we only incrementally synced them.
Cin7
We now incrementally sync the following tables and their child tables:
ADJUSTMENTBOM_MASTERBRANCHCONTACTCREDIT_NOTEPAYMENTPRODUCTPRODUCTION_JOBPURCHASE_ORDERQUOTESALES_ORDERSTOCK
CockroachDB
We have made the following improvements to the CockroachDB connector:
- We now support the GEOGRAPHY and GEOMETRY data types. We sync these values as GeoJSON.
- We now support CockroachDB versions 22.1.0 - 26.2.0.
- We now support syncing tables that use multiple column families.
Collibra
We now sync additional metadata fields for the ASSET and DOMAIN tables. Previously, we excluded these fields from the sync. These metadata fields will count towards your MAR.
Customer.io
We have reduced the rollback sync window for the MESSAGE table from 6 months to 3 months to improve sync reliability and performance.
Db2 for LUW
Our Db2 for LUW connector is now in beta. For more information, see our Db2 for LUW connector documentation.
We have added a new field, Allowed Senders, to the connection setup form. You can now use this field to restrict file ingestion to approved email addresses or domains. If specified, the connector processes only emails from matching senders. For more information, see our documentation
External Logs
We've improved external log service management with setup status visibility and on-demand setup testing.
Setup status in the dashboard
The log connectors dashboard now displays a status badge for each configured log service:
- Connected — the log service is reachable and working correctly.
- Broken — the log service configuration has errors that prevent log delivery. Log events are not forwarded while the log service is in this state.
- Incomplete — the log service is configured but setup has not been completed. Log events are not forwarded while the log service is in this state.
Log services that were configured before this change have no status yet and are treated as Connected by default. No setup test run is required for existing log services.
Setup testing via the API
You can now trigger setup tests when creating or updating a log service by passing "run_setup_tests": true in the request body. The test results are returned immediately in the setup_tests field of the response.
A dedicated endpoint is also available to run setup tests on demand without modifying the log service configuration:
- Group-level:
POST /v1/external-logging/{logId}/test - Account-level:
POST /v1/external-logging/account/test
Setup state in the API response
Log service endpoints return a status object when one exists. The status.setup_state field reflects the current state — connected, broken, or incomplete — and status.tasks lists any configuration issues that need attention. Log services created before this feature was introduced will not include a status field until their status is first set.
Gong
We have fixed a bug that prevented syncing the custom base URL in our Gong connector. To improve connector reliability, we have added a new field, API base URL, to the connection setup form. We will discontinue the Base URL field on July 8, 2026. For more information, see our setup instructions.
We have updated the sync strategy for the CALL table. We now replay the last 2 days of data on a daily basis to capture late-arriving updates such as transcripts and scores.
Greenhouse
We now use a 6-hour lookback window during incremental syncs for the CANDIDATE table to capture delayed updates from Greenhouse. We are gradually rolling out this change to all existing connections.
Healthie
We have added an optional field, Shard authorization ID, in the setup form to allow you to connect your data if it is stored in a shard.
High-Volume Agent SAP ECC on Oracle
Our SAP ECC on Oracle connector is now generally available.
Read our High-Volume Agent SAP ECC on Oracle documentation.
High-Volume Agent SAP ECC on Oracle with NetWeaver
Our SAP ECC on Oracle with NetWeaver connector is now generally available.
Read our High-Volume Agent SAP ECC on Oracle with NetWeaver documentation.
High-Volume Agent SAP ECC on SQL Server
Our SAP ECC on SQL Server connector is now generally available.
Read our High-Volume Agent SAP ECC on SQL Server documentation.
HubSpot
We have updated our sync strategy and now incrementally sync the MARKETING_CAMPAIGN_CONTACT table and its child tables. Previously, we re-imported this table. As part of this change, we no longer capture deletes for this table.
HVA SAP ECC on Oracle
We've added support for the Proxy Agent connection method to the HVA SAP ECC on Oracle and HVA SAP ECC on Oracle with NetWeaver connectors. You can now use Proxy Agent to connect to your SAP ECC on Oracle instance without opening inbound firewall ports.
For more information, see our HVA SAP ECC on Oracle documentation, HVA SAP ECC on Oracle setup guide, HVA SAP ECC on Oracle with NetWeaver documentation, and HVA SAP ECC on Oracle with NetWeaver setup guide.
Iterable
Fivetran adds support for token-based webhook authentication, Basic and OAuth 2.0, for new Iterable connections. When you set up a new connection, you can choose a Webhook Authentication method for incoming webhook events. We generate a secret token that you configure in your Iterable webhook settings.
The selected authentication method is permanent and cannot be changed after the connection is created. All existing connections default to No Auth.
Khoros Communities
We have upgraded the Khoros Communities connector to use the Bulk Data API v3. As part of this upgrade, Khoros Communities connections now use OAuth 2.0 Authorization Code authentication instead of HTTP Basic authentication. To continue syncing data, re-authenticate your existing Khoros Communities connections using the new authentication method. For more information, see our setup instructions.
Kisi
We have improved sync reliability for the ROLE_ASSIGNMENT table. Previously, syncs failed when a Kisi account contained more than 20,000 role assignments because the connection attempted to paginate beyond the Kisi API limit. Kisi connections now sync up to 20,000 role assignment records and skip any additional records beyond the API limit. We complete the sync and display a warning when the connection skip records.
Klarna
Effective July 4, 2026, you can specify the delimiter used in your Klarna settlement reports to improve sync reliability for reports that use a delimiter other than the default value. To support this enhancement, we have made the following changes:
- Added a new field, CSV delimiter, to the connection setup form
- Added a new API parameter,
csv_delimiter, to the Fivetran REST API
We will automatically migrate the current delimiter values for all existing connections.
Lever
We have updated the sync strategy for the POSTING_TAG_ALL and POSTING_TAG_WITH_PARAM tables and their child tables. We now incrementally sync them. Previously, we re-imported these tables during every sync. We are gradually rolling out this change to all existing connections.
Lob
We have changed the sync strategy for the the LETTER table. We now re-import this table daily to capture updates and deletes. Previously, we re-imported it weekly.
Microsoft Lists
We have added support for history mode in our Microsoft Lists connector. You can now enable history mode for individual user-created lists from the Schema tab.
For more information, see our History Mode documentation.
OpenAI
We have changed the connector type of our OpenAI connector from Lite to Standard.
The OpenAI connector can now sync Codex Enterprise Analytics API data from a specific ChatGPT workspace. To support this enhancement, we have made the following changes:
- Added two new fields, Codex Enterprise Analytics API key and Workspace ID, to the connection setup form
- Added two new parameters,
api_key_3andworkspace_id, to the Fivetran REST API
Outreach
The Outreach connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Outreach's priority-first syncs fetch the most recent 30 days' worth of data from all tables except the following tables:
COMPLIANCE_REQUESTCUSTOM_FIELDDUTYEMAIL_ADDRESSPHONE_NUMBERPROFILERECIPIENTROLESEQUENCE_TEMPLATETEAM
To learn more, see our priority-first sync documentation.
Pendo
We have added table re-sync support. Previously, we only supported connection-level re-syncs.
Pinpoint
We have fixed an issue that prevented syncing the stage_id column to the INTERVIEW table.
PostgreSQL
We now support syncing the xid8 data type as LONG.
Qualtrics
We have discontinued syncing data into the CORE_CONTACT, CORE_MAILING_LIST, and CORE_SAMPLE tables since Qualtrics is deprecating its legacy Research Core Contacts endpoints. We have replaced these tables with the DIRECTORY_CONTACT, DIRECTORY_MAILING_LIST, and DIRECTORY_SAMPLE, respectively. We now sync data into these corresponding XM Directory tables.
Salesforce
As of June 24, 2026, Fivetran's Salesforce connected app complies with Salesforce's mandatory security updates for connected apps. The app supports Proof Key for Code Exchange (PKCE), Refresh Token Rotation (RTR), Refresh Token Expiry (RTE), and enforces refresh token IP allowlisting.
To ensure uninterrupted syncs, perform the following steps:
- Allowlist Fivetran's IP addresses in your Salesforce instance.
- Disable session IP locking in your Salesforce instance.
These steps are required for all Salesforce connections using Fivetran's connected app. You can check the Salesforce app type on the connection settings page.
Samsara
The Samsara connector now supports priority-first sync for the following tables:
AUX_INPUT_1AUX_INPUT_2AUX_INPUT_3BATTERY_MILLI_VOLTDEFECTDRIVER_HOS_VIOLATIONDRIVER_VEHICLE_ASSIGNMENTDVIRENGINE_STATEFAULT_CODEFORM_SUBMISSION_STREAMFUEL_ENERGY_BY_DRIVER_REPORTFUEL_ENERGY_BY_VEHICLE_REPORTFUEL_PERCENTGPSGPS_DISTANCE_METERGPS_ODOMETERHOS_LOGOBD_ODOMETEROBD_ENGINE_SECONDSAFETY_EVENTSTREAM_DVIRSYNTHETIC_ENGINE_SECONDVEHICLE_IDLING_REPORT
To learn more, see our priority-first sync documentation.
SAP ERP on HANA
We have added new RFC-enabled function /FIVETRAN/POKE that will be used to reset timer in source system and to let data retrieval job run longer when needed.
We have fixed a bug with regex that could cause unhandled runtime expression in source during data validation runs.
SAP SuccessFactors
We've improved sync reliability for the FO_BUSINESS_UNIT table by adding a 1-day replay window to the incremental sync strategy. This ensures that records with delayed timestamps are captured and not missed during incremental syncs.
SharePoint
We have fixed the behavior of the File Pattern field in our SharePoint connector. You no longer need to include the base folder in your regex. Previously, the regex you entered in the File Pattern field applied to the complete file path, including the base folder. New connections created on or after June 29, 2026, must now enter the file pattern relative to the base folder path and not the complete file path.
For connections created between October 17, 2025, and June 29, 2026, we will automatically update the file pattern to match this behavior. For more information, see our setup instructions.
Skilljar
The Skilljar connector no longer supports the Hybrid Deployment model.
Snyk
We have fixed a bug in the JIRA_ISSUE table that prevented syncing Jira issues linked to your Snyk project.
StarRez
We have changed our sync strategy for the ROOMSPACE_CLOSED table. We now incrementally sync the table and also re-import it once a week to capture deletes.
Tableau
We have implemented a daily lookback window to ensure integrity for the PROJECT and DATA_SOURCE tables.
WooCommerce
We have fixed a bug where we didn't sync the following tables:
SUBSCRIPTIONSUBSCRIPTION_LINE_ITEMSUBSCRIPTION_SHIPPING_LINESUBSCRIPTION_TAX_LINE
Workday Financial Management
We now support syncing Organization Reference IDs from Workday. We sync these IDs into the code column of the ORGANIZATION table.
REST API Improvements
Connect Card all_fields parameter
The Connect Card configuration now supports the all_fields parameter. When set to true, Connect Card displays all available setup fields for a connection, including fields that are hidden by default for certain connectors.
Proxy Agent Management API changes
The group_region field in the Create a Proxy Agent endpoint is now optional. Previously, omitting group_region returned a 400 Bad Request error. You can now create a proxy agent without specifying a region. A regionless proxy agent is not tied to any specific region and can serve connections in any region.
Read endpoints require Account Read permission
The following endpoints now require the Account Read permission instead of Account Destination Create:
- List Proxy Agents
- Retrieve Proxy Agent Details
- List Proxy Agent Connections
- List Private Links
- Retrieve Private Link Details
Strict integer validation for API key endpoints
Fivetran REST API endpoints now correctly reject floating-point values for integer fields.
Previously, sending a floating-point number for an integer field would silently truncate it to the nearest integer and succeed. The request now returns a 400 Bad Request error, consistent with the integer type declared for those fields.