January 2025

Connector SDK

Fivetran Connector SDK

Support for multiple Python versions: You now have the option to select which Python version to use when running your code. See our Connector SDK documentation for a list of supported Python versions.
External log services: You can now use external log services for your SDK connections' logs.
Edit connection details: You can now update your connection configuration values for existing configuration keys in the dashboard. To do so, log into your dashboard, go to the Setup tab of your SDK connection, and click Edit connection details. This enables you to deploy an SDK connection without specifying configuration values in the configuration key-value pairs of the configuration.json file. Later, you can add the configuration values for existing keys in your dashboard or by using our REST API, or by re-deploying the connection with a new configuration.json.
100 fields maximum in configuration.json: No more than 100 fields are allowed in the configuration.json when deploying your SDK connection.

`fivetran-connector-sdk` PyPI package

We have released version 0.13.30.1 of the fivetran-connector-sdk PyPI package. This release adds the following:

Enhancements and minor bug fixes around logging and improved error messages.
Updated testers.
Minor bug fixes.

We have released version 0.13.22.1 of the fivetran-connector-sdk PyPI package. This release adds the following:

Support for multiple Python versions.
Enhancements and minor bug fixes around logging and requirements.txt verification.
Enhanced prompts to overwrite configurations.
Minor bug fixes.

We have released version 0.13.16.2 of the fivetran-connector-sdk PyPI package. This release adds the following:

Minor bug fixes.
Enhanced logging and removal of unwanted warnings.

We have released version 0.13.10.1 of the fivetran-connector-sdk PyPI package. This release adds the following:

A user confirmation prompt to automatically update faulty requirements.txt files.
Added support for installing packages directly from Git sources via requirements.txt.
Enhanced logging and exception handling for improved debugging and reliability.

Dashboard Improvements

New Connection Schema Review Changes functionality

We've added a new feature to the connection Schema page in the Fivetran dashboard that allows you to review pending changes. When you modify schema, table, or column selections, or update the sync mode, a Pending Changes action bar appears at the bottom of the page.

Pending Changes Panel

Click Review Changes to open a side panel that organizes all pending changes by schema and type, helping to streamline the review process. Each change includes a View link that takes you to the corresponding update in the table.

Review Changes Panel

Click Save changes to save and apply the schema changes.

Hybrid Deployment

You can now deploy your Hybrid Deployment containers on Kubernetes.

For more information about setting up Hybrid Deployment on Kubernetes, see our setup instructions.

Lite Connectors

Lite connectors are now available for the following sources:

Source naming

Our Source naming feature is now generally available.

For the complete list of connectors and destinations supporting this feature, see our Database documentation.

Sunset PostgreSQL Versions

We no longer support PostgreSQL database versions earlier than 9.1 as destinations. We now support only PostgreSQL version 9.1 or newer. We have discontinued support for the earlier versions because the latest JDBC drivers have discontinued them. For more information, see the PostgreSQL changelog.

Transformations

We now log the following events for dbt Cloud* Orchestration and Coalesce** Orchestration:

* dbt Cloud 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.

** Coalesce is a trademark of Coalesce Automation, Inc. All rights therein are reserved to Coalesce Automation, Inc. Fivetran Transformations is not a product or service of or endorsed by Coalesce Automation, Inc.

Transformations for dbt Core

Updated dbt Quickstart packages

We have updated the Quickstart packages for the following connectors:

Fivetran Platform Connector to version 1.11.0
Marketo to version 0.13.1
Mixpanel to version 0.11.0
NetSuite SuiteAnalytics to version 0.17.1
Qualtrics to version 0.3.0
QuickBooks to version 0.17.1
Salesforce to version 1.2.0
ServiceNow to version 0.4.0
Shopify to version 0.16.0
Stripe to version 0.16.0
Xero to version 0.7.0
Zendesk Support to version 0.19.3
Zuora to version 0.3.1

New connectors

CockroachDB

CockroachDB is a horizontally-scaling, distributed SQL database. Read our CockroachDB documentation.

Schema changes

Apple App Store

We have added the currency_of_proceeds column to the SALES_SUMMARY_DAILY and SALES_SUMMARY_YEARLY tables. To capture the currency_of_proceeds column for existing data, trigger a historical re-sync.

We have added the campaign column to the following tables:

APP_SESSION_DETAILED_DAILY
APP_STORE_DOWNLOAD_DETAILED_DAILY
APP_STORE_DISCOVERY_AND_ENGAGEMENT_DETAILED_DAILY
APP_STORE_INSTALLATION_AND_DELETION_DETAILED_DAILY
APP_STORE_PRE_ORDER_DETAILED_DAILY
APP_STORE_PURCHASE_DETAILED_DAILY

Re-sync the tables to backfill the historical data for the new columns or contact our Support team to re-sync them for you. The data in the campaign columns has been made available starting November 19, 2024. You can't sync data older than that.

Apple Search Ads

We've removed the deprecated CREATIVE_SET_REPORT table.

We've added the following fields to the AD_GROUP_HISTORY table:

default_bid_amount
default_bid_currency
display_status
payment_model
pricing_model

We've added the following fields to the CAMPAIGN_HISTORY table:

ad_channel_type
billing_event
creation_time
display_status
supply_sources

We've added the creation_time field to the KEYWORD_HISTORY table.

We've added the deep_link field to the PRODUCT_PAGE_HISTORY table.

We've added the adam_id field to the PRODUCT_PAGE_LOCALE table.

For more information, see the Apple Search Ads ERD.

Assembled

Effective January 14, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`ACTIVITY`
column	New Column			`event_id`

Bitly

Effective January 17, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

January 17, 2025: Migration window begins. Additions and Phase 1 changes take effect. You can manually start the update in your Fivetran dashboard.

February 17, 2025: Migration window closes. If you haven't already started the update manually, Fivetran will apply the remaining changes automatically.

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.

