Fivetran Release Notes

We have changed the date from which we start syncing your data in historical syncs. During historical syncs, we now sync your data from January 1, 2019. However, if you want us to sync your historical data older than January 1, 2019, contact our support team.

We now offset run times within an hour for dbt jobs that run every 24 hours. The offset is fixed for the entire group and calculated based on group_id. New schedule for DBT JobsWe use the same offset for connectors in the same group. Schedule for Connectors

We have added two new tables, BOARD_CUSTOM_FIELD and CARD_CUSTOM_FIELD_ITEM.

Our Proxy Agent Management API resource is now in 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

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.{% /note %}

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.This change applies to the following connectors:

• Apache Kafka
• AWS MSK
• Confluent Cloud
• Heroku Kafka

{% note %}For the existing connectors, we will now sync record headers only for new data.{% /note %}

We have renamed the API Secret field to API password in the connector setup form.

We have 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 errors created after a sync failure.
• If setup tests fail, we do not add a new reconnection alert.

We now incrementally sync the ENROLLMENT table to capture updates.

We have renamed the API key field to Personal API token in the CircleCI connection setup form and API configuration parameters.

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.

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.{% /note %}

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.{% /note %}

For more information, see our setup instructions.We now capture deletes for the FORM table.

We have added a new field, daylight_saving_time_enabled, for the following endpoints:

• Create a destination
• Retrieve destination details
• Modify a destination

If the field value is set to true, the UTC offset is shifted in accordance with the daylight saving time. You can use this option only for the US region.

We now incrementally sync the EVENT table and its child tables to capture new records.

Our High-Volume Agent SQL Server connector is now generally available. Read our High-Volume Agent SQL Server connector documentation.We now support named instances in our High-Volume Agent SQL Server connector. We are gradually rolling out this improvement to all existing connections.

Our MariaDB and MySQL connectors now support the TRUNCATE command.