May 2024

Fivetran Azure Germany West Central Servers

We have added new servers in the Azure Germany West Central (Frankfurt) 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 Germany West Central, your data does not leave Germany West Central during processing.

We now support Azure Private Link connections to sources and destinations in the Azure Germany West Central (Frankfurt) region.

For more information, see our data residency documentation.

Lite Connectors

Lite connectors are now available for the following sources:

Proxy Agent

The Fivetran Proxy Agent connection method is now available for the Azure Germany West Central (Frankfurt) region. The Proxy Agent allows you to connect Fivetran to your database securely. Installed behind your firewall, it initiates communication with Fivetran, eliminating the need for other complicated networking options.

Save for Later Option in Setup Forms

You can now save an incomplete configuration at any moment in your connector setup form, once you have entered the Destination schema or Destination schema prefix, by clicking Save for later. We save that connector in an incomplete configuration state.

Save incomplete connector configuration for later

Saving an incomplete connector configuration can be useful when you don't have all the information or permissions required to configure the connector at that moment. Later, you can find the connector by sorting or searching the connector list by connector name, and then complete the configuration.

Find connector with incomplete configuration by name

Transformation Improvements

Bulk Actions for Transformations

You can now use bulk actions for Transformations, to perform any of the following actions on multiple transformations at once:

Pause selected transformations
Resume selected transformations
Edit schedule of selected transformations
Remove selected transformations

Transformations for dbt Core

dbt Core version 1.7.14 support

We now support dbt Core version 1.7.14. You can use this version to run your projects.

For dbt Core versions later than 1.1.5, we don't support MySQL 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.

dbt Job Retries for Scheduled in Code Transformations.

We now support the dbt job retry mechanism for scheduled in code transformations. By default, we retry a failed job for up to 4 times.

You can change this by setting the value of the retryOnFailure parameter to false in the job configuration:

- name: daily
  schedule: 0 12 * * *
  retryOnFailure: false

Schema changes

15Five

Effective May 28, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to align with source changes.

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`GROUPS`
column	New Column	`mention_name`
`USERS`
column	New Column	`mention_name`

Cin7 Core

Effective May 20, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to support a feature enhancement.

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.