3 total changes • 1 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`QR_CODE`
table	Discontinued Table	`QR_CODE`		Data is available in the `QR_CODE_PNG` and `QR_CODE_SVG` tables.
`QR_CODE_PNG`
table	New Table		`QR_CODE_PNG`
`QR_CODE_SVG`
table	New Table		`QR_CODE_SVG`

Centra

Effective January 30, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We have made these schema changes to improve schema usability.

39 total changes • 0 possible breaking changes

Table/column	Change type	New name
`CAMPAIGN`
table	New Table	`CAMPAIGN`
`CAMPAIGN_VARIANT`
table	New Table	`CAMPAIGN_VARIANT`
`LOWEST_PRICE`
table	New Table	`LOWEST_PRICE`
`LOWEST_PRICE_MARKET`
table	New Table	`LOWEST_PRICE_MARKET`
`MARKET`
table	New Table	`MARKET`
`MARKET_ASSIGNED_TO_COUNTRY`
table	New Table	`MARKET_ASSIGNED_TO_COUNTRY`
`ORDER_LINE`
column	New Column	`line_campaign_discount_conversion_date`
column	New Column	`line_campaign_discount_conversion_rate`
column	New Column	`line_campaign_discount_formatted_value`
column	New Column	`line_campaign_discount_percent`
column	New Column	`line_campaign_discount_value`
column	New Column	`line_campaign_discount_value_in_cents`
column	New Column	`line_campaign_fixed_price_conversion_date`
column	New Column	`line_campaign_fixed_price_conversion_rate`
column	New Column	`line_campaign_fixed_price_formatted_value`
column	New Column	`line_campaign_fixed_price_value`
column	New Column	`line_campaign_fixed_price_value_in_cents`
column	New Column	`line_campaign_id`
column	New Column	`line_campaign_name`
column	New Column	`line_campaign_original_discount_conversion_date`
column	New Column	`line_campaign_original_discount_conversion_rate`
column	New Column	`line_campaign_original_discount_formatted_value`
column	New Column	`line_campaign_original_discount_value`
column	New Column	`line_campaign_original_discount_value_in_cents`
column	New Column	`line_campaign_show_news`
column	New Column	`line_campaign_show_sale`
column	New Column	`line_campaign_start_at`
column	New Column	`line_campaign_stop_at`
column	New Column	`line_campaign_type`
column	New Column	`line_value_conversion_date`
column	New Column	`line_value_conversion_rate`
column	New Column	`line_value_formatted_value`
column	New Column	`line_value_value`
column	New Column	`line_value_value_in_cents`
`ORDERS`
column	New Column	`billing_address_country_id`
column	New Column	`shipping_address_country_id`
`PRODUCT_VARIANT`
column	New Column	`external_id`
`PRODUCT_VARIANT_DISPLAY`
table	New Table	`PRODUCT_VARIANT_DISPLAY`
`PRODUCT_VARIANT_MEDIA`
table	New Table	`PRODUCT_VARIANT_MEDIA`

Chameleon

Effective January 13, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`MICRO_SURVEY_RESPONSE`
column	New Column			`comment_step_input_text_2`

Chargebee Product Catalog 1.0

Effective January 3, 2025 we use a new January 2025 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.

