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.
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:
- Ashby
- Bing Webmaster Tools
- Canvas Data 2 by Instructure
- Centra
- Cloudbeds
- CloudTalk
- Cornerstone
- Deposco
- Donus
- G2
- Hilti On!Track
- Jama Software
- Khoros Marketing
- Leap CRM
- Qmatic Data Connect
- Quorum
- ShareASale
- Venminder
- Workleap Officevibe
- Zoho Inventory
New Connection Schema Review Changes Functionality
On the Connection Schema page, a new feature is now available for reviewing changes. When you make changes—such as selecting or deselecting schemas, tables, and columns or updating the sync mode—a pending changes actions bar appears at the bottom of the page.
Clicking the Review Changes button opens a panel on the right side of the screen. This panel groups all pending changes by schema and type, streamlining the review process.
Each change includes a View link that navigates to the corresponding update in the table.
Click Save changes to save and apply the schema changes.
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 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:
- Fivetran Platform Connector to version 1.11.0
- Marketo to version 0.13.1
- Mixpanel to version 0.11.0
- Netsuite 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 Fivetran's 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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACTIVITY | |||||
column | New Column | event_id |
Bitly
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
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
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ROOT_CATEGORY | |||||
table | New Table | ROOT_CATEGORY |
Factbird
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CONVERSATION_METRICS | |||||
table | New Table | CONVERSATION_METRICS | |||
CSAT_METRICS | |||||
table | New Table | CSAT_METRICS | |||
TEAM_PERFORMANCE_METRICS | |||||
table | New Table | TEAM_PERFORMANCE_METRICS |
Genesys
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 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
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 the driver
column to the VERSION
table.
We have added the simplified
column 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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CAMPAIGN_TRANSACTION | |||||
column | Rename Column | created_by | publisher_created_by | ||
column | Rename Column | reporting_timezone | publisher_reporting_timezone |
Pingdom
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
RESULT | |||||
column | Primary Key Change | checks_id 🔑 | New primary key. |
PostHog
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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
TIME_ENTRY | |||||
column | New Column | bill_rate |
Rocketlane
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PROJECT | |||||
column | New Column | customer_company_name | |||
column | New Column | customer_company_url |
Rollbar
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
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
. Earlier, we were syncing this data through the return_shipping_fees
field in the RETURN
table.
We are gradually rolling out this change to all existing connectors.
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
andlinked_metafield_namespace
columns to thePRODUCT_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 theINVENTORY_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 theINVENTORY_LEVEL
table.We have three new tables,
PRODUCT_OPTION_VALUE
,PRODUCT_VARIANT_OPTION_VALUE
andINVENTORY_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
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
TRANSACTION | |||||
column | Rename Column | user | username |
Trello
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BOARD_CUSTOM_FIELD | |||||
column | Rename Column | pos | position | ||
BOARD_CUSTOM_FIELD_OPTION | |||||
column | Rename Column | pos | position |
UKG Pro
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
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.
Algolia
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.
You can now select and deselect tables to be synced on the Schema tab of the connector 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 LISTED_ITEM_ISSUE
, LISTED_ITEM_OFFERS
, and ITEM_FULFILLMENT_AVAILABILITY
tables to not sync correctly.
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 Apple Search Ads API's changelog.
Attio
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.
You can now select and deselect tables to be synced on the Schema tab of the connector 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.
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.
Chargebee Product Catalog 1.0
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
Clari
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
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.
Confluence
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.
You can now select and deselect tables to be synced on the Schema tab of the connector 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 these destination setup forms. By selecting this option, table maintenance operations will automatically delete snapshots older than 1 day, ensuring an efficient storage environment.
Docebo
To capture updates and deletes, we now re-import the COURSE
table and its child tables during each sync.
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 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 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.
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 connector-level re-syncs.
NOTE: 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 connector details page in your Fivetran dashboard.
iLevel
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
Katana
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
Lattice
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
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.
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
Mailgun
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.
You can now select and deselect tables to be synced on the Schema tab of the connector 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 connector is paused for over 30 days. We only re-sync when you select the tables again or unpause the connector.
RetailNext
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
Retently
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
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.
Rollbar
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
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.
Samsara
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.
You can now select and deselect tables to be synced on the Schema tab of the connector details page in your Fivetran dashboard.
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.
Shopify
This Feature will be applicable for connectors created after 30th January 2025
We have added a new field, Historical sync time frame, to the connector setup form. This allows you to select how many months' worth of historical data you want to sync. For an existing connector, you can edit the connection details and set the time frame value. For more information, see our Shopify connector historical sync time frame documentation.
We apply the historical sync limit to the following tables only:
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 connector-level re-syncs.
NOTE: 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 connector 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 connector-level re-syncs.
NOTE: 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 connector details page in your Fivetran dashboard.
Xray
We now support the following Xray data residency regions:
Global
USA
EU
Australia
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.
This change applies to all connectors.
YouTube Analytics
The audience retention report is now available for 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
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.