155 total changes • 84 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADDRESS`
table	Discontinued Table	`ADDRESS`		Data is available in the `CUSTOMER_ADDRESS` and `SUPPLIER_ADDRESS` tables.
`ATTACHMENT`
table	Discontinued Table	`ATTACHMENT`		Data is available in the `PRODUCT_ATTACHMENT`, `JOURNAL_ATTACHMENT`, and `PRODUCT_FAMILY_ATTACHMENT` tables.
`BILL_OF_MATERIAL_PRODUCT`
column	Discontinued Column	`wastage_percent`
`BILL_OF_MATERIALS_PRODUCT (new table name: BILL_OF_MATERIAL_PRODUCT)`
table	Rename Table	`BILL_OF_MATERIALS_PRODUCT`	`BILL_OF_MATERIAL_PRODUCT`	Updated to adhere to standard naming conventions.
`BILL_OF_MATERIALS_SERVICE (new table name: BILL_OF_MATERIAL_SERVICE)`
table	Rename Table	`BILL_OF_MATERIALS_SERVICE`	`BILL_OF_MATERIAL_SERVICE`	Updated to adhere to standard naming conventions.
`CONTACTS`
table	Discontinued Table	`CONTACTS`		Data is available in the `CUSTOMER_CONTACTS` and `SUPPLIER_CONTACTS` tables.
`CREDIT_NOTE (new table name: PURCHASE_CREDIT_NOTE)`
table	Rename Table	`CREDIT_NOTE`	`PURCHASE_CREDIT_NOTE`	Updated to adhere to standard naming conventions.
`CREDIT_NOTE_REFUND (new table name: PURCHASE_CREDIT_NOTE_REFUND)`
table	Rename Table	`CREDIT_NOTE_REFUND`	`PURCHASE_CREDIT_NOTE_REFUND`	Updated to adhere to standard naming conventions.
`CREDIT_NOTE_UNSTOCK (new table name: PURCHASE_CREDIT_NOTE_UNSTOCK)`
table	Rename Table	`CREDIT_NOTE_UNSTOCK`	`PURCHASE_CREDIT_NOTE_UNSTOCK`	Updated to adhere to standard naming conventions.
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.
`CUSTOMER_ADDRESS`
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
`CUSTOMER_CONTACTS`
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Discontinued Column	`type`
`CUSTOMER_PRODUCT_PRICE`
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Discontinued Column	`id`
`FAMILY_PRODUCT`
column	Discontinued Column	`id`
`INVENTORY_MOVEMENT (new table name: PURCHASE_INVENTORY_MOVEMENT)`
table	Rename Table	`INVENTORY_MOVEMENT`	`PURCHASE_INVENTORY_MOVEMENT`	Updated to adhere to standard naming conventions.
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.
column	Primary Key Change	`task_id` 🔑	`task_id`	No longer a primary key.
`INVOICE`
table	Discontinued Table	`INVOICE`		Data is available in the `PURCHASE_INVOICE` table.
`INVOICE_ADDITIONAL_CHARGE`
table	Discontinued Table	`INVOICE_ADDITIONAL_CHARGE`		Data is available in the `PURCHASE_INVOICE_ADDITIONAL_CHARGE` table.
`INVOICE_PAYMENT (new table name: PURCHASE_INVOICE_PAYMENT)`
table	Rename Table	`INVOICE_PAYMENT`	`PURCHASE_INVOICE_PAYMENT`	Updated to adhere to standard naming conventions.
column	Primary Key Change	`purchase_id`	`purchase_id` 🔑	Added to primary key.
`JOURNAL`
column	Primary Key Change	`journal_number`	`journal_number` 🔑	Added to primary key.
column	Primary Key Change	`task_id` 🔑	`task_id`	No longer a primary key.
column	Primary Key Change		`purchase_id` 🔑	New primary key.
`JOURNAL_ATTACHMENT`
column	Discontinued Column	`journal_task_id` 🔑		No longer a primary key.
column	Primary Key Change		`journal_number` 🔑	New primary key.
column	Primary Key Change		`purchase_id` 🔑	New primary key.
`JOURNAL_LINE`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	Discontinued Column	`journal_task_id`
column	New Column		`journal_number`
column	New Column		`purchase_id`	Added to support Cin7 Core API changes.
`LEAD`
table	New Table		`LEAD`
`LOCATION`
table	New Table		`LOCATION`
`LOCATION_BIN`
table	New Table		`LOCATION_BIN`
`MARKUP_PRICE`
table	Discontinued Table	`MARKUP_PRICE`		Data is available in the `PRODUCT_MARKUP_PRICE` table.
`NEW_STOCK_LINE`
table	New Table		`NEW_STOCK_LINE`
`NON_ZERO_STOCK_ON_HAND_PRODUCT`
table	New Table		`NON_ZERO_STOCK_ON_HAND_PRODUCT`
`OPPORTUNITY`
table	New Table		`OPPORTUNITY`
table	New Table		`OPPORTUNITY`
`OPPORTUNITY_ADDITIONAL_CHARGE`
table	New Table		`OPPORTUNITY_ADDITIONAL_CHARGE`
`OPPORTUNITY_LINE`
table	New Table		`OPPORTUNITY_LINE`
`PRODUCT`
column	Discontinued Column	`assembly_instruction_url`
`PRODUCT_ATTACHMENT`
column	Discontinued Column	`type`
`PRODUCT_CUSTOM_PRICE`
column	Discontinued Column	`product_cutstom_price_id` 🔑		No longer a primary key.
column	Primary Key Change	`product_id` 🔑	`product_id`	No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
column	New Column		`customer_id`	Added to support Cin7 Core API changes.
column	New Column		`price`	Added to support Cin7 Core API changes.
`PRODUCT_FAMILY`
column	Discontinued Column	`short_description`		Data is available in the `description` column.
`PRODUCT_FAMILY_ATTACHMENT`
column	Discontinued Column	`product_family_id`		Data is available in the `object_id` column.
column	Primary Key Change		`object_id` 🔑	New primary key.
`PRODUCT_MARKUP_PRICE`
column	Discontinued Column	`id`		Data is available in the `product_id` column.
column	Primary Key Change	`product_id` 🔑	`product_id`	No longer a primary key.
column	New Column		`markup_type`	Added to support Cin7 Core API changes.
column	New Column		`markup_value`	Added to support Cin7 Core API changes.
column	Primary Key Change		`tier_number` 🔑	New primary key.
column	New Column		`use_price_type`	Added to support Cin7 Core API changes.
`PRODUCT_MOVEMENT`
column	Primary Key Change	`number`	`number` 🔑	Added to primary key.
column	Primary Key Change	`task_id` 🔑	`task_id`	No longer a primary key.
`PRODUCT_PRODUCT_FAMILY (new table name: FAMILY_PRODUCT)`
table	Rename Table	`PRODUCT_PRODUCT_FAMILY`	`FAMILY_PRODUCT`	Updated to adhere to standard naming conventions.
`PRODUCT_REORDER_LEVEL`
column	Discontinued Column	`location_name`		Data is available in the `LOCATION` table.
`PURCHASE`
column	Discontinued Column	`order_total`
column	New Column		`blind_receipt`	Added to support Cin7 Core API changes.
`PURCHASE_CREDIT_NOTE`
column	Discontinued Column	`total`
column	Discontinued Column	`total_before_tax`
`PURCHASE_CREDIT_NOTE_REFUND`
column	Discontinued Column	`credit_note_task_id` 🔑		No longer a primary key.
column	Primary Key Change		`purchase_credit_not_task_id` 🔑	New primary key.
`PURCHASE_CREDIT_NOTE_UNSTOCK`
column	Discontinued Column	`credit_note_task_id` 🔑		No longer a primary key.
column	Discontinued Column	`id`
column	Primary Key Change		`purchase_credit_not_task_id` 🔑	New primary key.
`PURCHASE_INVENTORY_MOVEMENT`
column	Discontinued Column	`id`
`PURCHASE_INVOICE`
column	Discontinued Column	`advanced_purchase_invoice_purchase_id` 🔑		No longer a primary key.
column	Discontinued Column	`combine_additional_charges`
column	Discontinued Column	`invoice_total_amount`
column	Discontinued Column	`invoice_total_tax_amount`
column	Discontinued Column	`purchase_list_id` 🔑		No longer a primary key.
column	Discontinued Column	`tax`
column	Discontinued Column	`total`
column	Discontinued Column	`total_before_tax`
column	New Column		`invoicing_and_receiving_number`	Added to support Cin7 Core API changes.
column	New Column		`paid`	Added to support Cin7 Core API changes.
column	Primary Key Change		`purchase_id` 🔑	New primary key.
`PURCHASE_INVOICE_ADDITIONAL_CHARGE`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	New Column		`purchase_id`	Added to support Cin7 Core API changes.
`PURCHASE_INVOICE_LINE`
column	Discontinued Column	`id`
column	New Column		`product_custom_field_1`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_10`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_2`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_3`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_4`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_5`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_6`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_7`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_8`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_9`	Added to support Cin7 Core API changes.
column	Primary Key Change		`purchase_id` 🔑	New primary key.
`PURCHASE_INVOICE_PAYMENT`
column	Discontinued Column	`invoice_task_id`		Data is available in the `purchase_invoice_task_id` column.
column	Primary Key Change		`purchase_invoice_task_id` 🔑	New primary key.
`PURCHASE_LINE`
table	Discontinued Table	`PURCHASE_LINE`
`PURCHASE_LIST`
table	Discontinued Table	`PURCHASE_LIST`		Data is available in the `PURCHASE` table.
`PURCHASE_ORDER`
table	Discontinued Table	`PURCHASE_ORDER`		Data is available in the `PURCHASE` table.
`PURCHASE_ORDER_ADDITIONAL_CHARGE`
table	Discontinued Table	`PURCHASE_ORDER_ADDITIONAL_CHARGE`		Data is available in the `PURCHASE` table.
`PURCHASE_ORDER_LINE`
column	Discontinued Column	`id`
column	Discontinued Column	`purchase_order_task_id` 🔑		No longer a primary key.
column	Discontinued Column	`tax`
column	Discontinued Column	`total`		Added to support Cin7 Core API changes.
column	New Column		`dimensions_unit`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_1`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_10`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_2`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_3`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_4`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_5`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_6`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_7`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_8`	Added to support Cin7 Core API changes.
column	New Column		`product_custom_field_9`	Added to support Cin7 Core API changes.
column	Primary Key Change		`purchase_id` 🔑	New primary key.
column	New Column		`quantity`	Added to support Cin7 Core API changes.
`PURCHASE_STOCK_AND_PUT_AWAY_STATUS`
column	Primary Key Change		`purchase_id` 🔑	New primary key.
`PURCHASE_STOCK_STATUS (new table name: PURCHASE_STOCK_AND_PUT_AWAY_STATUS)`
table	Rename Table	`PURCHASE_STOCK_STATUS`	`PURCHASE_STOCK_AND_PUT_AWAY_STATUS`	Updated to adhere to standard naming conventions.
`SALE`
table	New Table		`SALE`
`SALE_ATTACHMENT`
table	New Table		`SALE_ATTACHMENT`
`SALE_CREDIT_NOTE`
table	New Table		`SALE_CREDIT_NOTE`
`SALE_CREDIT_NOTE_ADDITIONAL_CHARGE`
table	New Table		`SALE_CREDIT_NOTE_ADDITIONAL_CHARGE`
`SALE_CREDIT_NOTE_LINE`
table	New Table		`SALE_CREDIT_NOTE_LINE`
`SALE_CREDIT_NOTE_REFUND`
table	New Table		`SALE_CREDIT_NOTE_REFUND`
`SALE_CREDIT_NOTE_RESTOCK`
table	New Table		`SALE_CREDIT_NOTE_RESTOCK`
`SALE_FULLFILLMENT`
table	New Table		`SALE_FULLFILLMENT`
`SALE_FULLFILLMENT_PACK_LINE`
table	New Table		`SALE_FULLFILLMENT_PACK_LINE`
`SALE_FULLFILLMENT_PICK_LINE`
table	New Table		`SALE_FULLFILLMENT_PICK_LINE`
`SALE_FULLFILLMENT_SHIP_LINE`
table	New Table		`SALE_FULLFILLMENT_SHIP_LINE`
`SALE_INVENTORY_MOVEMENT`
table	New Table		`SALE_INVENTORY_MOVEMENT`
`SALE_INVOICE`
table	New Table		`SALE_INVOICE`
`SALE_INVOICE_ADDITIONAL_CHARGE`
table	New Table		`SALE_INVOICE_ADDITIONAL_CHARGE`
`SALE_INVOICE_LINE`
table	New Table		`SALE_INVOICE_LINE`
`SALE_ORDER_ADDITIONAL_CHARGE`
table	New Table		`SALE_ORDER_ADDITIONAL_CHARGE`
`SALE_ORDER_LINE`
table	New Table		`SALE_ORDER_LINE`
`SALE_QUOTE_ADDITIONAL_CHARGE`
table	New Table		`SALE_QUOTE_ADDITIONAL_CHARGE`
`SALE_QUOTE_LINE`
table	New Table		`SALE_QUOTE_LINE`
`SALE_TRANSACTION`
table	New Table		`SALE_TRANSACTION`
`STOCK_ADJUSTMENT`
table	New Table		`STOCK_ADJUSTMENT`
`STOCK_ADJUSTMENT_TRANSACTION`
table	New Table		`STOCK_ADJUSTMENT_TRANSACTION`
`STOCK_TAKE`
table	New Table		`STOCK_TAKE`
`STOCK_TAKE_TRANSACTION`
table	New Table		`STOCK_TAKE_TRANSACTION`
`STOCK_TRANSFER`
table	New Table		`STOCK_TRANSFER`
`STOCK_TRANSFER_LINE`
table	New Table		`STOCK_TRANSFER_LINE`
`STOCK_TRANSFER_ORDER_LINE`
table	New Table		`STOCK_TRANSFER_ORDER_LINE`
`SUPPLIER_ADDRESS`
column	Primary Key Change	`supplier_id`	`supplier_id` 🔑	Added to primary key.
`SUPPLIER_CONTACTS`
column	Primary Key Change	`supplier_id`	`supplier_id` 🔑	Added to primary key.
column	Discontinued Column	`type`
`TASK`
table	New Table		`TASK`
`ZERO_STOCK_ON_HAND_PRODUCT`
table	New Table		`ZERO_STOCK_ON_HAND_PRODUCT`

Close

Effective May 6, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to fix a bug.

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.

6 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CONTACT`
column	New Column		`integration_links`
`CONTACT_INTEGRATION_LINK`
table	Discontinued Table	`CONTACT_INTEGRATION_LINK`		Data is available in the `INTEGRATION_LINK` table.
`LEAD`
column	New Column		`integration_links`
`LEAD_INTEGRATION_LINK`
table	Discontinued Table	`LEAD_INTEGRATION_LINK`		Data is available in the `INTEGRATION_LINK` table.
`SMS_ATTACHMENT`
column	Primary Key Change	`media_id` 🔑	`media_id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.

Delighted

For connections created on or after April 26, 2024, we have renamed the primary key column from tag to tags in the RESPONSE_TAG table.

Dropbox Sign

Effective May 27, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

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.

9 total changes • 6 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ACCOUNT`
table	Discontinued Table	`ACCOUNT`		Data is available in the `TEAM` table.
`SIGNATURE`
column	Discontinued Column	`signature_request_id` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`TEAM`
column	Discontinued Column	`id` 🔑		No longer a primary key
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
column	New Column		`invited_account`	Data of the discontinued `ACCOUNT` table is available in this column.
column	New Column		`name`	No longer a primary key.
`TEAM_ACCOUNT`
column	Discontinued Column	`invited`		Data is available in the `invited_account` column of the `TEAM` table.
column	New Column		`_fivetran_id`