117 total changes • 56 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ADDON`
column	New Column		`proration_type`
`ADDON_TAX_PROVIDER_FIELD`
table	New Table		`ADDON_TAX_PROVIDER_FIELD`
`ADDON_TIER`
table	New Table		`ADDON_TIER`
`CREDIT_NOTE_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM`
table	New Table
`CREDIT_NOTE_LINE_ITEM_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_LINE_ITEM_TAX`
table	New Table
`CREDIT_NOTE_LINE_ITEM_TIER`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CREDIT_NOTE_TAX`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`credit_note_id`	`credit_note_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_BALANCE`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`customer_id`	`customer_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`CUSTOMER_TAX_PROVIDER_FIELD`
table	New Table		`CUSTOMER_TAX_PROVIDER_FIELD`
`EVENT`
table	New Table		`EVENT`
`EVENT_METADATA`
table	New Table		`EVENT_METADATA`
`EVENT_WEBHOOK`
table	New Table		`EVENT_WEBHOOK`
`GIFT_TIMELINE`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`gift_id`	`gift_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`HOSTED_PAGE`
column	New Column		`business_entity_id`
`INVOICE`
column	New Column		`einvoice_reference_number`
column	New Column		`local_currency_exchange_rate`
column	New Column		`site_details_at_creation_organization_address_city`
column	New Column		`site_details_at_creation_organization_address_country_code`
column	New Column		`site_details_at_creation_organization_address_line_1`
column	New Column		`site_details_at_creation_organization_address_state`
column	New Column		`site_details_at_creation_organization_address_zip`
column	New Column		`site_details_at_creation_organization_email`
column	New Column		`site_details_at_creation_organization_name`
column	New Column		`site_details_at_creation_organization_phone`
column	New Column		`site_details_at_creation_organization_website`
column	New Column		`site_details_at_creation_timezone`
column	New Column		`statement_descriptor`
column	New Column		`statement_descriptor_id`
column	New Column		`tax_category`
column	New Column		`tax_origin_country`
column	New Column		`tax_origin_registration_number`
`INVOICE_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_DUNNING_ATTEMPT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM`
table	New Table
`INVOICE_LINE_ITEM_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_LINE_ITEM_TAX`
table	New Table
`INVOICE_NOTE`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`INVOICE_TAX`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`invoice_id`	`invoice_id` 🔑	Added to primary key.
column	Primary Key Change	`invoice_updated_at`	`invoice_updated_at` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`LINE_ITEM`
table	Discontinued Table	`LINE_ITEM`		Data is available in the `INVOICE_LINE_ITEM`, `QUOTE_LINE_ITEM`, and `CREDIT_NOTE_LINE_ITEM` tables.
`LINE_ITEM_TAX`
table	Discontinued Table	`LINE_ITEM_TAX`		Data is available in the `INVOICE_LINE_ITEM_TAX`, `CREDIT_NOTE_LINE_ITEM_TAX`, `QUOTE_LINE_ITEM_TAX`, and `ORDER_LINE_ITEM_TAX` tables.
`ORDER_LINE_ITEM_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`order_id`	`order_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`ORDER_LINE_ITEM_TAX`
table	New Table	`_FIVETRAN_ID` 🔑		No longer a primary key.
`PAYMENT_SOURCE`
column	New Column		`bank_account_direct_debit_scheme`
column	New Column		`boleto_email`
column	New Column		`boleto_first_name`
column	New Column		`boleto_last_4`
column	New Column		`boleto_last_name`
column	New Column		`klarna_pay_now_email`
column	New Column		`venmo_user_name`
`PLAN_TAX_PROVIDER_FIELD`
table	New Table		`PLAN_TAX_PROVIDER_FIELD`
`PLAN_TIER`
table	New Table		`PLAN_TIER`
`QUOTE_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM`
table	New Table
`QUOTE_LINE_ITEM_DISCOUNT`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_LINE_ITEM_TAX`
table	New Table
`QUOTE_LINE_ITEM_TIER`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`QUOTE_TAX`
column	Discontinued Column	`_fivetran_id` 🔑		No longer a primary key.
column	Primary Key Change	`quote_id`	`quote_id` 🔑	Added to primary key.
column	Primary Key Change		`index` 🔑	New primary key.
`SUBSCRIPTION`
column	New Column		`contract_term_total_contract_value_before_tax`
`TIER`
table	Discontinued Table	`TIER`		Data is available in the `UNBILLED_CHARGE_TIER`, `ADDON_TIER`, and `PLAN_TIER` tables.
`TRANSACTION`
column	New Column		`custom_payment_method_id`
column	New Column		`custom_payment_method_name`
column	New Column		`error_cause_customer_message`
column	New Column		`error_cause_id`
column	New Column		`error_cause_merchant_message`
column	New Column		`error_detail_decline_code`
column	New Column		`error_detail_decline_message`
column	New Column		`error_detail_error_category`
column	New Column		`error_detail_error_code`
column	New Column		`error_detail_error_field`
column	New Column		`error_detail_error_message`
column	New Column		`error_detail_network_error_code`
column	New Column		`error_detail_network_error_message`
column	New Column		`error_detail_processor_error_code`
column	New Column		`error_detail_processor_error_message`
column	New Column		`error_detail_recommendation_code`
column	New Column		`error_detail_recommendation_message`
column	New Column		`error_detail_request_id`
`UNBILLED_CHARGE_TIER`
table	New Table		`UNBILLED_CHARGE_TIER`

Docebo

Effective January 29, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to enhance its usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`ROOT_CATEGORY`
table	New Table			`ROOT_CATEGORY`

Factbird

Effective January 15, 2025 we use a new January 2025 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.

4 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`OEE`
column	Primary Key Change	`_fivetran_id` 🔑	`_fivetran_id` 🔑	Primary key calculation change.
column	New Column		`consolidated_time_from`
column	New Column		`consolidated_time_to`
`SENSOR_GROUP`
column	Discontinued Column	`external_id`

Freshchat

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

We are updating the connector schema to enhance its usability.

3 total changes • 0 possible breaking changes

Table/column	Change type	New name
`CONVERSATION_METRICS`
table	New Table	`CONVERSATION_METRICS`
`CSAT_METRICS`
table	New Table	`CSAT_METRICS`
`TEAM_PERFORMANCE_METRICS`
table	New Table	`TEAM_PERFORMANCE_METRICS`

Genesys

Effective January 29, 2025 we use a new January 2025 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.

38 total changes • 24 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`AGENT_ACTIVITY`
table	New Table		`AGENT_ACTIVITY`
`ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DATA_METRIC`
table	New Table		`ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DATA_METRIC`
`ANALYTICS_CONVERSATION_DETAILS`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS` table.
`ANALYTICS_CONVERSATION_DETAILS_DIVISION`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_DIVISION`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_DIVISION` table.
`ANALYTICS_CONVERSATION_DETAILS_EVALUATION`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_EVALUATION`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_EVALUATION` table.
`ANALYTICS_CONVERSATION_DETAILS_KNOWLEDGE_BASE_ID`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_KNOWLEDGE_BASE_ID`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_KNOWLEDGE_BASE_ID` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_AGENT_GROUP`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_AGENT_GROUP`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_AGENT_GROUP` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_BCC`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_BCC`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_BCC` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_CALLBACK_NUMBER`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_CALLBACK_NUMBER`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_CALLBACK_NUMBER` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_CC`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_CC`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_CC` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_DESTINATION_ADDRESS`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_DESTINATION_ADDRESS`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_DESTINATION_ADDRESS` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_ELIGIBLE_AGENT_COUNT`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_ELIGIBLE_AGENT_COUNT`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_ELIGIBLE_AGENT_COUNT` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_FLOW_OUTCOME`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_FLOW_OUTCOME`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_FLOW_OUTCOME` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_MEDIA_ENDPOINT_STATS`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_MEDIA_ENDPOINT_STATS`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_MEDIA_ENDPOINT_STATS` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_METRIC`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_METRIC`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_METRIC` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_PROPOSED_AGENT`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_PROPOSED_AGENT`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_PROPOSED_AGENT` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_REQUESTED_ROUTING`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_REQUESTED_ROUTING`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_REQUESTED_ROUTING` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_SEGMENT`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_SEGMENT`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_SEGMENT` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_SKILL_ID`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_SKILL_ID`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_SKILL_ID` table.
`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_WAITING_INTERACTION_COUNTS`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_PARTICIPANT_SESSION_WAITING_INTERACTION_COUNTS`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_PARTICIPANT_SESSION_WAITING_INTERACTION_COUNTS` table.
`ANALYTICS_CONVERSATION_DETAILS_RESOLUTION`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_RESOLUTION`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_RESOLUTION` table.
`ANALYTICS_CONVERSATION_DETAILS_SURVEY`
table	Discontinued Table	`ANALYTICS_CONVERSATION_DETAILS_SURVEY`		Data is available in the `ANALYTICS_CONVERSATION_AGGREGATE_QUERY_DETAILS_SURVEY` table.
`ANALYTICS_USERS_DETAIL`
table	New Table		`ANALYTIC_USER_DETAIL`
`CALIBRATION`
table	New Table		`CALIBRATION`
`CONTACT_LIST_FILTER_CLAUSE_PREDICATE`
column	Renaming Column	`column_`	`column_name`
`CONVERSATION_PARTICIPANT_ATTRIBUTE`
table	New Table		`CONVERSATION_PARTICIPANT_ATTRIBUTE`
`CONVERSATION_SURVEY`
table	New Table		`CONVERSATION_SURVEY`
`EVALUATION`
table	New Table		`EVALUATION`
`EVALUATION_FORM`
table	New Table		`EVALUATION_FORM`
`EVENT`
column	Renaming Column	`timestamp_`	`time_stamp`
`EXTERNAL_CONTACT`
table	New Table		`EXTERNAL_CONTACT`
`ORGANIZATION`
table	New Table		`ORGANIZATION`
`PRESENCE_DEFINITION`
table	New Table		`PRESENCE_DEFINITION`
`ROUTING_SKILL`
table	New Table		`ROUTING_SKILL`
`SURVEY_FORM`
table	New Table		`SURVEY_FORM`
`TASK_MANAGEMENT_WORKITEM`
table	New Table		`TASK_MANAGEMENT_WORKITEM`

GitHub

We have added a new table, COMMIT_STATUS to support Commit statuses. We are gradually rolling out this change to all existing connections.

We have added a new table, COMMIT_CHECK_RUN to support Check runs. We are gradually rolling out this change to all existing connections.

Guru

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

We are updating the connector schema to improve 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
`EVENT`
column	Rename Column		`user`	`user_email`

Jira

We have added a new table, ISSUE_PROPERTY, with the following columns:

issue_id
key
self
value

We have added a new table, WORKLOG_PROPERTY, with the following columns:

worklog_id
key
self
value

We have added a new column, driver, to the VERSION table.

We have added a new column, simplified, to the PROJECT table.

We have added a new table, ATTACHMENT_METADATA, with the following columns:

attachment_id
index
label
media_type
path
size

LearnUpon

Effective January 13, 2025 we use a new January 2025 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.

17 total changes • 5 possible breaking changes

Table/column	Change type	Old name	New name
`COURSE`
column	New Column		`thumbnail_image_url`
`COURSE_INSTRUCTOR`
column	New Column		`created_at`
`ENROLLMENT`
column	New Column		`from_catalog`
column	New Column		`from_store`
column	New Column		`group_id`
column	New Column		`is_overdue`
column	New Column		`updated_at`
`GROUP_INVITIE`
column	New Column		`accept_url`
`GROUP_MEMBERSHIP`
column	Discontinued Column	`group_id`
column	Rename Column	`groups_id` 🔑	`group_id` 🔑
`LEARNING_PATH`
column	New Column		`thumbnail_image_url`
`MODULE`
column	New Column		`sequence`
`USER_CUSTOM_DATA`
column	Rename Column	`users_id` 🔑	`user_id` 🔑
`USER_CUSTOM_DATA_FIELD_VALUE`
column	Discontinued Column	`id`
column	Rename Column	`users_id` 🔑	`user_id` 🔑
`USERS`
column	New Column		`timezone_id`
column	New Column		`updated_at`

Medallia Agile Research

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

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

5 total changes • 0 possible breaking changes

Table/column	Change type	New name
`SURVEY_RESPONDENT_RESPONSE`
column	New Column	`data_label`
column	New Column	`response_caption`
column	New Column	`scale_value`
column	New Column	`score`
column	New Column	`value`

NetSuite SuiteAnalytics

For the Netsuite.com data source, we have changed the primary key of the SUBSCRIPTION_LINE_REVISIONS table. The subscription_line_id column is the new primary key for this table. Previously, the primary key was change_order_id.

Partnerize

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

We are updating the connector schema to adhere to standard naming conventions.

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
`CAMPAIGN_TRANSACTION`
column	Rename Column	`created_by`	`publisher_created_by`
column	Rename Column	`reporting_timezone`	`publisher_reporting_timezone`

Pingdom

Effective January 16, 2025 we use a new January 2025 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
`RESULT`
column	Primary Key Change			`checks_id` 🔑	New primary key.

PostHog

Effective January 29, 2025 we use a new January 2025 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.

4 total changes • 4 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`COHORT_GROUP`
table	Discontinued Table	`COHORT_GROUP`		Data is available in the `group` column of the `COHORT` table.
`EVENT`
column	Rename Column	`timestamp`	`time_stamp`
`INSIGHT`
column	Rename Column	`order` 🔑	`orders` 🔑
`INSIGHT_TAG`
column	Rename Column	`tag` 🔑	`tags` 🔑

Resource Management by Smartsheet

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

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

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`TIME_ENTRY`
column	New Column			`bill_rate`

Rocketlane

Effective January 30, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

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

2 total changes • 0 possible breaking changes

Table/column	Change type	New name
`PROJECT`
column	New Column	`customer_company_name`
column	New Column	`customer_company_url`

Rollbar

Effective January 6, 2025 we use a new January 2025 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.

6 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ITEM_OCCURRENCE`
table	New Table		`ITEM_OCCURRENCE`
`OCCURRENCE`
table	Discontinued Table	`OCCURRENCE`		Data is available in the `ITEM_OCCURRENCE` and `PROJECT_OCCURRENCE` tables.
`PROJECT_AI`
table	New Table		`PROJECT_AI`
`PROJECT_GLOBAL`
table	New Table		`PROJECT_GLOBAL`
`PROJECT_GLOBAL_AI`
table	Discontinued Table	`PROJECT_GLOBAL_AI`		Data is available in the `PROJECT_AI` and `PROJECT_GLOBAL` tables.
`PROJECT_OCCURRENCE`
table	New Table		`PROJECT_OCCURRENCE`

