August 2026
Connector SDK
fivetran-connector-sdk PyPI package
We have released version 2.11.0 of the fivetran-connector-sdk PyPI package. This release includes the following updates:
- Adds support for errors and warnings.
- Introduces the
--yesflag and updates other non-interactive flags for better clarity and user experience. - Adds resolution precedence for required flags and providing the
configuration.jsonpath. - Updates the new connection creation and debug flows to require
configuration.json. For more information, see configuration resolution order. - Updated
fivetran initand AI plugin setup behavior for existing projects. - Minor enhancements and improvements.
- Updated testers.
fivetran-api-playground PyPI package
We have released version 1.1.9 of the fivetran-api-playground PyPI package. This release upgrades the faker library dependency to 40.36.0.
Insights Tab
We've added the Insights tab to the Connection Details page in the Fivetran dashboard. It highlights the value Fivetran provides for your connection.
You can now view key maintenance details about your connections, including:
- Schema changes handled
- Source deletes captured
- Volume of data processed
- Associated downstream models
- Recent connector improvements
Learn more in our Insights tab documentation.
Managed Data Lake Service
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the data lake, which could cause differences between the source and destination data.
Partner SDK
Partner SDK Tester
We have released version 2.26.0810.001 of the Partner SDK Tester. This release includes the following improvements:
- Added HTML rendering support for errors and warnings messages to improve readability during local testing.
Schema changes
ADP Workforce Now
We have removed the PERSON_DOCUMENT table.
BillingPlatform
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ACTIVITY | |||||
| column | New Column | account_package_id | |||
| column | New Column | contract_id | |||
| column | New Column | contract_rate_id | |||
| column | New Column | cost | |||
| column | New Column | cost_due | |||
| column | New Column | currency_override | |||
| column | New Column | formula | |||
| column | New Column | package_product_id | |||
| column | New Column | product_id | |||
| column | New Column | rating_method_id | |||
| column | New Column | subscription_from_date | |||
| column | New Column | subscription_to_date | |||
| column | New Column | tax_cost | |||
Braze
We have added two new tables, CAMPAIGN_ANALYTICS and CAMPAIGN_ANALYTICS_VARIATION.
Canvas Data 2 by Instructure
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
QUIZ_QUESTION | |||||
| column | New Column | question_data_matching_answer_incorrect_matches | |||
| column | New Column | question_data_neutral_comments | |||
| column | New Column | question_data_regrade_option | |||
| column | New Column | question_data_text_after_answers | |||
Coupa
We have added the following new columns to the QUOTE_REQUEST table:
created_atcurrency_idnegotiated_savingsnegotiated_savings_currency_idoriginal_idplanned_savingsplanned_savings_currency_idpublicstate
We have added a new column, participation, to the QUOTE_SUPPLIER table.
D2L Brightspace
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
DROPBOX_FOLDER | |||||
| table | New Table | DROPBOX_FOLDER | |||
DROPBOX_FOLDER_ACCESS | |||||
| table | New Table | DROPBOX_FOLDER_ACCESS | |||
DROPBOX_FOLDER_ATTACHMENT | |||||
| table | New Table | DROPBOX_FOLDER_ATTACHMENT | |||
DROPBOX_FOLDER_CATEGORY | |||||
| table | New Table | DROPBOX_FOLDER_CATEGORY | |||
DROPBOX_FOLDER_SUBMISSION | |||||
| table | New Table | DROPBOX_FOLDER_SUBMISSION | |||
DROPBOX_FOLDER_SUBMISSION_FILE | |||||
| table | New Table | DROPBOX_FOLDER_SUBMISSION_FILE | |||
ORGANIZATION_ANCESTOR | |||||
| table | New Table | ORGANIZATION_ANCESTOR | |||
ORGANIZATION_CHILD | |||||
| table | New Table | ORGANIZATION_CHILD | |||
ORGANIZATION_COLOUR | |||||
| table | New Table | ORGANIZATION_COLOUR | |||
ORGANIZATION_DESCENDANT | |||||
| table | New Table | ORGANIZATION_DESCENDANT | |||
ORGANIZATION_PARENT | |||||
| table | New Table | ORGANIZATION_PARENT | |||
ORGANIZATION_UNIT | |||||
| table | New Table | ORGANIZATION_UNIT | |||
Fivetran Platform Connector
We've added a new column, connection_details, to the CONNECTION and GROUP tables.
Freshchat
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CONVERSATION_CUSTOM_PROPERTY | |||||
| table | New Table | CONVERSATION_CUSTOM_PROPERTY | |||
GitHub
We've added a new table, ORG_MEMBER.
We have added a new column, role, to the TEAM_MEMBERSHIP table.
Gorgias
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
EVENT | |||||
| table | New Table | EVENT | |||
HiBob
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COMPANY_FIELD | |||||
| column | New column | category_display_name | |||
| column | New column | category_id | |||
EMPLOYEE_VARIABLE_PAYMENT | |||||
| column | New column | can_be_deleted | |||
| column | New column | change | |||
| column | New column | creation_date | |||
| column | New column | end_date | |||
| column | New column | is_required | |||
| column | New column | payout_type | |||
| column | New column | percentage_of_annual_salary | |||
HubSpot
We have added the following new tables to sync data for the Courses object:
COURSECOURSE_COMPANYCOURSE_CONTACTCOURSE_DEALCOURSE_ENGAGEMENTCOURSE_PIPELINECOURSE_PIPELINE_STAGECOURSE_PROJECTCOURSE_PROPERTY_HISTORYCOURSE_TICKET
We are gradually rolling out this change to all connections.
LinkedIn Ad Analytics
We've added a new table, VIDEO. The table contains video media assets referenced by posts, including the download URL, its expiration time, duration, aspect ratio, thumbnail, owner, and processing status.
OpenAI
We have added the following new tables to store organization admin and usage data:
CODE_INTERPRETER_SESSIONFILE_SEARCH_CALLIMAGEMODERATIONPROJECT_API_KEYVECTOR_STORE_USAGEWEB_SEARCH_CALL
Ordway
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
USAGE | |||||
| column | New Column | amount | |||
PagerDuty
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INCIDENT_NOTE | |||||
| table | New Table | INCIDENT_NOTE | |||
Pinterest Ads
We've added a new column, optimization_goal_metadata, to the AD_GROUP_HISTORY table.
We've added a new table, ADVERTISER_TARGETING_GEO_REPORT. The table contains account-level impressions, clicks, spend, eCPM, and engagement metrics broken down by country, region, location, and ZIP-code geo targeting.
Pylon Support Platform
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ISSUE | |||||
| column | New Column | author_unverified | |||
| column | New Column | body_html | |||
| column | New Column | business_hours_time_in_status_seconds | |||
| column | New Column | child_issues | |||
| column | New Column | number_of_touches | |||
| column | New Column | parent_issue_group_id | |||
| column | New Column | slack_workspace_id | |||
| column | New Column | snoozed_until_time | |||
| column | New Column | time_in_status_seconds | |||
| column | New Column | updated_at | |||
ISSUE_ACTIVE_TIME_BY_USER | |||||
| table | New Table | ISSUE_ACTIVE_TIME_BY_USER | |||
ISSUE_TEAM_SLA | |||||
| table | New Table | ISSUE_TEAM_SLA | |||
Rocketlane
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
FIELD_OPTION | |||||
| table | New Table | FIELD_OPTION | |||
Salesforce Commerce Cloud
We have added the following new tables:
PRODUCT_IMAGE_GROUPPRODUCT_IMAGE_GROUP_IMAGEPRODUCT_IMAGE_GROUP_VARIATION_ATTRIBUTEPRODUCT_IMAGE_GROUP_VARIATION_ATTRIBUTE_VALUE
We have added the following new locale-specific columns to the PRODUCT table:
long_description_{locale}_markuplong_description_{locale}_sourceshort_description_{locale}_markupshort_description_{locale}_source
SAP Concur
We have added a new column, _fivetran_deleted, to all tables in your connection schema. This change applies only when you trigger a table re-sync. During the re-sync, Fivetran uses the _fivetran_deleted column to soft-delete existing records in parent and child tables. It does not affect how we handle deletes during regular incremental syncs. For more information, see our documentation.
We have added a new column, report_id, to the ITEMIZATION table.
We have added the following new tables:
ATTENDEE_V4ATTENDEE_TYPE_V4DUPLICATE_SEARCH_FIELD
For information about the OAuth app configuration required to sync these tables, see our setup instructions. If you add the required scopes to your OAuth app after setting up the connection, re-authenticate the connection in Fivetran to obtain a new token that includes the updated scopes.
Snapchat Ads
We've added two new columns, objective_v2_type and promotion_type, to the CAMPAIGN_HISTORY table.
Stripe
We have added a new column, latest_charge_id, to the PAYMENT_INTENT table.
We have added two new tables, CHECKOUT_SESSION_CUSTOM_FIELD and CHECKOUT_SESSION_CUSTOM_FIELD_DROPDOWN_OPTION, to store data from the custom fields of the Checkout Session object.
We have added the following new tables:
BILLING_METER_EVENT_SUMMARYCREDIT_GRANTCREDIT_GRANT_APPLICABILITY_CONFIG_SCOPE_PRICES
We have added a new column, connected_account_id, to the CUSTOMER and INVOICE tables to support syncing connected accounts data to these tables.
We are gradually rolling out these changes to all existing connections.
Tableau
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
COLLECTION | |||||
| table | New Table | COLLECTION | |||
COLLECTION_ITEM | |||||
| table | New Table | COLLECTION_ITEM | |||
COLLECTION_PERMISSION | |||||
| table | New Table | COLLECTION_PERMISSION | |||
COLLECTION_PERMISSION_GRANTEE_CAPABILITIES_CAPABILITY | |||||
| table | New Table | COLLECTION_PERMISSION_GRANTEE_CAPABILITIES_CAPABILITY | |||
COLLECTION_PERMISSION_GRANTEE_CAPABILITY | |||||
| table | New Table | COLLECTION_PERMISSION_GRANTEE_CAPABILITY | |||
Visma
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INVENTORY_SUMMARY | |||||
| table | New Table | INVENTORY_SUMMARY | |||
SUPPLIER_LOCATION | |||||
| table | New Table | SUPPLIER_LOCATION | |||
SUPPLIER_LOCATION_PAYMENT_METHOD_DETAIL | |||||
| table | New Table | SUPPLIER_LOCATION_PAYMENT_METHOD_DETAIL | |||
Walmart Marketplace
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
INBOUND_SHIPMENT_ITEM | |||||
| column | Primary Key Change | inbound_order_id 🔑 | inbound_order_id | No longer a primary key. | |
| column | Primary Key Change | sku | sku 🔑 | Added to primary key. | |
SHIPMENT | |||||
| column | Primary Key Change | inbound_order_id 🔑 | inbound_order_id | No longer a primary key. | |
Workday Financial Management
We have added two new tables, FISCAL_PERIOD and FISCAL_YEAR.
We are gradually rolling out this change to all existing connections.
Xero
We've added the following new tables:
BUDGETBUDGET_LINEBUDGET_BALANCE
To sync data from these tables, follow the steps below based on your connection type:
Web App :
- In the Fivetran dashboard, go to Edit Connection.
- Re-authorize the connection.
- Click Save & Test.
Custom connection :
- In your custom connection app, add the
accounting.budgets.readscope. - Click Save and connect.
- Re-authorize the connection through the app.
We are gradually rolling out this change to all existing connections.
Improvements
Adobe Workfront
You can now specify the Adobe Workfront environment whose data you want to sync when setting up the connection. To support this enhancement, we have added a new field, Environment, to the connection setup form. For more information, see our setup instructions.
Amazon Attribution
You can now select the Amazon Advertising profiles whose data you want to sync. To support this change, we have added an optional field, Profiles to sync, to the connection setup form. For more information, see our setup instructions and REST API documentation.
Amazon DocumentDB
We now support reading change streams from secondary instances for Amazon DocumentDB versions 5.0 and above. We no longer require a connection to the primary instance to perform incremental updates on these versions. Versions below 5.0 only support change streams on the primary instance. For more information, see our Amazon DocumentDB Setup Guide.
If you have an existing connection to an Amazon DocumentDB cluster running version 5.0 or above, and you have confirmed that Fivetran user can access change streams on the secondary instances, you can edit the connection details to connect to the secondary instances and sync from them.
Amazon Selling Partner
We have changed the data type of the following columns in the ITEM_DIMENSION table from BIGINT to DOUBLE PRECISION:
item_height_valueitem_length_valueitem_weight_valueitem_width_valuepackage_height_valuepackage_length_valuepackage_weight_valuepackage_width_value
We have made this change to preserve decimal values in dimension measurements instead of truncating them. We are gradually rolling out this change to all existing connections.
Apple App Store
We now support the Hybrid Deployment model for the Apple App Store connector. Learn more in the Apple App Store setup guide.
Azure Blob Storage
We have added a new authentication method, Microsoft Entra ID - Client credentials grant using client certificate. This authentication method enables you to securely connect using a Microsoft Entra ID service principal and a client certificate.
To support this feature, we have added the following fields to the connection setup form:
- Container name
- Storage account name
- Tenant ID
- Client ID
- Client certificate
- Private key for client certificate
For more information, see our setup instructions.
BigQuery destination
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the destination, which could cause differences between the source and destination data.
We now preserve NaN and Infinity values in non-primary-key FLOAT and DOUBLE columns instead of syncing them as NULL values. Primary key columns still require valid, non-NaN values. We have made this change for all new connections set up on or after August 18, 2026.
Databricks destination
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the destination, which could cause differences between the source and destination data.
We have made the following changes for all new connections set up on or after August 18, 2026:
- We now preserve NaN and Infinity values in non-primary-key FLOAT and DOUBLE columns instead of syncing them as NULL values. Primary key columns still require valid, non-NaN values.
- We now preserve the sign of negative zero (
-0.0) instead of normalizing it to0.0.
dbt Cloud Orchestration
We've expanded the list of supported regions in the dbt Cloud orchestration setup form and added a new Service Provider selector.
Previously, only a limited set of regions were available. You can now choose from all current dbt Cloud regions, including cell-based regions that require an account prefix in the access URL.
To update your dbt Cloud orchestration connection to use a different region:
- 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 Cloud project.
- Click Edit connection settings.
- Select your Service Provider and Region.
- Click Save & Test.
Default Sync Mode
You can set a connection-level Sync mode default for new tables that support the selected sync mode.
Existing tables with Soft delete mode, Live mode, or History mode selected keep that table-level selection when you change the connection default. To make an existing table use the connection default, open the table’s Sync mode menu in the Schema tab and select Default. The table then uses the connection’s Sync mode default. If you later change the connection default, tables set to Default follow the new selection.
Selecting Soft delete mode, Live mode, or History mode instead creates or keeps a table-level override. A table shows only the sync modes it supports. If Default is not available, that table has a restricted set of modes and cannot inherit the connection default.
For more information, see Sync modes.
Elasticsearch
We now support Elasticsearch version 9.x. Learn more in our Elasticsearch connector documentation.
We have added a new feature, support for files linked in the email body. You can now define a regex pattern to sync the attachments associated with your email. To support this feature, we have made the following changes to the connection setup form:
- Added a new option , File source, that allows you to choose between Attachment and URL in email body.
- Added a new field, URL link pattern, that allows you to sync files linked in the email body.
For more information, see our setup instructions
We are gradually rolling out this change to all existing connections.
Facebook Pages
You can now authenticate using a System User Token as an alternative to OAuth. This authentication method is recommended for organizations that don't want to ask their end-users to grant user access, such as digital marketing agencies or Powered by Fivetran users.
For more information about setting up this authentication method, including permissions and access level requirements, see our Facebook Pages setup guide.
GitHub
We've added a new Include commits only from default branch option to the connection setup form. When enabled, we sync only the commits reachable from each repository's default branch. This option significantly reduces the sync duration and API usage for repositories with many branches.
Enabling this option excludes the BRANCH_COMMIT_RELATION and COMMIT_PULL_REQUEST tables from your sync.
Healthie
We have changed our sync strategy for the FORM_ANSWER_GROUP table. We now incrementally sync this table and use a 7-day lookback window to capture delayed updates.
JSON Double Quotes
Effective August 14, 2026, we have improved Fivetran replication for JSON scalar values for all connections. New connections created on or after August 14, 2026, will no longer persist these values with quotes (unless they are strings) in destinations, improving data consistency. Existing connections continue to use their current behavior.
Loop
We now support syncing return data in presentment currency, allowing return amounts in the RETURN_OPEN_CLOSED_EXPIRED table to reflect the shopper’s local currency.
Marketo
Our Marketo connector now supports an additional sync of activity data from the previous three days during each incremental sync, to help capture late-arriving activity records. To support this enhancement, we have made the following changes:
- Added a new toggle, Sync Late Arriving Activities, to the connection setup form
- Added a new parameter,
trailingSyncEnabled, to the Fivetran REST API
For more information, see our Marketo documentation.
Microsoft Advertising
We updated how we process the view_through_revenue column. Microsoft Advertising returns these values with a comma as a thousands separator (for example, 1,013.99). We now remove the separator and store the values as plain numbers (for example, 1013.99) for consistency with the connector's other metric columns.
This change applies to data synced going forward. If you rely on the previous formatting, update any downstream logic accordingly.
MongoDB
We no longer support the oplog incremental update method. If your connection was using the oplog incremental update method, syncs will no longer work.
MySQL
If a DATE or DATETIME column contains a value that isn't a valid date or datetime (for example, a zero date like 0000-00-00), we now preserve the original value by promoting the column to STRING instead of syncing it as NULL.
If you have type locking enabled on a connection, this promotion doesn't happen — invalid values are synced as NULL instead, and the column keeps its original type.
We now preserve the zero-sentinel value 0000-00-00 00:00:00 in MySQL and MariaDB TIMESTAMP columns by changing the destination column type to STRING. Previously, we synced this value as NULL.
If you enable type locking for your connection, we keep the existing column type and continue to sync the zero-sentinel value as NULL.
This change affects connectors created on or after August 13, 2026.
MySQL destination
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the destination, which could cause differences between the source and destination data.
NetSuite SuiteAnalytics
We have upgraded the JDBC driver for the NetSuite SuiteAnalytics connector from version 8.10.184.0 to 8.10.190.0.
Odoo Synconics
We have renamed our Odoo connector, which uses the Synconics REST API module to sync Odoo data, to Odoo Synconics.
Oracle
We support Active Data Guard as the source for the Binary Log Reader incremental sync method in Private Preview.
We support physical standby databases in read-only mode only. However, we still need to connect to the primary database to manage directory objects. For more information about the required settings, see the Binary Log Reader setup instructions.
PagerDuty
We have changed the sync strategy for the following tables and their child tables. We now incrementally sync these tables instead of re-importing them during every sync:
AUDIT_RECORDEVENT_ORCHESTRATIONPAUSED_INCIDENT_REPORTING_ALERTSCHEDULESLACK_DEDICATED_CHANNELTEMPLATE
We have changed the re-import strategy for the following tables and their child tables. We now re-import them once a day to capture updates and deletes. Previously, we re-imported these tables during every sync.
ADDONBUSINESS_SERVICEEXTENSIONEXTENSION_SCHEMAINCIDENT_WORKFLOWLICENSERULESETTAGSVENDOR
Pendo
We now support history mode for the following tables:
ACCOUNT_APPLICATION_HISTORYACCOUNT_HISTORYAPPLICATION_HISTORYFEATURE_ELEMENT_PATH_RULE_HISTORYFEATURE_HISTORYGUIDE_HISTORYGUIDE_STEP_HISTORYPAGE_HISTORYPAGE_RULE_HISTORYSTEP_HISTORYSTEP_POLL_HISTORYSTEP_THUMBNAIL_URL_HISTORYTRACK_TYPE_HISTORYTRACK_TYPE_RULE_HISTORYVISITOR_ACCOUNT_HISTORYVISITOR_APPLICATION_HISTORYVISITOR_HISTORY
Salesforce
We now sync the ConversionRate field in the CURRENCY_TYPE table as BIGDECIMAL instead of DOUBLE. This change corrects small floating-point rounding differences in formula fields that depend on the ConversionRate field. To apply this change, you must drop and resync the CURRENCY_TYPE table.
We have upgraded our Salesforce and Salesforce Sandbox connectors from version 65.0 to 66.0 of the Salesforce REST API. For more information, see Salesforce documentation.
SAP Business ByDesign
We have fixed an issue where columns with address data in the BUSINESS_PARTNER_ADDRESS table were synced as NULL even when valid data for these columns was available in SAP Business ByDesign. By default, we will update the data for this table in a subsequent sync, which will count towards free MAR.
SFTP
We now support authentication using a keypair while configuring your connection using Hybrid Deployment. Previously, the Login with keypair? option was available only for connections configured using the SaaS Deployment model.
We are gradually rolling out this change to all existing connections.
Shopify
We have improved data integrity for the BALANCE_TRANSACTION table. We now track records that are missing a payout ID and automatically re-sync them after Shopify finalizes the associated payout. This ensures that we backfill the associated_payout_id column when it becomes available. This improvement applies only to incremental data. To backfill the associated_payout_id column for historical records where it is missing, manually re-sync the BALANCE_TRANSACTION table.
Sigma Computing
We have added a new drop-down menu, Environment, to the connection setup form. You can now select the Sigma Computing environment from which you want to sync your data.
For more information, see our Sigma Computing setup guide.
Snowflake destination
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the destination, which could cause differences between the source and destination data.
We have made the following changes for all new connections set up on or after August 18, 2026:
- We now preserve NaN and Infinity values in non-primary-key FLOAT and DOUBLE columns instead of syncing them as NULL values. Primary key columns still require valid, non-NaN values.
- We now preserve the sign of negative zero (
-0.0) instead of normalizing it to0.0.
SQL Server
Effective August 5, 2026, we have improved Fivetran Teleport Sync change detection for nullable columns in SQL Server connections. New connections created on or after August 5, 2026, distinguish NULL values from non-NULL values when calculating row hashes, improving data consistency in your destination. Existing connections continue to use their current behavior.
Effective August 7, 2026, we have improved change tracking (CT) accuracy for computed columns in SQL Server connections. New connections created on or after August 7, 2026, exclude non-persisted computed columns from CT syncs if they use nondeterministic expressions that return DATETIME or INTEGER values, such as GETDATE().
Previously, CT syncs evaluated these expressions when processing historical changes. As a result, the synced value could differ from the value at the time of the change, causing incorrect data in your destination. Existing connections continue to use their current behavior.
To resume syncing an excluded computed column, update it to use a deterministic expression.
Effective August 20, 2026, we've improved change tracking (CT) history mode syncs for SQL Server connections. New connections created on or after August 20, 2026, handle temporarily unavailable transaction metadata without omitting affected rows.
Previously, delays in the availability of SQL Server transaction metadata could cause some rows to be omitted during historical data processing. Existing connections continue to use their current behavior.
SQL Server destination
All new connections set up on or after August 5, 2026 preserve null byte characters in string values. Previously, we removed null byte characters before writing string values to the destination, which could cause differences between the source and destination data.
Stripe
We have expanded the DISCOUNT table to store discounts associated with subscription items. We are gradually rolling out this change to all existing connections.
Transformations for dbt Core
We now capture audit log events when dbt Compute personal access tokens are created or revoked. These events are available in the Log Service API as dbt_compute_token_created and dbt_compute_token_revoked, providing visibility into token lifecycle management for security and compliance purposes.
Workday Adaptive Planning
We have added a new configuration option, Select all, to the Dimensions field in the connection setup form to allow you to select or deselect all available dimensions at once while configuring custom reports. For more information, see our setup instructions.
Zoho CRM
We can now sync data from Zoho accounts hosted in the Canada region. To support this enhancement, we have added a Canada option to the Data Center drop-down menu in the connection setup form. For more information, see our setup instructions.
REST API Improvements
Connection Schema API
The Connection Schema response now includes a new read-only parent_table field for tables that are grouped under a parent (core) table. The field contains the name of the parent table and only appears in the response for child tables. This allows API consumers, such as Terraform, to accurately reconcile schema configuration state.
Retrieve Move Connection Job Status REST API (Beta)
You can now check the status of asynchronous connection move operations using the Retrieve Move Connection Job Status (Beta) REST API endpoint. This endpoint allows you to monitor the progress of move jobs initiated with the CONTINUE_WITH_DATA sync behavior.
Row filtering in connection schema config
The Modify connection schema config endpoint now supports row filtering for individual tables.
See the full list of changes below:
- Each table in a schema update request now accepts a
row_filterfield of typeRowFilterUpdateRequest. Setting this field creates or replaces the row filter for that table; sendingnulldeletes the existing row filter; omitting the field leaves the existing row filter unchanged. - A row filter consists of a
name(required), adescription(required), and between 1 and 10column_clauses. Each clause specifies acolumn(max 500 characters), acolumn_type, anoperator, and a list ofvalues(each value max 1,000 characters). All clauses are combined with a logical AND, so only rows satisfying every clause are synced to your destination. - The Retrieve connection schema config response now includes a
row_filtering_supportedboolean at the top level. The field istruewhen the connector type supports row filtering. The field isfalsewhen the connector does not support row filtering. The field is omitted when row filtering information is not available. - The
row_filterfor each table is included in both GET and PATCH responses whenrow_filtering_supportedistrue. The field is omitted from a table's response when no filter is configured. - Creating or removing a row filter triggers a historical resync for the affected table.
Supported operators depend on the column type:
| Operator | Compatible types | Values required |
|---|---|---|
EQUALS, NOT_EQUALS | LONG, FLOAT, DOUBLE, BIGDECIMAL, DATE, DATETIME, STRING, BOOLEAN | Exactly 1 |
LESS, LESS_OR_EQUALS, GREATER, GREATER_OR_EQUALS | LONG, FLOAT, DOUBLE, BIGDECIMAL, DATE, DATETIME, STRING | Exactly 1 |
STARTS_WITH, CONTAINS | STRING | Exactly 1 |
IN | LONG, FLOAT, DOUBLE, BIGDECIMAL, STRING | At least 1 |
IS_NULL, IS_NOT_NULL | All types | 0 |
Value format requirements by column type:
| Column type | Required format |
|---|---|
DATETIME | UTC timestamp ending in Z, e.g. 2024-01-01T00:00:00Z |
DATE | yyyy-MM-dd, e.g. 2024-01-01 |
BOOLEAN | Lowercase "true" or "false" exactly |
BIGDECIMAL | Each value must be at most 50 characters |
STRING + IN | Combined length of all values in the clause must not exceed 10,000 characters |