Facebook Pages

We have added a new field, unshimmed_url, to the POST_ATTACHMENT_HISTORY table.

We have added a new field, full_picture, to the POST_HISTORY table.

Flexport

Effective May 27, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

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.

4 total changes • 3 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`BOOKING_DESCRIPTION`
column	Primary Key Change	`code` 🔑	`code`	No longer a primary key.
column	Primary Key Change	`description_type` 🔑	`description_type`	No longer a primary key.
column	Primary Key Change	`parent_id` 🔑	`parent_id`	No longer a primary key.
column	New Column		`_fivetran_id` 🔑	Added to primary key.

GetFeedback

Effective May 28, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`RESPONSE`
column	Primary key change			`survey_id` 🔑	Added to primary key.

GRIN

Effective May 13, 2024 we use a new May 2024 Schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

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.

10 total changes • 9 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CONTACT_CUSTOM_PROPERTY`
column	Primary Key Change	`contact_id`	`contact_id` 🔑	Added to primary key.
`CONTACT_TAG`
column	Primary Key Change	`contact_id`	`contact_id` 🔑	Added to primary key.
`CUSTOM_PROPERTY_OPTION`
column	Primary Key Change	`custom_property_id`	`custom_property_id` 🔑	Added to primary key.
`MEDIA_LIBRARY_CONTENT`
column	New Column		`owner_reached`
`MEDIA_LIBRARY_CONTENT_TAG`
column	Primary Key Change	`media_library_content_id`	`media_library_content_id` 🔑	Added to primary key.
`PARTNERSHIP_JOB`
column	Primary Key Change	`partnership_id`	`partnership_id` 🔑	Added to primary key.
`PARTNERSHIP_PROPOSAL`
column	Primary Key Change	`partnership_id`	`partnership_id` 🔑	Added to primary key.
`PARTNERSHIP_TASK`
column	Primary Key Change	`partnership_id`	`partnership_id` 🔑	Added to primary key.
`PAYMENT_ITEM`
column	Primary Key Change	`payment_id`	`payment_id` 🔑	Added to primary key.
`PRODUCT_IMAGE`
column	Primary Key Change	`product_id`	`product_id` 🔑	Added to primary key.

Instagram Business

We have added a new table, MEDIA_COMMENT, with the following fields:

created_time
hidden
id
like_count
media_id
owner_id
owner_username
parent_id
text

For more information, see the Instagram Business ERD.

Kantata

We have added a new table, ACCOUNT_LOCATION. We are gradually rolling out this change to all existing connections.

Klaviyo

We have added the following new tables and associated child tables:

COUPON
- COUPON_CODE
TAGS
- CAMPAIGN_TAG
- FLOW_TAG
- LIST_TAG
- SEGMENT_TAG
TAG_GROUP

We have added the following child tables to the FLOW table:

FLOW_ACTIONS
FLOW_ACTION_UTM_PARAMS
FLOW_MESSAGE

We re-import these tables in every sync. We are gradually rolling out these changes to all existing connections.

Pardot

We have added a new table, EMAIL_TEMPLATE, with the REPLY_TO_OPTION and SENDER_OPTION child tables.

Pipedrive

We have changed the data type of the progress column in the GOAL table from INT to DOUBLE.

PostreSQL

Effective June 15, 2024, only the newly created PostgreSQL connections will display the root partitioned table in the Fivetran dashboard because we sync data from the partitioned tables into the base table. Previously, we displayed both the root partitioned table and its child tables.

PowerReviews Enterprise

Effective May 10, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

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.

21 total changes • 21 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`QUESTION`
column	Primary Key Change	`id` 🔑	`id`	No longer a primary key.
column	Discontinued Column	`index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`QUESTION_ANSWER`
column	Primary Key Change	`question_id` 🔑	`question_id`	No longer a primary key.
column	Discontinued Column	`question_index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`REVIEW`
column	Primary Key Change	`id` 🔑	`id`	No longer a primary key.
column	Discontinued Column	`index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`REVIEW_BADGE`
column	Discontinued Column	`review_id` 🔑		No longer a primary key.
column	Discontinued Column	`review_product_page_id` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`REVIEW_CUSTOM_QUESTION_NAME`
column	Discontinued Column	`review_id` 🔑		No longer a primary key.
column	Discontinued Column	`review_index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`REVIEW_MEDIA`
column	Primary Key Change	`review_id` 🔑	`review_id`	No longer a primary key.
column	Discontinued Column	`review_index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.
`REVIEW_MERCHANT_RESPONSE`
column	Primary Key Change	`review_id` 🔑	`review_id`	No longer a primary key.
column	Discontinued Column	`review_index` 🔑		No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.