Rootly

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

January 21, 2025: Migration window begins. Additions and Phase 1 changes take effect. You can manually start the update in your Fivetran dashboard.

February 21, 2025: Migration window closes. If you haven't already started the update manually, Fivetran will apply the remaining changes automatically.

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.

37 total changes • 10 possible breaking changes

Table/column	Change type	Old name	New name	Notes
`ACTION_ITEM_NOTIFY_EMAIL`
table	New Table		`ACTION_ITEM_NOTIFY_EMAIL`
`ENVIRONMENT_NOTIFY_EMAIL`
table	New Table		`ENVIRONMENT_NOTIFY_EMAIL`
`ENVIRONMENT_SLACK_ALIAS`
table	New Table		`ENVIRONMENT_SLACK_ALIAS`
`ENVIRONMENT_SLACK_CHANNEL`
table	New Table		`ENVIRONMENT_SLACK_CHANNEL`
`FORM_FIELD_OPTION`
column	Rename Column	`defaults`	`is_default`
`FORM_FIELD_SELECTION_OPTION`
column	Rename Column	`defaults`	`is_default`
`FUNCTIONALITY_ENVIRONMENT`
table	New Table		`FUNCTIONALITY_ENVIRONMENT`
`FUNCTIONALITY_NOTIFY_EMAIL`
table	New Table		`FUNCTIONALITY_NOTIFY_EMAIL`
`FUNCTIONALITY_OWNER_TEAM`
table	New Table		`FUNCTIONALITY_OWNER_TEAM`
`FUNCTIONALITY_OWNER_USER`
table	New Table		`FUNCTIONALITY_OWNER_USER`
`FUNCTIONALITY_SERVICE`
table	Discontinued Table	`FUNCTIONALITY_SERVICE`		Data is available in the `SERVICE_DEPENDENT_ID` and `FUNCTIONALITY_SERVICE_ID` tables.
`FUNCTIONALITY_SERVICE_ID`
table	New Table		`FUNCTIONALITY_SERVICE_ID`
`FUNCTIONALITY_SLACK_ALIAS`
table	New Table		`FUNCTIONALITY_SLACK_ALIAS`
`FUNCTIONALITY_SLACK_CHANNEL`
table	New Table		`FUNCTIONALITY_SLACK_CHANNEL`
`INCIDENT_TYPE_NOTIFY_EMAIL`
table	New Table		`INCIDENT_TYPE_NOTIFY_EMAIL`
`INCIDENT_TYPE_SLACK_ALIAS`
table	New Table		`INCIDENT_TYPE_SLACK_ALIAS`
`INCIDENT_TYPE_SLACK_CHANNEL`
table	New Table		`INCIDENT_TYPE_SLACK_CHANNEL`
`NOTIFY_EMAIL`
table	Discontinued Table	`NOTIFY_EMAIL`		Data is available in the `SEVERITY_NOTIFY_EMAIL`, `INCIDENT_TYPE_NOTIFY_EMAIL`, `ENVIRONMENT_NOTIFY_EMAIL`, `SERVICE_NOTIFY_EMAIL`, `FUNCTIONALITY_NOTIFY_EMAIL`, `TEAM_NOTIFY_EMAIL`, and `ACTION_ITEM_NOTIFY_EMAIL`tables.
`OWNER_TEAM`
table	Discontinued Table	`OWNER_TEAM`		Data is available in the `SERVICE_OWNER_TEAM` and `FUNCTIONALITY_OWNER_TEAM` tables.
`OWNER_USER`
table	Discontinued Table	`OWNER_USER`		Data is available in the `SERVICE_OWNER_USER` and `FUNCTIONALITY_OWNER_USER` tables.
`POST_MORTEM_TEMPLATE`
column	Rename Column	`defaults`	`is_default`
`SERVICE_DEPENDENT_ID`
table	New Table		`SERVICE_DEPENDENT_ID`
`SERVICE_ENVIRONMENT`
table	New Table		`SERVICE_ENVIRONMENT`
`SERVICE_FUNCTIONALITY_ENVIRONMENT`
table	Discontinued Table	`SERVICE_FUNCTIONALITY_ENVIRONMENT`		Data is available in the `SERVICE_ENVIRONMENT` and `FUNCTIONALITY_ENVIRONMENT` tables.
`SERVICE_NOTIFY_EMAIL`
table	New Table		`SERVICE_NOTIFY_EMAIL`
`SERVICE_OWNER_TEAM`
table	New Table		`SERVICE_OWNER_TEAM`
`SERVICE_OWNER_USER`
table	New Table		`SERVICE_OWNER_USER`
`SERVICE_SLACK_ALIAS`
table	New Table		`SERVICE_SLACK_ALIAS`
`SERVICE_SLACK_CHANNEL`
table	New Table		`SERVICE_SLACK_CHANNEL`
`SEVERITY_NOTIFY_EMAIL`
table	New Table		`SEVERITY_NOTIFY_EMAIL`
`SEVERITY_SLACK_ALIAS`
table	New Table		`SEVERITY_SLACK_ALIAS`
`SEVERITY_SLACK_CHANNEL`
table	New Table		`SEVERITY_SLACK_CHANNEL`
`SLACK_ALIAS`
table	Discontinued Table	`SLACK_ALIAS`		Data is available in the `SEVERITY_SLACK_ALIAS`, `INCIDENT_TYPE_SLACK_ALIAS`, `ENVIRONMENT_SLACK_ALIAS`, `SERVICE_SLACK_ALIAS`, `FUNCTIONALITY_SLACK_ALIAS`, and `TEAM_SLACK_ALIAS`tables.
`SLACK_CHANNEL`
table	Discontinued Table	`SLACK_CHANNEL`		Data is available in the `SEVERITY_SLACK_CHANNEL`, `INCIDENT_TYPE_SLACK_CHANNEL`, `ENVIRONMENT_SLACK_CHANNEL`, `SERVICE_SLACK_CHANNEL`, `FUNCTIONALITY_SLACK_CHANNEL`, and `TEAM_SLACK_CHANNEL`tables.
`TEAM_NOTIFY_EMAIL`
table	New Table		`TEAM_NOTIFY_EMAIL`
`TEAM_SLACK_ALIAS`
table	New Table		`TEAM_SLACK_ALIAS`
`TEAM_SLACK_CHANNEL`
table	New Table		`TEAM_SLACK_CHANNEL`

