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 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 any configuration details, and then later adding the configuration through the setup form.

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.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.

Lite Connectors

Lite connectors are now available for the following sources:

Sunset PostgreSQL Versions

We no longer support PostgreSQL database versions older than 9.1 as destinations. We now support only PostgreSQL version 9.1 or above. We have discontinued support for the older versions because the latest JDBC drivers have discontinued them. For more information, see 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:

Marketo to version 0.13.1
Netsuite to version 0.17.1
Qualtrics to version 0.3.0
Quickbooks to version 0.17.1
Servicenow to version 0.4.0
Shopify to version 0.15.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.

Assembled

Effective January 14, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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. Also, see our Schema Migrations article for more details.

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 making these schema changes to improve the schema 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`

Chameleon

Effective January 13, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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. Also, see our Schema Migrations article for more details.

We are making these schema changes to introduce feature enhancements and improve schema 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.

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`

Factbird

Effective January 15, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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. Also, see our Schema Migrations article for more details.

We have made these schema changes to improve schema 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`

GitHub

We now support Commit statuses in our GitHub connector. We are gradually rolling out this change to all existing connectors. We have added one new table:

COMMIT_STATUS table with the following columns:
- id
- commit_sha
- state
- description
- target_url
- context
- created_at
- updated_at

We now support Check runs in our GitHub connector. We are gradually rolling out this change to all existing connectors. We have added one new table:

COMMIT_CHECK_RUN table with the following columns:
- id
- commit_sha
- external_id
- name
- status
- conclusion
- started_at
- completed_at
- check_suite_id
- app_id
- app_name

Guru

Effective January 21, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

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 the driver column to the VERSION table.

We have added the simplified column to the PROJECT table.

LearnUpon

Effective January 13, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are updating the connector schema to support a new feature enhancement and improve schema 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. Also, see our Schema Migrations article for more details.

We are updating the connector schema to support a new 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 for 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. Also, see our Schema Migrations article for more details.

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. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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. Also, see our Schema Migrations article for more details.

We are updating the connector schema to introduce feature enhancements.

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. Also, see our Schema Migrations article for more details.

We have made this schema change to introduce 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`

Rollbar

Effective January 6, 2025 we use a new January 2025 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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. Also, see our Schema Migrations article for more details.

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 making these schema changes to improve the schema 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 migrated from REST API to GraphQL for the ORDER_RISK endpoint to align with Shopify’s updated standards. For more information, see Shopify's documentation. As part of this migration, we have made the following schema changes:

We have added the follow 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 connectors.

We have migrated from REST API to GraphQL for the PRODUCT endpoint to align with Shopify’s updated standards. For more information, see Shopify's 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 connectors.

We have changed the data type of the published_at column in the PRODUCT table from STRING to TIMESTAMP.

To apply this change, you must drop the published_at column in your connector's 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. Also, see our Schema Migrations article for more details.

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. Also, see our Schema Migrations article for more details.

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`

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. Also, see our Schema Migrations article for more details.

We are updating the connector schema to improve schema 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, our REST API no longer supports the base_id and table_name configuration parameters for Airtable connectors. We will sunset these parameters on April 5, 2025.

We are introducing changes to the Airtable connector’s history mode to prevent data loss during resyncs. Starting January 15, 2025, the Last Modified Time field must be present in all source tables that have history mode enabled.

Amazon Selling Partner

We have resolved an issue that caused the LISTED_ITEM_ISSUE, LISTED_ITEM_OFFERS, and ITEM_FULFILLMENT_AVAILABILITY tables to not sync correctly.

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.

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.

Bitly

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

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

Canvas by Instructure

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

ClickUp

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

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

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 these destination setup forms. By selecting this option, table maintenance operations will automatically delete snapshots older than 1 day, ensuring an efficient storage environment.

File connectors

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

New connectors created on or after January 2, 2025, will have this change. We are gradually rolling it out to all existing connectors.

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 connector setup form. New connectors created on or after January 2, 2025, will have this change.

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

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 connectors.

Gorgias

We now re-import the following tables and their child tables monthly to capture deletes:

TICKET
MACRO
CUSTOMER

Earlier, we re-imported these tables weekly.

Greenhouse

We now re-import the USERS table and its child tables once a day to capture updates.

Loop

If the exchange_variant column in the RETURN_CANCELLED_LINE_ITEM table is empty, we now update it to Not Exchange so that it is visible in your destination.

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 connector is paused for over 30 days. We only re-sync when you select the tables again or unpause the connector.

Rithum

We 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 the connector's Schema tab.

Rootly

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

NOTE: 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. 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 connectors.

We have added the following new tables to Salesforce connector. We roll them out gradually for all connections:

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

Salesforce Marketing Cloud

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

SAP ERP on HANA

We added support for applying filters to tables in the SAP ERP on HANA connector. This 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.

YouTube Analytics

The audience retention report is now available for videos uploaded within the last three months.

REST API Improvements

dbt Transformation 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

Support for multiple Python versions

External log services

Edit connection details

100 fields maximum in configuration.json

fivetran-connector-sdk PyPI package

Lite Connectors

Sunset PostgreSQL Versions

Transformations

Transformations for dbt Core

Updated dbt Quickstart packages

New connectors

CockroachDB

Schema changes

Apple App Store

Assembled

Bitly

Chameleon

Chargebee Product Catalog 1.0

Factbird

Freshchat

GitHub

Guru

Jira

LearnUpon

Medallia Agile Research

NetSuite SuiteAnalytics

Partnerize

Pingdom

PostHog

Resource Management by Smartsheet

Rollbar

Rootly

Shopify

SkuVault

Trello

Workday Financial Management

Zip

Improvements

Airtable

Amazon Selling Partner

Azure Data Lake Storage

Azure Service Bus

Bitly

Canvas by Instructure

ClickUp

Data lake table maintenance operations

File connectors

Google Analytics 4

Google Drive

Google Play

Gorgias

Greenhouse

Loop

MySQL

NetSuite SuiteAnalytics

OneLake

Pipedrive

Rithum

Rootly

S3 Data Lake

Salesforce

Salesforce Marketing Cloud

SAP ERP on HANA

SFTP

YouTube Analytics

REST API Improvements

dbt Transformation and Quickstart Transformation resources deprecated

`fivetran-connector-sdk` PyPI package