Productboard

Effective May 8, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to fix a bug.

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.

4 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`NOTE_COMMENT`
column	Primary Key Change	`id` 🔑	`id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`NOTE_FEATURE`
column	Primary Key Change	`id` 🔑	`id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.

Effective May 9, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to fix a bug.

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.

3 total changes • 3 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`NOTE_FOLLOWER`
column	Primary Key Change	`member_id` 🔑	`member_id`	No longer a primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`TEMP_NOTE`
table	Discontinued Table	`TEMP_NOTE`		Data available in the `NOTE` table.

Qualtrics

We have added a new column, label, to the QUESTION_RESPONSE table. We are gradually rolling out this change to all existing connections.

SAP Concur

We have added a new table, ENTRY_ATTENDEE_ASSOCIATION. We are gradually rolling out this change to all existing connections.

Sharetribe

Effective May 15, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to fix a bug.

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.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`TRANSACTION_LINE_ITEM`
column	Primary Key Change	`transaction_id`	`transaction_id` 🔑	Added to primary key.
`TRANSACTION_LINE_ITEM_INCLUDE`
column	Primary Key Change	`transaction_id`	`transaction_id` 🔑	Added to primary key.

Shortcut

We have added two new tables, EPIC_STORY_CUSTOM_FIELD and STORY_CUSTOM_FIELD.