Shopify

We have added a new column, order_line_id, to the RETURN_LINE_ITEM table.

We have added a new table, RETURN_SHIPPING_FEE. Previously, we synced the data to the return_shipping_fees column of the RETURN table. We are gradually rolling out this change to all existing connections.

We have migrated from REST API to GraphQL for the ORDER_RISK endpoint to align with the Shopify API changes. For more information, see the Shopify documentation. As part of this migration, we have made the following schema changes:

We have added the following new tables:

ORDER_RISK_FACT
ORDER_RISK_ASSESSMENT
ORDER_RISK_SUMMARY

You need to perform a re-sync to backfill historical data for the new tables. We are gradually rolling out this change to all existing connections.

We have migrated from REST API to GraphQL for the PRODUCT endpoint to align with the Shopify API changes. For more information, see the Shopify documentation. As part of this migration, we have made the following schema changes:

We have added the following new columns to the PRODUCT table:
- compare_at_price_range_*
- description
- description_html
- featured_media_id
- gift_card_template_suffix
- has_only_default_variant
- has_out_of_stock_variants
- has_variants_that_requires_components
- is_gift_card
- legacy_resource_id
- online_store_preview_url
- max_variant_price_amount
- max_variant_price_currency_code
- min_variant_price_amount
- min_variant_price_currency_code
- requires_selling_plan
- seo_description
- seo_title
- total_inventory
- tracks_inventory
We have removed the following columns from the PRODUCT table:
- body_html
- published_scope
We have added the linked_metafield_key and linked_metafield_namespace columns to the PRODUCT_OPTION table.
We have added the following new columns to the PRODUCT_VARIANT table:
- available_for_sale
- display_name
- legacy_resource_id
- requires_components
- sellable_online_quantity
We have removed the following columns from the PRODUCT_VARIANT table:
- fulfillment_service
- grams
- inventory_management
- inventory_quantity_management
- inventory_quantity_adjustment
- old_inventory_quantity
- option_*
- presentment_prices
- requires_shipping
- weight
- weight_unit
We have added the following new columns to the PRODUCT_IMAGE table:
- alt_text
- media_id
- status
- url
We have removed the following columns from the PRODUCT_IMAGE table:
- alt
- created_at
- is_default
- position
- src
- updated_at
- variant_ids
We have added the following new columns to the INVENTORY_ITEM table:
- duplicate_sku_count
- harmonized_system_code
- inventory_history_url
- legacy_resource_id
- measurement_id
- measurement_weight_value
- measurement_weight_unit
- tracked_editable_locked
- tracked_editable_reason
- unit_cost_amount
- unit_cost_currency_code
We have removed the cost column from the INVENTORY_ITEM table.
We have added the following new columns to the INVENTORY_LEVEL table:
- can_deactivate
- created_at
- deactivation_alert
- id
We have removed the available column from the INVENTORY_LEVEL table.
We have three new tables, PRODUCT_OPTION_VALUE, PRODUCT_VARIANT_OPTION_VALUE and INVENTORY_QUANTITY.

