March 2024link
Fivetran Azure Central India Serverslink
We have added new servers in the Azure Central India (Pune) region.
If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in India, your data does not leave India during processing.
We now support Azure Private Link connections to sources and destinations in the centralindia (Pune) region.
For more information, see our data residency documentation.
Fivetran Azure Japan Serverslink
We have added new servers in the Azure Japan East (Tokyo) region.
If you're on a Business Critical plan, you can now select this region in your destination setup form. Connectors configured in a destination run in their designated cloud and region, meaning that your data doesn't leave our region-specific servers during processing. For example, if you configure your connectors to use our servers in Japan, your data does not leave Japan during processing.
We now support Azure Private Link connections to sources and destinations in the japaneast (Tokyo) region.
For more information, see our data residency documentation.
Lite Connectorslink
Lite connectors are now available for the following sources:
- Adobe Workfront
- Aumni
- Brightcove
- CallRail
- Culture Amp
- Kisi
- Mambu
- Megaphone
- REVIEWS.io
- Rocketlane
- SparkPost
- StarRez
- Trelica
- Udemy Business
- VWO
- Webconnex
- Younium
Organization Managementlink
Organization Management is now generally available.
Setup Testslink
Setup tests after editing connection detailslink
We made the following changes to the setup tests that run after you edit your connector or destination's connection details:
- We no longer remove or replace reconnection tasks created after a sync failure.
- If setup tests fail, we do not add a new reconnection task.
Transformations for dbt Corelink
dbt Core version 1.7.9 supportlink
We now support dbt Core version 1.7.9. You can use this version to run your projects.
NOTE: For dbt Core versions later than 1.1.5, we don't support MySQL destinations. For dbt Core versions later than 1.4.9, we don't support SQL Server and Azure Synapse destinations. These destinations are not currently supported by custom dbt Core adapters.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Required data error handlinglink
We now handle the following errors in Quickstart data models:
Required fields not available error:
Source data missing error:
We have added a warning for cases when removing columns from the schema causes the transformation to fail.
We have added an option to check the list of tables and columns required for the transformation to work successfully. To see the required data, click View required fields on the transformation creation page.
Retries for transformations and connections managed by Transformation Schedulinglink
Transformations and connections managed by Transformation Scheduling may be automatically retried if they fail. Since connection syncs and transformation jobs depend on each other, the rules and conditions of their retries are complex and may change in the future. We may decide to not restart connections or transformation jobs if they have failed in a certain way or if their restart attempts would cause significant delays to other scheduled jobs. We may restart both connection syncs and transformation jobs up to 4 times within their scheduled sync or run interval. For connector syncs, we follow the rules described in our Sync Overview documentation whenever possible. We restart transformation jobs 5 minutes after their failure. This feature will be gradually rolled out over the next few weeks.
Support of multiple targets in dbt for Core* transformationslink
In addition to being able to change the default target, you can now define multiple additional targets when setting up a dbt for Core* transformation.
Deleting a custom target deletes the models associated with it.
When you set up a transformation, you assign one of the targets you defined for your dbt project to be used with the model. You can set up several transformations using the same model but different targets.
Transformations that use additional targets have a pill displaying the name of the additional target used.
Support of SQL Server and Azure Synapse for dbt Core version 1.7.3 and 1.7.9link
We now support SQL Server and Azure Synapse destinations for dbt Core* versions 1.7.3 and 1.7.9. You can use these versions to run your projects targeting those destinations.
NOTE: For dbt Core versions later than 1.1.5, we don't support MySQL destinations. For dbt Core versions later than 1.4.9 but older than 1.7.3, we don't support SQL Server and Azure Synapse destinations. These destinations are not currently supported by custom dbt Core adapters.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Target management for transformations for dbt Corelink
You can now edit targets when using dbt for Core* transformations. This allows you to change certain properties when using transformations without changing the associated destination's settings.
The following Snowflake destination settings are now also managed via targets:
- Host
- Port
- Database
- User
- Role
- Auth
We removed them from the dbt Transformations setup form.
To manage targets from the dbt Transformations setup form, set the Show Advanced Options toggle to ON.
When adding or editing a target, you can add and define additional parameters, and override and remove the existing ones. Refer to you destination's documentation to check which parameters stored as key-value pairs it supports by clicking the link to the specific destination's documentation in the target details pane.
To override the destination's authentication settings, set the Custom destination authentication settings toggle to ON.
To revert the destination's settings use the Restore default values button.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
New connectorslink
Adyenlink
Adyen is a payment, revenue, and financial management platform.
Read our Adyen connector documentation.
Azure DevOpslink
Azure DevOps is a suite of tools that help teams manage their entire software development lifecycle.
Read our Azure DevOps connector documentation.
Schema changeslink
Adyenlink
We have changed the data type of the exchangeRate
column in the PAYMENTS_ACCOUNTING_REPORT
table from INTEGER to DOUBLE.
Aircalllink
We have removed the foreign key relationship of the id
column to the NUMBERS
table, in the CONTACT_NUMBER
table.
Appfigureslink
We have removed the REPLY
table.
Attentivelink
We have changed the primary key for the SMS_INBOUND
table. The new primary key is the fivetran-id
column. Previously, we used a composite primary key which was a combination of the subscriber_external_id
and fivetran-id
columns.
Auth0link
We have changed the primary key for the USER_IDENTITIES
table. We now use the fivetran-id
column as the primary key for this table. Previously, we used a combination of the index
and user_id
columns as the composite primary key.
Brazelink
We have added a new column, message_extras
, to the following tables:
CONTENT_CARD_EVENT
EMAIL_EVENT
PUSH_NOTIFICATION_EVENT
SMS_EVENT
WEBHOOK_EVENT
Chameleonlink
We have added the following new columns to the MICRO_SURVEY_RESPONSE
table:
comment_step_dropdown_item
comment_step_other_text
other_text
Checkrlink
We have renamed the ruleset_id
column of the ASSESSMENT
table to id
.
We have changed the primary key of the ASSESSMENT
table. The new primary key is the _fivetran_id
column. Previously, the primary key was a combination of the ruleset_id
and report_id
columns.
We have changed the primary key of the REPORT_ADDRESS
table. The new primary key is the _fivetran_id
column. Previously, the primary key was a combination of the _fivetran_id
and report_id
columns.
We have changed the composite primary key of the ASSESSMENT_RESULT
table. The new composite primary key is a combination of the index
and _fivetran_id
columns. Previously, we used the index
, report_id
, and ruleset_id
columns as the composite primary key.
We have changed the composite primary key of the ASSESSMENT_RESULT_ASSESSED_OBJECT
table. The new composite primary key is a combination of the object_id
, assessment_result_index
, and _fivetran_id
columns. Previously, we used the index
, assessment_result_index
, report_id
, and ruleset_id
columns as the composite primary key.
ClickUplink
We have changed the primary key of the GOAL_GROUP_MEMBER_IN_GOAL_FOLDER
table. We now use the index
column as the primary key. Previously, we used the id
column as the primary key. Be sure to update your queries.
Employment Herolink
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BANK_ACCOUNT | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMERGENCY_CONTACT | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMPLOYEE_CERTIFICATION | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer a part of the primary key because id alone can serve as a primary key. | |
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
EMPLOYEE_HISTORY | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
LEAVE_REQUEST | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
PAY_DETAIL | |||||
column | Primary Key Change | employee_id 🔑 | employee_id | No longer a part of the primary key because id alone can serve as a primary key. | |
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. | |
PAYSLIP | |||||
column | Primary Key Change | organisation_id 🔑 | organisation_id | No longer a part of the primary key because id alone can serve as a primary key. |
Facebook Pageslink
We have added the following new tables to support Facebook Reels:
LIFETIME_REEL_METRICS_BY_TYPE
LIFETIME_REEL_METRICS_TOTAL
REEL_HISTORY
UNIQUE_LIFETIME_REEL_METRICS_TOTAL
You can view the full list of metrics for reel insights in the Facebook's documentation.
We are gradually rolling out the change to all our Facebook Pages connectors.
Firebaselink
We have updated subcollection names to begin with a forward slash ("/").
Fivetran Platform Connectorlink
We have removed the free_type
column from the INCREMENTAL_MAR
table's deletion key. Previously, the deletion key included this column, which caused a data discrepancy issue.
Frontlink
We have changed the primary key in the CONTACT_NOTE
table from the index
column to a combination of the contact_id
and index
columns.
Greenhouselink
We have added the following new columns to the tables below:
responsible
column to theHIRING_TEAM
tableopened_at
column to theJOB
table
Be sure to re-sync the JOB
table to backfill the historical data for these tables or contact Fivetran's support team to re-sync it for you.
HappyFoxlink
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
SLA | |||||
column | Deprecated Column | index 🔑 | Column removed. | ||
column | Primary Key Change | report_id 🔑 | report_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. |
Instagram Businesslink
- We have added a new field,
story_swipe_forward
, to theMEDIA_INSIGHTS
table. The existingnavigation
field in theMEDIA_INSIGHTS
table is broken down bystory_navigation_action_type
to the following navigation actions viewers take upon viewing the media:story_exits
story_taps_back
story_taps_forward
story_swipe_forward
Jotformlink
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FORM_HISTORY | |||||
table | Deprecated Table | FORM_HISTORY | Removed the table from the schema because we now capture deletes for the FORM table. |
Klaviyolink
We have added a new column, joined_group_at
, to the LIST_PERSON
table. The joined_group_at
column stores the date when a person is added to the list.
Kustomerlink
We have added a new column, _fivetran_deleted
, to the QUEUE
table to capture deletes. The _fivetran_deleted
column replaces the deleted
column in the QUEUE
table.
We will deprecate the deleted
and deleted_at
columns from the QUEUE
table. Be sure to update your queries.
Linearlink
We have removed the ISSUE_HISTORY
table.
We have added the following new tables:
ISSUE_HISTORY_1
ISSUE_HISTORY_2
ISSUE_HISTORY_3
ISSUE_HISTORY_4
LinkedIn Ad Analyticslink
We have added the following new tables:
LEAD_FORM_RESPONSE
LEAD_FORM_RESPONSE_ANSWER
LEAD_FORM_RESPONSE_CONSENT
LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS
NOTE: You need to reauthorize your existing LinkedIn Ad Analytics connectors to access this data.
Muxlink
You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ASSET_INPUT_INFO | |||||
column | Primary Key Change | asset_id 🔑 | asset_id | No longer primary key. | |
column | Deprecated Column | index 🔑 | Column removed. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
ASSET_INPUT_INFO_TRACK | |||||
column | Deprecated Column | asset_input_info_asset_id 🔑 | Column removed. | ||
column | Deprecated Column | asset_input_info_index 🔑 | Column removed. | ||
column | Primary Key Change | _fivetran_id 🔑 | New primary key. |
PartnerStack Vendorlink
We have changed the primary key in the FORM_TEMPLATE_FIELD
table. The new composite key is a combination of the index
and form_template_id
columns.
Salesforce Commerce Cloudlink
We have changed the primary key in the ORDER_SHIPMENT_ADDRESS
table from the shipment_id
column to a combination of the order_id
and shipment_id
columns.
TikTok Adslink
We have added a new column, tiktok_item_id
, to the AD_HISTORY
table. You can find details about the tiktok_item_id
field in the TikTok ads documentation.
Workday HCMlink
We have added the following new tables:
JOB_REQUISITION
JOB_REQUISITION_ADDITIONAL_LOCATION
JOB_REQUISITION_ADDITIONAL_JOB_PROFILE
JOB_REQUISITION_ADDITIONAL_JOB_POSTING_LOCATION
JOB_REQUISITION_ALLOWANCE_PLAN
JOB_REQUISITION_BONUS_PLAN
JOB_REQUISITION_CALCULATED_PLAN
JOB_REQUISITION_CERTIFICATION
JOB_REQUISITION_CERTIFICATION_SPECIALTY
JOB_REQUISITION_CERTIFICATION_SUBSPECIALTY
JOB_REQUISITION_COMMISSION_PLAN
JOB_REQUISITION_COMPENSATION
JOB_REQUISITION_COMPETENCY
JOB_REQUISITION_CUSTOM_ORGANIZATION
JOB_REQUISITION_DEFAULT_ASSESSMENT_TEST
JOB_REQUISITION_DOCUMENT_FIELD
JOB_REQUISITION_EDUCATION
JOB_REQUISITION_LANGUAGE
JOB_REQUISITION_LANGUAGE_ABILITY
JOB_REQUISITION_MERIT_PLAN
JOB_REQUISITION_ORGANIZATION
JOB_REQUISITION_PAY_PLAN
JOB_REQUISITION_PERIOD_SALARY_PLAN
JOB_REQUISITION_POSITION
JOB_REQUISITION_RESPONSIBILITY
JOB_REQUISITION_ROLE_ASSIGNMENT
JOB_REQUISITION_ROLE_ASSIGNEE
JOB_REQUISITION_SKILL
JOB_REQUISITION_STOCK_PLAN
JOB_REQUISITION_TRAINING
JOB_REQUISITION_WORK_EXPERIENCE
JOB_REQUISITION_UNIT_ALLOWANCE_PLAN
JOB_REQUISITION_UNIT_SALARY_PLAN
LINKED_JOB_REQUISITION
To sync these tables, you must enable the security domains necessary for the Recruiting module. We are gradually rolling out these changes to all the existing connectors.
Improvementslink
Adobe Analyticslink
We now support the OAuth Server-to-Server credentials authentication method for Adobe Analytics connectors.
Users are recommended to migrate to OAuth Server-to-Server credentials because Adobe is deprecating the Service Account (JWT) credentials authentication method on January 1, 2025.
Adobe Commercelink
Our Adobe Commerce connector now supports table-level re-syncs.
ADP Workforce Nowlink
We have added the following tables to your schema:
WORKER_LEAVE
WORKER_TIME_CARD
WORKER_TIME_CARD_DAILY_TOTAL
WORKER_TIME_CARD_HOME_LABOR_ALLOCATION
WORKER_TIME_CARD_PERIOD_TOTAL
We have started to sync Worker TimeCard
and Worker Leave
endpoints. To make sure all your data is synced, see the prerequisites for the ADP Workforce Now connector.
Alchemerlink
We have changed the connector type of our Alchemer connector from Lite to Standard. As part of the upgrade, we have added the following new tables:
SSO
SSO_ATTRIBUTE
SURVEY_CAMPAIGN_EMAIL_MESSAGE
Alchemer connectors created on or after March 14, 2024, use a new schema. For more information about the new schema, see our Alchemer documentation. We are gradually rolling out these changes to all existing connectors.
Amazon Selling Partnerlink
Our Amazon Selling Partner connector is now generally available. Read our Amazon Selling Partner documentation.
Amplitudelink
Fivetran now supports extracting event data from Amplitude using Cloud Storage Export. We are gradually rolling out this feature to all connectors.
For more information, see our Amplitude setup guide.
Assembledlink
We have changed the connector type of our Assembled connector from Lite to Standard. As part of this upgrade, we have made the following schema changes:
- Added the following new tables:
DAILY_REPORT_METRIC
EVENT_CHANGE
FORECAST
HOURLY_REPORT_METRIC
TIME_OFF_REQUEST
TIME_OFF_UPDATE
- Added two new columns,
productivity
andstaffable
, to thePEOPLE
table
We are gradually rolling out this upgrade to all existing connectors.
BigCommercelink
Our BigCommerce connector is now generally available.
Read our BigCommerce documentation.
BigQuerylink
We are rolling out the optimized sync feature for the following types for BigQuery tables:
- regular tables
- partitioned tables that do not require a partition filter.
When the feature rolls out to your connector, we will automatically re-sync all your selected tables. This re-sync will not count towards MAR. To take advantage of the optimization, make sure to grant the the necessary service account permissions.
CircleCIlink
We have renamed the API key field to Personal API token in the CircleCI connector setup form and API configuration parameters.
Closelink
We have changed the sync strategy for the CONTACT
and LEAD
tables and their child tables. We no longer capture deletes for these tables.
commercetoolslink
We now support syncing data from text columns in all locales in our commercetools connector. Previously, we supported only de-DE
and en-US
for syncing data from text columns.
Customer.iolink
We now re-import the MESSAGE
table once a week to capture updates and deletes.
Duoplanelink
We have renamed the API Secret
field to API password
in the connector setup form.
Emaillink
While syncing your email attachments, we now store the date and time when the email was sent in the _modified
column. Previously, this column contained the date and time when the connector uploaded the attachments to our internal S3 bucket.
NOTE: This change is not applicable to the syncs already completed before March 16, 2024.
Facebook Adslink
We have upgraded our Facebook Ads connector to version 18.0 of the Facebook API. For more information, see Facebook's summary of Graph API v18.0 and Marketing API v18.0.
We have deprecated the following insight metrics:
quality_ranking
conversion_rate_ranking
engagement_rate_ranking
Existing reports won't be affected, but the fields will not be available for new reports.
Firebaselink
We have enhanced the connector to enable you to sync subcollections with the same name as top-level collections. You can now sync both subcollections and collections that share identical names.
Freshdesk Contact Centerlink
You can now configure your Freshdesk Contact Center connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
Google Calendarlink
We now perform a full re-sync for the EVENT
table to capture updates and deletes.
Google Cloud Storagelink
We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.
We have added a new toggle, Non-standard character escaping, in the connector setup form to support the non-standard ways of escaping characters. If your CSV generator uses non-standard ways of escaping character, enable the toggle and in the Character Escaping options drop-down menu, select one of the following options.
- Custom Escape Character: To process CSV files that use custom escape character to escape quotation marks.
- Delimited Only: To process CSV files that don't use escape character to escape quotation marks and process with delimiter only.
For more information, see our setup instructions and REST API config. We will gradually roll out this change to all existing connectors.
High-Volume Agent SQL Serverlink
Our High-Volume Agent SQL Server connector is now generally available. Read our High-Volume Agent SQL Server connector documentation.
Instagram Businesslink
We have upgraded our Instagram Business connector to version 18.0 of the Graph API. We are gradually rolling out this change to all existing connectors. For more information about the changes, see Graph API's changelog.
Iterablelink
We have added support for EU-based Iterable accounts. For more information, see our setup instructions.
Jotformlink
You can now specify your custom API base URL while setting up your connector. To enable you to specify your custom base URL, we have made the following changes to the connector setup form:
- Added a new option, Custom, to the Base URL drop-down menu.
- Added a new field, Custom base URL, which allows you to specify your custom base URL.
NOTE: The Custom base URL field appears only when you select Custom in the Base URL drop-down menu.
For more information, see our setup instructions.
We now capture deletes for the FORM
table.
LearnUponlink
We now incrementally sync the ENROLLMENT
table to capture updates.
Mavenlinklink
You can now exclude tables from the sync. On your connector details page, go to the Schema tab and deselect the tables you want to exclude from the sync.
IMPORTANT: You can exclude any table except for the
USER
table.
Maxio Chargifylink
We now incrementally sync the COMPONENT_PRICE_POINT
table and its child tables to capture new records.
We now also capture deletes for the COMPONENT_PRICE_POINT
table.
Named instance support for SQL Server HVAlink
Over the course of two weeks, we will be rolling out support for named instances in the High-Volume Agent SQL Server and High-Volume Agent SAP ECC on SQL Server connectors.
PostgreSQLlink
Fivetran Teleport Sync for PostgreSQL now utilizes a hybrid of XMIN updates and Teleport deletes to reduce incremental update failures:
- Inserts and updates are captured using XMIN updates.
- The deletes are captured using a simplified Teleport query.
With this change, Teleport now processes some DDL events differently:
DDL Statement | Before | After | Notes |
---|---|---|---|
CREATE TABLE | Yes | Yes | |
CREATE SCHEMA | Yes | Yes | |
ADD COLUMN | Yes | Yes | Rows synced before the ADD COLUMN operation now have null values in the newly-added destination column. Re-sync the table to update the existing rows with the default value. |
ADD COLUMN ... DEFAULT | Yes | Partially | Rows synced before the ADD COLUMN operation now have null values in the newly-added destination column. Re-sync the table to update the existing rows with the default value. |
RENAME TO new_table_name | No | No | |
RENAME TO new_schema_name | No | No | |
RENAME COLUMN | Yes | Yes | Rows synced before the ADD COLUMN operation now have null values in the newly-added destination column. Re-sync the table to update the existing rows with the default value. |
DROP COLUMN | No | No | |
ALTER COLUMN ... TYPE ... | Yes | Yes | We now support all non-primary key data type changes. For primary keys, we only support data type changes that don't affect the value. Unsupported primary key data type changes cause the subsequent sync to re-import the table. |
ALTER COLUMN ... TYPE ... USING | Yes | Yes | We now support all non-primary key data type changes. For primary keys, we only support data type changes that don't affect the value. Unsupported primary key data type changes cause the subsequent sync to re-import the table. |
ALTER COLUMN ... SET NOT NULL | No | No | |
DROP SCHEMA | No | No | |
DROP TABLE | No | No | |
TRUNCATE TABLE | Yes | Yes |
Impact on MAR
- XMIN wraparounds result in a MAR overage. To avoid an overage, enable the
pageinspect
andpg_visibility
XMIN extensions. Learn how in our XMIN wraparound causing excess MAR documentation. - Changes in excluded columns contribute towards MAR.
- Changes in a row's
xmin
column are captured as a change and contribute to MAR. Learn more in our XMIN system column documentation. - MAR should decrease for tables with composite primary keys, because the previous Teleport update query synced more rows than the new query.
All connectors with Teleport enabled run setup tests to verify that XMIN extensions are enabled. You can see a list of your PostgreSQL connector's setup tests in the setup guide. If there is a risk of a MAR overage, you receive a warning to enable XMIN extensions.
History Mode
We detect any change to the XMIN value of a row and replicated that change in the destination.
Reltiolink
Our Reltio connector now supports table-level re-syncs.
Rithumlink
We have renamed our ChannelAdvisor connector to Rithum, following ChannelAdvisor's name change. This name change applies to the Fivetran dashboard and our documentation.
Salesforcelink
We can now translate the formula fields that reference queue fields. Previously, translations for such fields failed with the LOOKUP_FIELD_NOT_SYNCED
failure reason. To enable the translation of these formula fields, you must select the GROUP
table as a dependent table.
SAP ERP on HANAlink
We can now sync empty tables to your destination.
Shopifylink
We have upgraded our Shopify connector from version 2023-04 to 2024-01 of the Shopify API. As part of the upgrade, we have deprecated the delivery_category
column of the ORDER_SHIPPING_LINE
table. We are gradually rolling out this change to all existing connectors. For more information about the change, see Shopify API's changelog.
Snowflakelink
We now support syncing materialized views. You can access these views from the Schema tab.
To sync materialized views, run the following commands in your worksheet. Replace <YOUR_SCHEMA>
and <YOUR_ROLE>
with your schema name and role name.
GRANT SELECT on all MATERIALIZED VIEWS in schema <YOUR_SCHEMA> to role <YOUR_ROLE>;`
GRANT SELECT on future MATERIALIZED VIEWS in schema <YOUR_SCHEMA> to role <YOUR_ROLE>;`
Stripelink
We have changed the sync strategy for the PLAN
table. To capture new records and updates, we now re-import this table every time we perform a sync for the connector. Previously, we re-imported this table once a day.
Support for syncing Kafka record headerslink
You can now sync record headers for Kafka connectors. We have added a new column, headers
, that stores record metadata as JSON key-value pairs.
NOTE: Existing connectors will synchronize record headers only for new data going forward.
This change applies to the following connectors:
Support for TRUNCATE commandlink
Our MariaDB and MySQL connectors now support the TRUNCATE
command.
TikTok Adslink
Previously, basic reports used STATUS_NOT_DELETE
filtering by default, which includes all statuses except Deleted
. Now, we added the STATUS_ALL
filtering option which incudes all statuses.
All basic report aggregations will now include deleted entities as well.
WorkRamplink
We now incrementally sync the EVENT
table and its child tables to capture new records.
Wrikelink
We now incrementally sync the ATTACHMENT
table and its child tables to capture new records.
Zuoralink
To improve data integrity, we have started doing once a week lookback periods for data updates on certain tables. This way, your information remains accurate and up-to-date.
The following tables will now have a 14-day lookback period:
CREDIT_MEMO_APPLICATION_ITEM
CREDIT_TAXATION_ITEM
DEBIT_MEMO_ITEM
DEBIT_TAXATION_ITEM
INVOICE_ITEM
INVOICE_ITEM_ADJUSTMENT
PAYMENT_APPLICATION_ITEM
REFUND_APPLICATION_ITEM
REVENUE_EVENT_ITEM
REVENUE_EVENT_ITEM_DEBIT_MEMO_ITEM
REVENUE_EVENT_ITEM_INVOICE_ITEM
REVENUE_EVENT_ITEM_INVOICE_ITEM_ADJUSTMENT
TAXATION_ITEM
The following tables will now have a 90-day lookback period:
CREDIT_MEMO_ITEM
REVENUE_EVENT_ITEM_CREDIT_MEMO_ITEM
REST API Improvementslink
Duoplanelink
You can now configure your Duoplane connector using the Fivetran REST API. This feature is available for Free, Standard, Enterprise, and Business Critical accounts.
New field added in Destinations APIlink
For the following endpoints, we added a new field, daylight_saving_time_enabled
:
If the field value is set to true
, the UTC offset is shifted in accordance with the daylight saving time. This option can only be used for the US region.
Proxy Agent Management APIlink
Our Proxy Agent Management API resource is now beta. You can now leverage the following features:
- Create a Proxy Agent
- List all Proxy Agents
- Retrieve Proxy Agent Details
- Delete a Proxy Agent
- Returns all connections attached to the proxy agent
- Attach connection to the proxy agent
- Detach connection from the proxy agent
Log eventslink
New Log Eventlink
We have added a new log event, schema_migration_end
. See our Logs documentation for more information.