We have added a new column, group_id, to the STORY table.

Spotify Ads

We have made the following schema changes for all Spotify Ads connections:

added a new column, canvasAssetId, to the AUDIO_ASSET table
added a new column, display_name, to the ACCOUNT table
added a new column, user_uploaded_image, to the AD table
added two new metrics to the Get_Aggregate_Report report for campaigns using the Video Views objective:
- VIDEO_EXPANDS
- VIDEO_EXPAND_RATE

Also, we now support the AD_ACCOUNT entity for custom aggregated reports.

StackAdapt

Effective May 8, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`STATS_DELIVERY`
column	Primary Key Change		`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.

Standard Metrics

Effective May 21, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to improve data management.

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.

4 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CUSTOM_COLUMN`
table	Discontinued Table	`CUSTOM_COLUMN`		Data is available in the `CUSTOM_COLUMN_TEXT`, `CUSTOM_COLUMN_SELECT`, and `CUSTOM_COLUMN_MULTI_SELECT` tables.
`CUSTOM_COLUMN_MULTI_SELECT`
table	New Table		`CUSTOM_COLUMN_MULTI_SELECT`
`CUSTOM_COLUMN_SELECT`
table	New Table		`CUSTOM_COLUMN_SELECT`
`CUSTOM_COLUMN_TEXT`
table	New Table		`CUSTOM_COLUMN_TEXT`