You must perform a re-sync to backfill historical data for the new columns. We are gradually rolling out this change to all existing connections.

We have changed the data type of the published_at column of the PRODUCT table from STRING to TIMESTAMP. To apply this change, you must drop the published_at column in your connection schema. We update the datatype in the next sync. You must perform a re-sync if you need to backfill the historical data for this column.

SkuVault

Effective January 29, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to adhere to standard naming conventions.

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
`TRANSACTION`
column	Rename Column		`user`	`username`

Trello

Effective January 14, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes.

We are updating the connector schema to improve 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.

2 total changes • 2 possible breaking changes

Table/column	Change type	Old name	New name
`BOARD_CUSTOM_FIELD`
column	Rename Column	`pos`	`position`
`BOARD_CUSTOM_FIELD_OPTION`
column	Rename Column	`pos`	`position`

UKG Pro

Effective January 28, 2025 we use a new January 2025 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
`ORGANIZATION_LEVEL`
column	Primary Key Change		`level`	`level` 🔑	Added to primary key.

Workday Financial Management

We have added a new column, currency_rate_type_code, to the CURRENCY_CONVERSION_RATE table.

Zip

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

We are updating the connector schema to enhance its usability.

1 total changes • 0 possible breaking changes

Table/column	Change type		Old name	New name	Notes
`REQUEST`
column	New Column			`amount_usd`

Improvements

Airtable

Effective January 5, 2025, the Fivetran REST API no longer supports the base_id and table_name configuration parameters for Airtable connections. We will sunset these parameters on April 5, 2025.

We are introducing changes to our History mode feature to prevent data loss during re-syncs. Effective January 15, 2025, the Last Modified Time field must be present in all source tables that have history mode enabled.

Algolia

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Amazon S3

Our Amazon S3 connector now supports syncing Microsoft Excel spreadsheets. For more information, see our Amazon S3 documentation.

