July 2024
Hybrid Deployment
You can now use a local processing agent for multiple destinations within a Fivetran account. Previously, each local processing agent supported only one destination. To support this enhancement, the Agent name list in the destination setup form now displays the names of all the local processing agents associated with your Fivetran account.
Lite Connectors
Lite connectors are now available for the following sources:
Schema changes
Adyen
We have changed the data type of the merchantAccountCaptureDelay
column in the ACCOUNTCONFIG_REPORT
table from INT to STRING.
Assembled
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EVENT_CHANGE | |||||
column | New Column | old_event_type |
Buzzsprout
PODCAST
and EPISODE
tables that use reserved keywords.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EPISODE | |||||
column | Rename Column | explicit | explicits | ||
column | Rename Column | tag | tags | ||
PODCAST | |||||
column | Rename Column | explicit | explicits | ||
column | Rename Column | language | languages |
Care Quality Commission
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
LOCATION_GAC_SERVICE_TYPE | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
LOCATION_HISTORIC_OVERALL_KEY_QUESTION_RATING | |||||
column | Deprecated Column | location_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | location_historic_rating_index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_RATING | |||||
column | Primary Key Change | report_link_id 🔑 | report_link_id | No longer primary key | |
column | Primary Key Change | index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_SERVICE_KEY_QUESTION_RATING | |||||
column | Primary Key Change | location_historic_service_rating_index 🔑 | Part of composite primary key | ||
LOCATION_HISTORIC_SERVICE_RATING | |||||
column | Deprecated Column | location_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | location_historic_rating_index 🔑 | Part of composite primary key | ||
LOCATION_REGULATED_ACTIVITY_CONTACT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_regulated_activity_code 🔑 | Part of new composite primary key | ||
LOCATION_REPORT_RELATED_DOCUMENT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | location_report_link_id 🔑 | Part of new composite primary key | ||
PROVIDER_CONTACT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_id 🔑 | Part of new composite primary key | ||
PROVIDER_HISTORIC_OVERALL_KEY_QUESTION_RATING | |||||
column | Deprecated Column | provider_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | provider_historic_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_RATING | |||||
column | Primary Key Change | report_link_id 🔑 | report_link_id | No longer primary key | |
column | Primary Key Change | index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_SERVICE_KEY_QUESTION_RATING | |||||
column | Primary Key Change | provider_historic_service_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_HISTORIC_SERVICE_RATING | |||||
column | Deprecated Column | provider_historic_rating_report_link_id 🔑 | |||
column | Primary Key Change | provider_historic_rating_index 🔑 | Part of composite primary key | ||
PROVIDER_REPORT_RELATED_DOCUMENT | |||||
column | Deprecated Column | _fivetran_id 🔑 | |||
column | Primary Key Change | index 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_id 🔑 | Part of new composite primary key | ||
column | Primary Key Change | provider_report_link_id 🔑 | Part of new composite primary key |
CircleCI
tag
columns in the PIPELINE
and WORKFLOW
tables use a reserved keyword.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PIPELINE | |||||
column | Rename Column | tag | tags | ||
WORKFLOW | |||||
column | Rename Column | tag | tags |
Facebook Ads
We have added a new column, picture
, to the AD_VIDEO_HISTORY
table.
Fivetran Platform Connector
We have made the following changes to the INCREMENTAL_MAR
table:
- Deprecated the
connector_id
column, which contains the connector name; - Added a new column,
connector_name
.
The ROLE
table has the connector_types
column, which creates a many-to-many relationship between the CONNECTOR_TYPE
and ROLE
tables. We added a new bridge/join table, role_connector_type
that has the connector_type
and role_id
columns to make this relationship more intuitive.
We have added a new column, connector_id
, to the RESOURCE MEMBERSHIP
table. It contains the connector ID (like the existing integration_id
column). Existing connectors now have both columns, connector_id
and integration_id
, while new connectors created after July 10, 2024 only have the connector_id
column.
The DESTINATION
table has the type
column, which contains the deployment type (Fivetran
or HVR
). For new connectors created after July 10, 2024 this column is replaced with the deployment_type
column.
See our Fivetran Platform Connector ERD for more information.
GitLab
commit_id
column being null
for some records.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PROJECT_BRANCH | |||||
column | Rename Column | default | defaults | ||
column | Primary Key Change | project_id 🔑 | project_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
PROJECT_BRANCH_PARENT_ID | |||||
column | Deprecated Column | project_branch_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_branch_fivetran_id 🔑 | Added to primary key. | ||
PROJECT_JOB | |||||
column | Rename Column | tag | tags | ||
PROJECT_RELEASE_ASSET_LINK | |||||
column | Deprecated Column | project_release_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_release_fivetran_id 🔑 | Added to primary key. | ||
PROJECT_RELEASE_ASSET_SOURCE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | project_release_commit_id 🔑 | No longer primary key. | ||
column | New Column | project_release_fivetran_id | |||
PROJECT_RELEASE_EVIDENCE | |||||
column | Primary Key Change | _fivetran_id 🔑 | _fivetran_id 🔑 | We've changed the way we calculate the primary key. | |
column | Deprecated Column | project_release_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_release_fivetran_id 🔑 | Added to primary key. | ||
PROJECT_RELEASE_MILESTONE | |||||
column | Deprecated Column | project_release_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_release_fivetran_id 🔑 | Added to primary key. | ||
PROJECT_RELEASE_PARENT_ID | |||||
column | Deprecated Column | project_release_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_release_fivetran_id 🔑 | Added to primary key. | ||
PROJECT_REPO_TAG | |||||
column | Primary Key Change | project_id 🔑 | project_id | No longer primary key. | |
column | Primary Key Change | _fivetran_id 🔑 | New primary key. | ||
PROJECT_REPO_TAG_PARENT_ID | |||||
column | Deprecated Column | project_repo_tag_commit_id 🔑 | No longer primary key. | ||
column | Primary Key Change | project_repo_tag_fivetran_id 🔑 | Added to primary key. |
Gorgias
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
TICKET_CUSTOM_FIELD | |||||
table | New Table |
GRIN
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
CAMPAIGN | |||||
table | New Table | CAMPAIGN | |||
CAMPAIGN_COMPENSATION | |||||
table | New Table | CAMPAIGN_COMPENSATION |
Jotform
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
TEAM | |||||
table | New Table | ||||
TEAM_ASSET | |||||
table | New Table | ||||
TEAM_MEMBER | |||||
table | New Table |
Mixmax
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
MEETING_TYPE_DAY | |||||
column | Deprecated Column | day | |||
column | Deprecated Column | enabled | |||
column | Deprecated Column | end_time | |||
column | Deprecated Column | index 🔑 | We now use the _fivetran_id column as the primary key. | ||
column | Deprecated Column | start_time |
Monday.com
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACTIVITY_LOG | |||||
column | Primary Key Change | board_id | board_id 🔑 | Added to primary key. | |
BOARD | |||||
column | Rename Column | permissions | permission | ||
COLUMN_VALUE | |||||
column | Deprecated Column | additional_info | No longer supported by the source app API. | ||
column | New Column | archived | |||
column | Primary Key Change | board_id 🔑 | Added to primary key. | ||
column | New Column | checked | |||
column | New Column | date | |||
column | New Column | description | |||
column | New Column | direction | |||
column | New Column | display_value | |||
column | New Column | duration | |||
column | New Column | from_date | |||
column | New Column | hour | |||
column | New Column | icon | |||
column | New Column | index | |||
column | New Column | is_done | |||
column | New Column | label | |||
column | New Column | label_style_border | |||
column | New Column | label_style_color | |||
column | New Column | minute | |||
column | New Column | number | |||
column | New Column | rating | |||
column | New Column | running | |||
column | New Column | settings_str | |||
column | New Column | started_at | |||
column | New Column | symbol | |||
column | New Column | time | |||
column | New Column | to_date | |||
column | New Column | update_id | |||
column | New Column | updated_at | |||
column | New Column | visualization_type | |||
column | New Column | width | |||
COLUMN_VALUE_ITEM_ID | |||||
table | New Table | COLUMN_VALUE_ITEM_ID | |||
COLUMN_VALUE_MIRROR_ITEM | |||||
table | New Table | COLUMN_VALUE_MIRROR_ITEM | |||
COLUMN_VALUE_TAG | |||||
table | New Table | COLUMN_VALUE_TAG | |||
ITEM_SUBSCRIBER | |||||
column | Primary Key Change | board_id 🔑 | Added to primary key. | ||
PERSON_TEAM | |||||
table | New Table | PERSON_TEAM | |||
REPLY | |||||
column | New Column | created_at | |||
TIME_TRACKING_HISTORY | |||||
column | Primary Key Change | board_id 🔑 | Added to primary key. |
Pinterest Organic
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PIN_ANALYTIC_DAILY_METRIC | |||||
column | Primary Key Change | date | date 🔑 | Added to composite primary key | |
column | Deprecated Column | index 🔑 | No longer primary key | ||
USER_ACCOUNT_ANALYTIC_DAILY_METRIC | |||||
column | Deprecated Column | _fivetran_id 🔑 | No longer primary key | ||
column | Primary Key Change | date | date 🔑 | Added to composite primary key | |
column | Primary Key Change | end_date | end_date 🔑 | Added to composite primary key | |
column | Primary Key Change | start_date | start_date 🔑 | Added to composite primary key | |
column | Primary Key Change | user_account_id | user_account_id 🔑 | Added to composite primary key | |
USER_ACCOUNT_ANALYTICS | |||||
column | Primary Key Change | user_account_id | user_account_id 🔑 | Added to composite primary key |
Salesforce Marketing Cloud
We have added a new table, SMS_MESSAGE_TRACKING
to sync data from the SMSMessageTracking data view.
We have added the following new tables to support MobilePush:
MOBILE_PUSH_DETAIL_EXTRACT
PUSH_MESSAGE
PUSH_APPLICATION
We have added the following new tables to support Chat Messaging Data Extract:
CHAT_TRACKING
CHAT_INBOUND_MESSAGE_LOG
CHAT_POTENTIAL_UNSUBS
OTT_REGISTRATION
Shortcut
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
EPIC_LABEL | |||||
table | New Table | EPIC_LABEL |
Toggl Track
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
USERS | |||||
column | Primary Key Change | id 🔑 | id | No longer primary key. | |
column | Primary Key Change | user_id | user_id 🔑 | Added to primary key. | |
USERS_GROUP | |||||
column | Deprecated Column | users_id 🔑 | No longer primary key. | ||
column | Primary Key Change | user_id 🔑 | New primary key. |
UserVoice
We have renamed the USER
table to USERS
in the schema for UserVoice connectors created on or after July 11, 2024:
Improvements
Bitly
We have changed the sync strategy for the BITLINK
table. We now re-import this table and its child tables to capture updates and deletes.
Checkout.com
We now support priority-first sync for the following tables and their child tables:
BALANCE_REPORT
CUSTOMER
DISPUTE
FINANCIAL_ACTION_REPORT
INSTRUMENT
PAYMENT
PAYMENT_ACTION
PAYOUT_REPORT
REPORT
Clari
We have changed the sync strategy for our Clari connector. We now incrementally sync the following tables and their child tables:
FIELD
FORECAST_ENTRY
TIME_FRAME
TIME_PERIOD
USERS
During every incremental sync, we also sync the historical and future forecasting data for these tables. The incremental syncs for these tables contribute towards your MAR.
CockroachDB
We now sync TIME and TIMETZ columns to your destination as STRING values. Learn more in our CockroachDB type transformation and mapping documentation.
Cvent
We now incrementally sync the ENROLLMENT
table and its child tables.
We no longer capture deletes for the following tables and their child tables:
ATTENDEE_INSIGHT
ATTENDEE
CARD_TRANSACTION
EMAIL
EVENT_QUESTION
EVENT
MEETING_REQUEST
SPEAKER
SURVEY
Eventbrite
We have changed the authentication method for our Eventbrite connector. We now use private token instead of OAuth to authenticate the Eventbrite connector. Be sure to re-authenticate your Eventbrite connector using private token. For more information, see our Eventbrite documentation.
Facebook Ads
We have upgraded our Facebook Ads connector to version 19.0 of the Facebook API. For more information, see Facebook's summary of Graph API v19.0 and Marketing API v19.0.
We now support the following breakdowns in our custom report tables:
video_asset
coarse_conversion_value
fidelity_type
hsid
is_conversion_id_modeled
postback_sequence_index
redownload
skan_campaign_id
We now support the following fields in our custom report tables:
website_purchase_roas
ad_click_actions
ad_impression_actions
auction_bid
auction_competitiveness
auction_max_competitor_bid
catalog_segment_actions
catalog_segment_value_mobile_purchase_roas
catalog_segment_value_omni_purchase_roas
catalog_segment_value_website_purchase_roas
cost_per_15_sec_video_view
cost_per_2_sec_continuous_video_view
cost_per_ad_click
cost_per_dda_countby_convs
cost_per_one_thousand_ad_impression
created_time
dda_countby_convs
instagram_upcoming_event_reminders_set
interactive_component_tap
place_page_name
qualifying_question_qualify_answer_rate
video_play_retention_0_to_15s_actions
video_play_retention_20_to_60s_actions
video_play_retention_graph_actions
video_time_watched_actions
wish_bid
We have deprecated the following fields in our custom report tables:
cost_per_estimated_ad_recallers
estimated_ad_recall_rate
gender_targeting
labels
location
unique_actions
unique_clicks
unique_ctr
unique_inline_link_click_ctr
unique_inline_link_clicks
unique_link_clicks_ctr
unique_outbound_clicks
unique_outbound_clicks_ctr
video_thruplay_watched_actions
action_converted_product_id
Fivetran Platform Connector
The Fivetran Platform connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Google Ads
We've added the option to disable skipping empty account reports. This feature is enabled by default for all connectors. Now, you can also manually toggle it On or Off on the connector setup form.
See our Skip Empty Reports documentation for further details.
Guru
We have changed the sync strategy of the connector. We no longer re-import the following tables weekly to capture deletes:
CARD
EVENT
TASK
Helpshift
We have changed the sync strategy of the connector. We no longer re-import the following tables weekly to capture deletes:
ANALYTIC_AGENT
ANALYTIC_CUSTOM_BOT
ANALYTIC_CUSTOM_BOT_STEP
ANALYTIC_FAQ
ANALYTIC_ISSUE
ANALYTIC_OPEN_ISSUE
ANALYTIC_SUPPORT
ISSUE
Loop
We have changed the sync strategy for the ADVANCED_SHIPPING_NOTICE
table. We no longer re-import the table and its child tables to capture deletes.
Luma
We have changed the sync strategy for the EVENT
table. We no longer re-import the EVENT
tables and its child tables to capture deletes.
Mandrill
We've removed the Template Labels filtering option from the connector configuration. This change applies to all new connectors created after June 20, 2024.
MariaDB
We now support version 10.11 of MariaDB. Learn more in MariaDB's Changes and Improvements in MariaDB 10.11 documentation.
All new MariaDB connectors now support Fivetran Teleport Sync for tables without primary keys. Learn more in our MariaDB Fivetran Teleport Sync documentation.
Mixpanel
We now support Service Accounts authentication for Mixpanel connectors. We support this authentication method to handle Mixpanel's deprecation of the Project Secret authentication method. We recommend that you use the Service Accounts authentication method for both new and existing connectors.
Monday.com
We have changed the sync strategy for the ACTIVITY_LOG
table. We now incrementally sync the table.
MySQL
All new MySQL connectors now support Fivetran Teleport Sync for tables without primary keys. Learn more in our MySQL Fivetran Teleport Sync documentation.
Ometria
- We now incrementally sync the
CONTACT
table.
Opsgenie
We have changed the sync strategy for the ALERT
table. We now incrementally sync the ALERT
table to capture updates and deletes. Previously, we used to re-import the table.
Salesforce
We have upgraded our Salesforce connector from version 60.0 to 61.0 of the Salesforce REST API. Learn more about the changes in Salesforce's changelog. We are gradually rolling out this change to all existing connectors.
We now support AWS Private Link for Salesforce. This feature is in GA and is available only for Business Critical accounts.
SAP ERP on HANA
We've updated the mapping of the FLTP
SAP data type from FLOAT to DOUBLE.
For more information, see our SAP ERP on HANA documentation and SAP ERP on HANA setup guide.
SQL Server
We can now sync tables without primary keys using Fivetran Teleport Sync. The feature is in Beta.
Tempo
We have changed the sync strategy for the TIMESHEET_APPROVAL
table. During historical syncs and initial syncs, we now sync only the last 183 days' worth of data for this table.
UserVoice
We have made the following changes to the Schema tab for UserVoice connectors created on or after July 11, 2024:
- All table names now appear in lowercase.
- We now display all tables in the schema, including the empty tables.
- We no longer support table-level selection or de-selection for new UserVoice connectors.
When I Work
We no longer re-import the PAYROLL
and SCHEDULED_SHIFT_BREAK
tables.