StarRez

We have added the following new tables:

CUSTOM_FIELD_DEFINITION
CUSTOM_FIELD_USAGE_TYPE_ENUM
ENROLLMENT_TYPE_ENUM
FIELD_DATA_TYPE_ENUM
GENERIC_TABLE_DATA
GENERIC_TABLE_DATA_FIELD
GENERIC_TABLE_DEFINITION
GENERIC_TABLE_DEFINITION_FIELD
GENDER_TYPE_ENUM
GL_POSTING_TYPE_ENUM
GROUPS
GROUP_STATUS_ENUM
LOG_ACTIVITY_DELETE
PROMO_CODE
PROMO_CODE_RECORD
PROMO_CODE_USAGE
RECORD_TYPE_ENUM
ROOM_RATE_DURATION_ENUM
ROOM_SPACE_TYPE_ENUM
TERM
TERM_SESSION

Stripe

We have added three new columns to the SUBSCRIPTION_HISTORY table:

cancellation_details_comment
cancellation_details_feedback
cancellation_details_reason

Effective May 19, 2024, we will sync only new data into these columns and will not sync your historical data before May 19, 2024.

UKG Pro

Effective May 23, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

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.

1 total changes • 1 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`EMPLOYMENT`
column	Primary Key Change		`company_id`	`company_id` 🔑	Added to primary key.

VWO

Effective May 3, 2024 we use a new May 2024 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to prevent or resolve data integrity issues.

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.

4 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`CAMPAIGN_SHARE_LINK`
column	Primary Key Change	`campaign_id` 🔑	`campaign_id`	No longer a primary key.
column	Discontinued Column	`index` 🔑		No longer a primary key.
column	Primary Key Change	`workspace_id` 🔑	`workspace_id`	No longer a primary key.
column	Primary Key Change		`_fivetran_id` 🔑	New primary key.

Improvements

AppsFlyer

We now perform rollback syncs for the GEO_DAILY table to capture the latest Lifetime Value (LVT) records that change due to attribution. The default rollback window is 2 days. However, you can customize your rollback window within the range of 2 to 90 days. To support this enhancement, we have added a new field, Rollback Window, to the connector setup form. For more information, see our setup instructions.

Attentive

We have changed the connector type of our Attentive connector from Lite to Standard.

Azure Blob Storage

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.

Azure Data Lake Storage

We now perform regular maintenance operations on the tables in your Azure Data Lake Storage destination. These maintenance operations do the following:

Delete the table snapshots that are older than 7 days
Clean up orphan and removed files

For more information, see our Azure Data Lake Storage documentation. We are gradually rolling out this enhancement to all existing destinations.

BigQuery

We support syncing data from tables and views from Analytics Hub linked datasets, which do not have the data egress restriction.

Care Quality Commission

We have made the following updates to our Care Quality Commission connector to support the changes in the Care Quality Commission API:

In the connector setup form, we replaced the Partner code field with the Primary key field. For more information, see our setup instructions.
In the API config parameters, we replaced the partner_code parameter with the primary_key parameter. For more information, see our REST API documentation.

Churnzero

We no longer capture deletes for the following tables and their child tables:

ACCOUNT
CONTACT
EVENT
JOURNEY
JOURNEY_INSTANCE
JOURNEY_MILESTONE
JOURNEY_MILESTONE_ACHIEVEMENT
JOURNEY_MILESTONE_PROGRESS
JOURNEY_MILESTONE_STEP_PROGRESS
JOURNEY_MILESTONE_TASK
JOURNEY_PROGRESS
SEGMENT
SEGMENT_COLUMN_SET
SURVEY_RESPONSE
TASK
USER_ACCOUNT

Cin7 Core

We have renamed our DEAR connector to Cin7 Core. This name change applies to the Fivetran dashboard and our documentation.

Cvent

We have changed the sync strategy for the ATTENDEE_ACTIVITY table. We no longer re-import the ATTENDEE_ACTIVITY table to capture updates and deletes.

Delighted

For Delighted connections created on or after April 26, 2024, we have made the following changes to the Schema tab:

All table names now appear in lowercase.
We now display all tables in the schema, including the empty tables.
We no longer support table-level selection or deselection for new Delighted connections.

Drip

We no longer re-import the following tables and their child tables to capture deletes:

CONVERSATION
EMAIL_SERIES_CAMPAIGN
EMAIL_SERIES_SUBSCRIBER_ACTIVE
EMAIL_SERIES_SUBSCRIBER_REMOVED
EMAIL_SERIES_SUBSCRIBER_UNSUBSCRIBED
PEOPLE
SINGLE_EMAIL_CAMPAIGN
WORKFLOW

Dropbox

Our Dropbox connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.

Eventbrite

We have changed our sync strategy and no longer capture deletes for the ATTENDEE and ORDERS tables and their child tables.

Facebook Ads

We now support the new Engaged-view attribution window with a 1 day value. This window refers to engaged-view conversions that are counted when a skippable video ad is played for at least 10 seconds or at least 97% of its total length if it’s shorter than 10 seconds, then a person takes an action within one day.

Learn more in Facebook's Engaged-view documentation and Graph API parameters documentation.

Firebase

Support for non-default Firebase databases is now generally available for Firebase.

Learn more about multiple databases (default and non-default databases) in Google's documentation.

Fivetran Platform Connector

The Fivetran Platform connector now syncs 7 days' worth of historical data instead of 5 days.

You can now select tables to include or exclude from syncs on the Schema tab of the connector details page in your Fivetran dashboard.

We are gradually rolling out these changes to all existing connections.

Google Analytics 4

Google Analytics 4 now supports aggregation by time unit dimensions.

Insightly

We now incrementally sync the following tables and their child tables:

CONTACT
CONTACT_FILE_ATTACHMENT
CUSTOM_OBJECT_RECORD
EMAIL
EMAIL_FILE_ATTACHMENT
EVENT
FORUM
FORUM_CATEGORY
FORUM_COMMENT
FORUM_POST
LEAD
LEAD_FILE_ATTACHMENT
NOTE
NOTE_COMMENT
NOTE_FILE_ATTACHMENT
MILESTONE
OPPORTUNITY
OPPORTUNITY_FILE_ATTACHMENT
OPPORTUNITY_ITEM
ORGANISATION
ORGANISATION_FILE_ATTACHMENT
PRICE_BOOK
PRICE_BOOK_ENTRY
PRODUCT
PROJECT
PROSPECT
QUOTE
QUOTE_ITEM
TASK
TICKET
USERS

Instagram Business

We have added data that represents comments on IG Media to our Instagram Business connector. For more information, see Graph API's IG Comment.

Jira

We now support Remote Issue Links. We are gradually rolling out this feature to all existing connections. Once it's available for your connector, you will find the ISSUE_REMOTE_LINK table in your destination. To learn more, see Jira's Remote Issue Links documentation.

Klaviyo

We can now pack all the custom fields for the EVENT and PERSON tables into a single JSON file and upsert it into a single column. We have added a new field, Pack Mode, to the connector setup form. The field provides you the option to choose how Fivetran should handle your custom fields. For more information, see our Klaviyo connector documentation.