Amazon Selling Partner

We have resolved an issue that caused the following tables to not sync correctly:

LISTED_ITEM_ISSUE
LISTED_ITEM_OFFERS
ITEM_FULFILLMENT_AVAILABILITY

Apple Search Ads

We have upgraded our Apple Search Ads connector from v4 to v5 of the Apple Search Ads API. For more information about the changes, see the Apple Search Ads API changelog.

Attio

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Azure Data Lake Storage

We now clean up the removed files while deleting the old snapshots for the delta lake table format in the destination. For more information, see our Azure Data Lake Storage documentation.

Bitly

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

Canvas by Instructure

We have changed our sync strategy and now re-import the COURSE table and its child tables once a week to capture updates and deletes.

Chargebee Product Catalog 1.0

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Clari

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

ClickUp

We have added support for table re-sync. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source do not support this feature.

Confluence

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Data lake table maintenance operations

We have enhanced our table maintenance operations for the Azure Data Lake Storage, OneLake, and S3 Data Lake destinations to optimize data storage efficiency. You can now configure these operations to delete table snapshots older than 1 day, allowing for more frequent cleanup of outdated data. To support this improvement, we have added a new option, 1 Day, to the Snapshot Retention Period drop-down menu in the destination setup forms. By selecting this option, table maintenance operations will automatically delete snapshots older than 1 day, ensuring an efficient storage environment.

Docebo

We have changed our sync strategy and now re-import the COURSE table and its child tables during each sync to capture updates and deletes.

Facebook Ads

The Facebook Ads connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Facebook Ads' priority-first syncs fetch the most recent thirty days' worth of data from the pre-build and custom reporting tables.

To learn more, see our priority-first sync documentation.

File connectors

We have renamed the Folder Path field to Base folder path in the following connection setup forms:

This improvement is applicable for new connections created on or after January 2, 2025. We are gradually rolling out this change to all existing connections.

Google Ad Manager

We've upgraded our Google Ad Manager connector from version 202402 to 202411 of the Google Ad Manager API. As part of the upgrade, we have:

Removed the following columns:
- AD_SERVER_CPA_REVENUE
- CLICK_THROUGH_CONVERSIONS
- CLICK_THROUGH_REVENUE
- CONVERSIONS_PER_CLICK
- CONVERSIONS_PER_THOUSAND_IMPRESSIONS
- TOTAL_CONVERSIONS
- total_conversionTOTAL_CONVERSION_REVENUE_revenue
- VIEW_THROUGH_CONVERSIONS
- VIEW_THROUGH_REVENUE
Removed the following dimensions:
- ACTIVITY_GROUP_ID
- ACTIVITY_GROUP_NAME
- ACTIVITY_ID
- ACTIVITY_NAME
- VIDEO_METADATA_KEY_ID
- VIDEO_METADATA_KEY_NAME
- VIDEO_PLACEMENT_NAME
Added new columns:
- ACTIVE_VIEW_PERCENT_AUDIBLE_START_IMPRESSIONS
- ACTIVE_VIEW_PERCENT_EVER_AUDIBLE_IMPRESSIONS
Added new dimensions:
- INVENTORY_FORMAT
- INVENTORY_FORMAT_NAME
- VIDEO_PLCMT_ID
- VIDEO_PLCMT_NAME

See Google's Ad Manager API release notes to learn more about the changes.

Google Analytics 4

The Google Analytics 4 connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Google Drive

We have renamed the Folder URL field to Base folder URL in the connection setup form. New connections created on or after January 2, 2025, will have this change.

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

Google Play

You can now authenticate using Fivetran's or your own service account. For more information, see our setup instructions. We are gradually rolling out this improvement to all existing connections.

Gorgias

We have updated our sync strategy and now re-import the following tables and their child tables monthly to capture deletes:

TICKET
MACRO
CUSTOMER

Previously, we re-imported these tables weekly.

Greenhouse

We have changed our sync strategy and now re-import the USERS table and its child tables once a day to capture updates.

High-Volume Agent Db2 for i

The High-Volume Agent Db2 for i connector now supports the Hybrid Deployment model. For more information, see our High-Volume Agent Db2 for i setup guide.

History mode support

History mode is now generally available for the following destinations:

Hopin

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

iLevel

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Katana

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Lattice

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Loop

We have observed that sometimes, the exchange_variant column in the RETURN_CANCELLED_LINE_ITEM table is empty. We now update the column's value to Not Exchange so that it appears in your destination.

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

We’ve fixed an issue where the exchange_variant column in the RETURN_CANCELLED_LINE_ITEM table was missing from the destination due to empty string values. We now replace these empty strings with Not Exchange.

Mailgun

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

MySQL

We now support MySQL version 8.4.

NetSuite SuiteAnalytics

The NetSuite SuiteAnalytics connector now supports OAuth 2.0 authentication for the Netsuite2.com data source. For more information, see our setup instructions.

OneLake

We now clean up the removed files while deleting the old snapshots for the delta lake table format in the destination. For more information, see our OneLake documentation.

Pipedrive

We retrieve data only from the past 30 days for the following tables due to a change in the Recents endpoint in Pipedrive:

ACTIVITY
ACTIVITY_TYPE
FILE
NOTE
ORGANIZATION
PERSON
PIPELINE
STAGE
DEAL
PRODUCT
FILTER
USER

To maintain data integrity, we automatically re-sync these tables if they remain deselected for more than 30 days or if the connection is paused for over 30 days. We only re-sync when you select the tables again or unpause the connection.

RetailNext

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Retently

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Rithum

We have changed our sync strategy and now incrementally sync the ORDERS and PRODUCT tables. We have also updated the historical sync limit for these tables to 2020-01-01.

To improve sync performance, we now sync the ORDER_ITEM table as a child of the ORDERS table. As a result, you can no longer select or deselect the ORDER_ITEM table in Schema tab of the connection details page.