Mambu

We no longer re-import the CENTRE table and its child tables.

Maxio Chargify

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

We now also capture deletes for the COMPONENT table.

MySQL

Our GTID replication mode is now generally available.

NetSuite SuiteAnalytics

We have fixed a bug where we didn’t sync some records for the PREVIOUS_TRANSACTION_LINE_LINK table. Also, we have added the _fivetran_index column as a primary key in the PREVIOUS_TRANSACTION_LINE_LINK table.

OneLake

We now perform regular maintenance operations on the tables in your OneLake destination. These maintenance operations do the following:

Delete the table snapshots that are older than 7 days
Clean up orphan and removed files

For more information, see our OneLake documentation. We are gradually rolling out this enhancement to all existing destinations.

Prive

We no longer capture deletes for the following tables:

BILLING_ATTEMPT
ORDER_LINE_ITEM
PRODUCT
SUBSCRIBER
SUBSCRIPTION_ACTIVITY

Qualtrics

The Qualtrics connector now supports OAuth 2.0 authentication. Qualtrics connections created on or after May 21, 2024, use OAuth 2.0-based authentication. For more information, see our setup instructions.

You can migrate your existing connectors from API key-based authentication to OAuth authentication. For more information, see our migration instructions.

We are gradually rolling out this feature to all existing connections.

Salesforce

We now translate formulas containing the / operator only for the following destinations:

BigQuery
Databricks
PostgreSQL
Redshift
Snowflake

Previously, we supported this operator for all destinations.

Salesforce Commerce Cloud

We now capture deletes for the following tables:

CATALOG
CATEGORY
COUPON
CUSTOMER_GROUP
CUSTOM_OBJECT_ATTRIBUTE_DEFINITION
CUSTOM_OBJECT_ATTRIBUTE_GROUP
GIFT_CERTIFICATE
GIFT_CERTIFICATE_TRANSACTION
INVENTORY_LIST
INVENTORY_LIST_RECORD
PROMOTION
SHARED_PRODUCT_OPTION
SHARED_PRODUCT_OPTION_VALUE
SOURCE_CODE_GROUP
STORE

Salesloft

We can now sync the email templates used in Salesloft Cadences into the EMAIL_TEMPLATES table. To backfill the historical data for this type of email templates, re-sync the EMAIL_TEMPLATES table.

SharePoint

Our SharePoint connector now supports syncing Microsoft Excel spreadsheets in Merge Mode. For more information, see our setup instructions.

Spotify Ads

We now support the Spotify Ads API v2 with all the updates till March 2024.

Sprout Social

Our Sprout Social connector is now generally available. Read our Sprout Social connector documentation.

Square

The Square connector now supports table blocking for all Square tables. You can choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables. Be sure to include a parent table for the sync, if you want to sync its child table.

Vitally

We have added a new field, Base URL, to the setup form. For more information, see our setup instructions.

Workday HCM

We now support OAuth authentication to connect to Workday HCM.

Zoho CRM

You can now select the child tables (including subforms) to sync from the Schema tab on your connector details page. To backfill the historical data for a child table that you select, re-sync its parent table. We will backfill the historical data for the subforms during their weekly re-import.

We now create empty tables and columns in your destination for the child tables that do not have any data.

You can now track the history of your deal stages. To facilitate this enhancement, we have added the following new tables:

STAGE
A new child table, DEAL_STAGE_HISTORY, to the DEAL table

We are gradually rolling out this enhancement to all existing connections.

REST API Improvements

Create a Connection Schema Config endpoint

Our Connection Management API now supports a new endpoint, Create a Connection Schema Config. The endpoint allows you to configure the schema before the initial sync without reloading it.

Updates to REST API for Proxy Agent and Private Link Management

To Create a Private Link using our Private Link Management API, you now must specify the service and region parameter values in the request instead of group_id. This enables you to use a single private link for all destinations with the same service and region.

To Create a Proxy Agent using our Proxy Agent Management API, you now must specify the group_region parameter value in the request instead of group_id. This enables you to use a single proxy agents for all connections in a specified region.

We have added the following parameters in the Connection Management API:

proxy_agent_id - defines the proxy ID
private_link_id - defines the private link ID.
networking_method - defines the connection method. Possible values are as follows:
- Directly - direct connection
- PrivateLink - connection via private link
- ProxyAgent - connection via proxy
- SshTunnel - connection via SSH Tunnel.

We have added the following parameters in the Destination Management API:

private_link_id - defines the private link ID.
networking_method - defines the connection method. Possible values are as follows:
- Directly - direct connection
- PrivateLink - connection via private link
- SshTunnel - connection via SSH Tunnel.