Rollbar

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Rootly

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

S3 Data Lake

We now clean up the removed files while deleting the old snapshots for the delta lake table format in the destination. For more information, see table maintenance operations.

Salesforce

We have introduced a new authentication method, Mutual TLS (mTLS), to connect your Salesforce account to Fivetran. For more information, see our Mutual Authentication documentation for detailed instructions on how to enable this option.

This feature is in BETA and we are gradually rolling out this feature to all existing connections.

We have added the following new tables:

Tooling API Objects:
- EntityDefinition
- FieldDefinition
Other Objects:
- Announcement
- ContentFolderItem
- ContentFolderMember
- IdeaComment
- Vote

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

Salesforce Marketing Cloud

The Salesforce Marketing Cloud connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

Samsara

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

SAP ERP on HANA

We added support for applying filters to tables. The feature allows you to replicate a smaller, more restricted set of your data. For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.

SFTP

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

Shopify

We have added a new field, Historical sync time frame, to the connection setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connection, you can edit the connection details and set the time frame value. For more information, see our Shopify connector historical sync time frame documentation.

This feature is applicable for connections created after January 30, 2025.

We apply the historical sync limit to the following tables:

ABANDONED_CHECKOUT
ABANDONED_CHECKOUT_LINE
ABANDONED_CHECKOUT_SHIPPING_LINE
ABANDONED_CHECKOUT_DISCOUNT_CODE
ABANDONED_CHECKOUT
ABANDONED_CHECKOUT_TAX_LINE
ABANDONED_APPLIED_DISCOUNT
APPLIED_GIFT_CARD
ABANDONED_CHECKOUT_URL_TAG
CUSTOMER_VISIT
DRAFT_ORDER
DRAFT_ORDER_LINE
DRAFT_ORDER_LINE_TAX_LINE
DRAFT_ORDER_NOTE_ATTRIBUTE
DRAFT_ORDER_TAG
ORDER
ORDER_RISK
ORDER_LINE
ORDER_DISCOUNT_CODE
TRANSACTION
REFUND
ORDER_ADJUSTMENT
FULFILLMENT_EVENT
FULFILLMENT
ORDER_LINE_REFUND
FULFILLMENT_ORDER_LINE
TAX_LINE
DISCOUNT_ALLOCATION
ORDER_SHIPPING_TAX_LINE
ORDER_SHIPPING_LINE
ORDER_NOTE_ATTRIBUTE
ORDER_TAG
ORDER_URL_TAG
DISCOUNT_APPLICATION
FULFILLMENT_ORDER
FULFILLMENT_ORDER_LINE_ITEM
FULFILLMENT_ORDER_FULFILLMENT_HOLD
TENDER_TRANSACTION

SQL Server

We now support automatically enabling Change Tracking (CT) or Change Data Capture (CDC) for new tables and updating CDC capture instances for new columns.

TikTok Ads

The TikTok Ads connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

VWO

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Webhooks

We have introduced configurable authentication headers for Webhooks. For enhanced security, you can now use a source-specific header for HMAC signatures, specify the signature encoding format, use a source-specific header for secret tokens, and provide rotating secret keys. For more information, see our setup instructions and the REST API configuration parameters.

Workable

We have added table re-sync support. Previously, we only supported connection-level re-syncs.

Event-based tables and tables with a retention period at the source don't support this feature.

You can now select and deselect tables to be synced on the Schema tab of the connection details page in your Fivetran dashboard.

Xray

We now support the following Xray data residency regions:

Australia
EU
Global
USA

Previously, we supported only the Global region. We have added a new drop-down menu, Region, to the connector setup form. The drop-down menu allows you to select the Xray data residency regions. For more information, see our setup instructions.

YouTube Analytics

We've added the audience retention report for the videos uploaded within the last three months.

Zip

We now sync all active users in the USERS table. Previously, we synced only deactivated users.

REST API Improvements

Azure Service Bus

We have updated the connection methods for configuring the Azure Service Bus connector via the REST API. We now use DIRECT, SSH_TUNNEL, and PRIVATE_LINK for configuration. Previously, we used direct, sshTunnel, and privateLink.

For more information, see our REST API configuration.

dbt and Quickstart Transformation resources deprecated

We have deprecated the dbt Transformation and Quickstart Transformation resources in our REST API. Use the Transformation Management resource instead.

January 2025

Connector SDK

Fivetran Connector SDK

fivetran-connector-sdk PyPI package

Dashboard Improvements

New Connection Schema Review Changes functionality

Hybrid Deployment

Lite Connectors

Source naming

Sunset PostgreSQL Versions

Transformations

Transformations for dbt Core

Updated dbt Quickstart packages

New connectors

CockroachDB

Schema changes

Apple App Store

Apple Search Ads

Assembled

Bitly

Centra

Chameleon

Chargebee Product Catalog 1.0

Docebo

Factbird

Freshchat

Genesys

GitHub

Guru

Jira

LearnUpon

Medallia Agile Research

NetSuite SuiteAnalytics

Partnerize

Pingdom

PostHog

Resource Management by Smartsheet

Rocketlane

Rollbar

Rootly

Shopify

SkuVault

Trello

UKG Pro

Workday Financial Management

Zip

Improvements

Airtable

Algolia

Amazon S3

Amazon Selling Partner

Apple Search Ads

Attio

Azure Data Lake Storage

Bitly

Canvas by Instructure

Chargebee Product Catalog 1.0

Clari

ClickUp

Confluence

Data lake table maintenance operations

Docebo

Facebook Ads

File connectors

Google Ad Manager

Google Analytics 4

Google Drive

Google Play

Gorgias

Greenhouse

High-Volume Agent Db2 for i

History mode support

Hopin

iLevel

Katana

Lattice

Loop

Mailgun

MySQL

NetSuite SuiteAnalytics

`fivetran-connector-sdk` PyPI package