November 2024
Connector SDK
We have released the beta version of our Connector SDK.
Fivetran Connector SDK allows you to code a custom data connector using Python and deploy it as an extension of Fivetran. Fivetran automatically runs the connector at your scheduled frequency and manages the required compute resources. See our Connector SDK Quickstart Setup Guide to begin writing your connector.
We have released version 0.10.24.1
of the fivetran-connector-sdk
PyPI package. This release provides improved error logging and updated testers for fivetran debug
.
Lite Connectors
Lite connectors are now available for the following sources:
Hybrid Deployment support
The following Lite connectors now support the Hybrid Deployment model:
Expand to see the full list
- 7shifts
- 360Learning
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- Affinity
- Afterpay
- Aha!
- Akamai
- Akeneo
- Amazon Attribution
- Anvyl
- Appcues
- Appfigures
- Attio
- Aumni
- Auth0
- AvantLink
- Awin
- Backbone PLM
- BallotReady
- Bazaarvoice
- Bigin by Zoho CRM
- BillingPlatform
- Birdeye
- Bitly
- Bizzabo
- Boostr
- Brave Ads
- Brevo
- Brex
- Brightcove
- Buildium
- Buildkite
- Buzzsprout
- Calabrio
- Calendly
- CallRail
- Campaign Monitor
- Canny
- Canvas by Instructure
- Care Quality Commission
- Castor EDC
- Chameleon
- Chargebee Product Catalog 1.0
- Chargebee Product Catalog 2.0
- ChargeDesk
- ChartMogul
- Checkout.com
- Chorus
- Churnkey
- ChurnZero
- Cin7
- Cin7 Core
- CircleCI
- CJ Commission Detail
- Clari
- ClickUp
- Clockify
- Close
- Codefresh
- Collibra
- Column
- Concord
- Confluence
- Copper
- Criteo Retail Media
- Crossbeam
- crowd.dev
- Culture Amp
- Cvent
- Datadog
- dbt Cloud
- DCL Logistics
- Deputy
- Destini
- Dixa
- Docebo
- DoorLoop
- Drata
- Drift
- Drip
- Dropbox Sign
- DSV
- Duoplane
- EasyPost
- eBay
- Electronic Tenant Solutions
- Employment Hero
- Eventbrite
- Eventsforce
- Everhour
- ExpenseIn
- Expensify
- EZOfficeInventory
- Factbird
- Factorial
- Fillout
- FireHydrant
- Flexport
- Float
- Fone Dynamics
- Forj Community
- Fountain
- Freightview
- FreshBooks
- Freshchat
- Freshdesk Contact Center
- FreshTeam
- Friendbuy
- FullStory
- Gainsight Product Experience
- Gem
- Genesys
- GetFeedback
- GitLab
- Gladly
- GlobalMeet
- Gmail
- GoCardless
- Google Business Profile
- Google Calendar
- Gorgias
- GRIN
- Guru
- HappyFox
- Harvest
- Helpshift
- HiBob
- Hopin
- iLevel
- Incident.io
- Infobip
- Insightly
- Integral Ad Science
- Integrate
- Ironclad
- ironSource
- Ivanti
- Jira Align
- Jotform
- JustCall
- Kandji
- Katana
- Kevel
- KeyPay
- Khoros Care
- Kisi
- Kissmetrics
- Klarna
- Lattice
- LaunchDarkly
- LearnUpon
- Lemlist
- Lessonly
- Liftoff
- Linear
- LinkSquares
- LiveChat Partner
- Lob
- Looker
- Loop
- Loopio
- Luma
- Mailgun
- Mambu
- Matomo
- Maxio Chargify
- Maxio SaaSOptics
- Medallia Agile Research
- Megaphone
- Mention
- Microsoft Entra ID
- Missive
- Mixmax
- MNTN
- Mode
- Moloco
- Mux
- myosh
- Namely
- Navan
- Notion
- Okendo
- Ometria
- ON24
- OnceHub
- Open Data DC
- Open Exchange Rates
- Opsgenie
- Oracle Moat Analytics
- Orbit
- Ordway
- Ortto
- PagerDuty
- Papershift
- Partnerize
- PartnerStack Vendor
- Paychex
- Persona
- Personio
- Picqer
- Pingdom
- Pinpoint
- Pinterest Organic
- Pivotal Tracker
- Piwik PRO
- Planful
- Planhat
- Playvox
- Playvox Workforce Management
- Podio
- PostHog
- Postmark
- PowerReviews Enterprise
- Prive
- Procore
- Productboard
- Productive
- Proofpoint Security Awareness
- Qualaroo
- Quora Ads
- Rakuten Advertising
- Ramp
- Rarible
- ReBound Returns
- ReferralHero
- Resource Management by Smartsheet
- RetailNext
- Retently
- Revel Systems
- RevenueCat
- REVIEWS.io
- RevOps
- RevX
- Ricochet360
- Ringover
- Rippling
- Rithum
- Rocketlane
- Rollbar
- Rootly
- RTB House
- Ruddr
- SafetyCulture
- Salsify
- Samsara
- SCORM
- Security Journey
- ServiceTitan
- Sharetribe
- ShipHero
- ShipNetwork
- ShipStation
- Shopware
- Short.io
- Shortcut
- Sigma Computing
- Simplecast
- Simplesat
- SISTRIX
- Skilljar
- SkillsTX
- SkuVault
- Smadex
- SmartHR
- SmartRecruiters
- Smartwaiver
- Snyk
- SolarWinds Service Desk
- SonarQube
- SparkPost
- Splash
- Split
- Squarespace
- StackAdapt
- Standard Metrics
- StarRez
- Statuspage
- Stylight
- Subscript
- Survicate
- Swoogo
- Tableau
- Talkwalker
- Teads
- Teamtailor
- Teamwork
- Tempo
- TestRail
- Thinkific
- Ticket Tailor
- Toggl Track
- Transcend
- Trelica
- Trello
- Tremendous
- Triple Whale
- Trisolute
- Tymeshift
- Udemy Business
- UKG Pro
- Upland Software
- UpPromote
- Veeqo
- Vitally
- Vonage Contact Center
- VTS
- VWO
- Webconnex
- When I Work
- Wherefour
- WooCommerce
- WordPress
- Workable
- Workday Strategic Sourcing
- WorkRamp
- Wrike
- Xandr
- Xray
- Yahoo Search Ads on Yahoo Japan
- YouGov Sport
- Younium
- Zenefits
- Zingtree
- Zoho Books
- Zoho Campaigns
- Zoho Desk
- Zonka Feedback
- Zoom
Logs
Log event api_call
removed
We have removed the api_call
from the log event list. Use the new event, extract_summary
, instead.
For more information, see our Logs documentation.
New Account Overview page
We have added a new Overview page on the Fivetran dashboard. The page provides you with a comprehensive overview of your account and enables you to see and manage your connectors, transformations, and destinations.
Read more about the new page in our documentation.
Transformations for dbt Core
Updated dbt Quickstart package
We have updated the Quickstart packages for the following connectors:
- HubSpot to version 0.20.0
- Iterable to version 0.13.0
- LinkedIn Ad Analytics to version 0.9.1
- Zendesk Support to version 0.18.1
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
New connectors
Reltio
Our Reltio connector is now available in BETA.
Read our Reltio connector documentation.
Schema changes
Affinity
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FIELD_VALUE | |||||
table | Deprecated Table | FIELD_VALUE | Data now available in the opportunity_field_value , organization_field_value , and person_field_value tables. | ||
OPPORTUNITY_FIELD_VALUE | |||||
table | New Table | OPPORTUNITY_FIELD_VALUE | |||
ORGANIZATION_FIELD_VALUE | |||||
table | New Table | ORGANIZATION_FIELD_VALUE | |||
PERSON_FIELD_VALUE | |||||
table | New Table | PERSON_FIELD_VALUE |
Amazon Ads
We have deprecated the following Sponsored Display version 2 reporting tables in accordance with Amazon's deprecation calendar:
- 'SD_AD_GROUP_REPORT'
- 'SD_ASIN_REPORT'
- 'SD_CAMPAIGN_REPORT'
- 'SD_MATCHED_TARGET_REPORT'
- 'SD_PRODUCT_AD_REPORT'
- 'SD_TARGET_REPORT'
NOTE: The tables listed above have stopped receiving new data. However, we've renamed these tables in your destination by adding the '_v_2' suffix to each of them. You still have access to old data.
We have added support for the following Sponsored Display version 3 reporting tables:
- 'SD_AD_GROUP_REPORT_V_3'
- 'SD_CAMPAIGN_REPORT_V_3'
- 'SD_MATCHED_TARGET_REPORT_V_3'
- 'SD_PRODUCT_AD_REPORT_V_3'
- 'SD_PURCHASED_PRODUCTS_REPORTS'
- 'SD_TARGET_REPORT_V_3'
NOTE: Until November 15, 2024, all usage related to these new reports counts towards free MAR.
Cin7 Core
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
PRODUCT_MOVEMENT | |||||
column | Primary Key Change | index 🔑 | New primary key. |
Facebook Ads
Due to changes to the Facebook API, for the unique_actions
and cost_per_unique_action_type
custom report fields, we now support only the following action_type
breakdowns:
link_click
onsite_conversion_messaging_first_reply
onsite_conversion_total_messaging_connection
outbound_click
We no longer support the following action_type
breakdowns for the unique_actions
and cost_per_unique_action_type
fields:
add_payment_info
add_to_cart
app_custom_event
app_custom_event.fb_mobile_achievement_unlocked
app_custom_event.fb_mobile_activate_app
app_custom_event.fb_mobile_add_payment_info
app_custom_event.fb_mobile_add_to_cart
app_custom_event.fb_mobile_add_to_wishlist
app_custom_event.fb_mobile_complete_registration
app_custom_event.fb_mobile_content_view
app_custom_event.fb_mobile_d2_retention
app_custom_event.fb_mobile_d7_retention
app_custom_event.fb_mobile_initiated_checkout
app_custom_event.fb_mobile_level_achieved
app_custom_event.fb_mobile_purchase
app_custom_event.fb_mobile_rate
app_custom_event.fb_mobile_search
app_custom_event.fb_mobile_spent_credits
app_custom_event.fb_mobile_tutorial_completion
app_custom_event.other
app_engagement
app_install
call_confirm_grouped
checkin
click_to_call_call_confirm
click_to_call_callback_request_submitted
click_to_call_native_20s_call_connect
click_to_call_native_60s_call_connect
click_to_call_native_call_placed
click_to_join_new_channel_member
comment
commerce_event
complete_registration
credit_spent
group_join
initiate_checkout
landing_page_view
lead
leadgen_grouped
like
mobile_app_install
offline_conversion
offline_conversion.add_payment_info
offline_conversion.add_to_cart
offline_conversion.add_to_wishlist
offline_conversion.complete_registration
offline_conversion.initiate_checkout
offline_conversion.lead
offline_conversion.other
offline_conversion.purchase
offline_conversion.search
offline_conversion.view_content
offsite_conversion
offsite_conversion.fb_pixel_add_payment_info
offsite_conversion.fb_pixel_add_to_cart
offsite_conversion.fb_pixel_add_to_wishlist
offsite_conversion.fb_pixel_complete_registration
offsite_conversion.fb_pixel_custom
offsite_conversion.fb_pixel_initiate_checkout
offsite_conversion.fb_pixel_lead
offsite_conversion.fb_pixel_purchase
offsite_conversion.fb_pixel_search
offsite_conversion.fb_pixel_view_content
omni_achievement_unlocked
omni_activate_app
omni_add_to_cart
omni_add_to_wishlist
omni_app_install
omni_complete_registration
omni_custom
omni_initiated_checkout
omni_level_achieved
omni_purchase
omni_rate
omni_search
omni_spend_credits
omni_tutorial_completion
omni_view_content
onsite_app_add_to_cart
onsite_app_purchase
onsite_app_view_content
onsite_conversion.add_to_cart
onsite_conversion.add_to_wishlist
onsite_conversion.click_to_call
onsite_conversion.donate
onsite_conversion.find_location
onsite_conversion.flow_complete
onsite_conversion.initiate_checkout
onsite_conversion.lead
onsite_conversion.lead_grouped
onsite_conversion.message_to_buy
onsite_conversion.messaging_20s_call_connect
onsite_conversion.messaging_60s_call_connect
onsite_conversion.messaging_block
onsite_conversion.messaging_business_calling_call_answered
onsite_conversion.messaging_business_calling_call_initiated
onsite_conversion.messaging_business_calling_call_missed
onsite_conversion.messaging_business_calling_opt_in_accepted
onsite_conversion.messaging_business_calling_opt_in_denied
onsite_conversion.messaging_business_calling_opt_in_sent
onsite_conversion.messaging_conversation_replied_7d
onsite_conversion.messaging_conversation_started_7d
onsite_conversion.messaging_order_created_v2
onsite_conversion.messaging_order_shipped_v2
onsite_conversion.messaging_user_call_placed
onsite_conversion.messaging_user_depth_2_message_send
onsite_conversion.messaging_user_depth_3_message_send
onsite_conversion.messaging_user_subscribed
onsite_conversion.messaging_welcome_message_view
onsite_conversion.other
onsite_conversion.post_save
onsite_conversion.purchase
onsite_conversion.view_content
onsite_web_add_to_cart
onsite_web_app_add_to_cart
onsite_web_app_purchase
onsite_web_app_view_content
onsite_web_lead
onsite_web_purchase
onsite_web_view_content
page_engagement
photo_view
post
post_engagement
post_reaction
purchase
rsvp
search
video_view
view_content
HubSpot
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FEEDBACK_SUBMISSION | |||||
table | New Table | FEEDBACK_SUBMISSION | |||
FEEDBACK_SUBMISSION_CONTACT | |||||
table | New Table | FEEDBACK_SUBMISSION_CONTACT | |||
FEEDBACK_SUBMISSION_PROPERTY_HISTORY | |||||
table | New Table | FEEDBACK_SUBMISSION_PROPERTY_HISTORY | |||
FEEDBACK_SUBMISSION_TICKET | |||||
table | New Table | FEEDBACK_SUBMISSION_TICKET |
Jira
We have added a new table, FIELD_PPROJECT
, with the following columns:
field_id
project_id
Perform a resync to fetch the historical data of the new table and columns.
We are gradually rolling out these changes to all existing connectors. These changes are available only for Jira Cloud instances.
NOTE: You must grant Fivetran the
Administer Jira
global permission to fetch the custom-fields project's mapping data.
Mambu
LOAN_TRANSACTION
table.Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
ACCOUNTING_REPORT_ITEM | |||||
column | Primary Key Change | reportkey | encoded_key 🔑 | Added to primary key. | |
DEPOSIT_ACCOUNT_AUTHORIZATION_HOLD | |||||
column | Rename Column | currency_code | balance_currency_code | ||
LOAN_TRANSACTION | |||||
column | New Column | custom_* |
Navan
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
BOOKING_SEGMENT | |||||
column | New Column | hotel_super_chain |
Productboard
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
FEATURE | |||||
column | New Column | parent_id |
StackAdapt
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
AUDIENCE_FILE | |||||
table | New Table | AUDIENCE_FILE | |||
AUDIENCE_FILE_GEO_TARGETS_COMBINED | |||||
table | Deprecated Table | AUDIENCE_FILE_GEO_TARGETS_COMBINED | Data now available in the AUDIENCE_FILE and AUDIENCE_GEO_TARGETS_FILE tables. | ||
AUDIENCE_GEO_TARGETS_FILE | |||||
table | New Table | AUDIENCE_GEO_TARGETS_FILE | |||
CREATIVE_DISPLAY_JS | |||||
column | Deprecated Column | _fivetran_id 🔑 | No longer primary key. | ||
column | Primary Key Change | creative_id | creative_id 🔑 | Added to primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
CREATIVE_INPUT_AUDIO_VIDEO | |||||
table | Deprecated Table | CREATIVE_INPUT_AUDIO_VIDEO | Data now available in the CREATIVE_INPUT_DATA_AUDIO and CREATIVE_INPUT_DATA_VIDEO tables. | ||
CREATIVE_INPUT_DATA_AUDIO | |||||
table | New Table | CREATIVE_INPUT_DATA_AUDIO | |||
CREATIVE_INPUT_DATA_VIDEO | |||||
table | New Table | CREATIVE_INPUT_DATA_VIDEO | |||
CREATIVE_VAST_TRACKER | |||||
column | Deprecated Column | _fivetran_id 🔑 | No longer primary key. | ||
column | Primary Key Change | creative_id | creative_id 🔑 | Added to primary key. | |
column | Primary Key Change | index 🔑 | New primary key. | ||
INSIGHT_CAMPAIGN_AUDIENCE | |||||
table | New Table | INSIGHT_CAMPAIGN_AUDIENCE | |||
INSIGHT_CAMPAIGN_AUDIENCE_AB | |||||
table | New Table | INSIGHT_CAMPAIGN_AUDIENCE_AB | |||
INSIGHT_CAMPAIGN_BID_FACTOR | |||||
table | New Table | INSIGHT_CAMPAIGN_BID_FACTOR | |||
INSIGHT_CAMPAIGN_CATEGORY | |||||
table | New Table | INSIGHT_CAMPAIGN_CATEGORY | |||
INSIGHT_CAMPAIGN_CREATIVE_TACTIC | |||||
table | New Table | INSIGHT_CAMPAIGN_CREATIVE_TACTIC | |||
INSIGHT_CAMPAIGN_DEAL | |||||
table | New Table | INSIGHT_CAMPAIGN_DEAL | |||
INSIGHT_CAMPAIGN_DEMOGRAPHIC | |||||
table | New Table | INSIGHT_CAMPAIGN_DEMOGRAPHIC | |||
INSIGHT_CAMPAIGN_DEVICE | |||||
table | New Table | INSIGHT_CAMPAIGN_DEVICE | |||
INSIGHT_CAMPAIGN_GEO | |||||
table | New Table | INSIGHT_CAMPAIGN_GEO | |||
INSIGHT_CAMPAIGN_GROUP_AUDIENCE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_AUDIENCE | |||
INSIGHT_CAMPAIGN_GROUP_AUDIENCE_AB | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_AUDIENCE_AB | |||
INSIGHT_CAMPAIGN_GROUP_BID_FACTOR | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_BID_FACTOR | |||
INSIGHT_CAMPAIGN_GROUP_CATEGORY | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_CATEGORY | |||
INSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTIC | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTIC | |||
INSIGHT_CAMPAIGN_GROUP_DEAL | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEAL | |||
INSIGHT_CAMPAIGN_GROUP_DEMOGRAPHIC | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEMOGRAPHIC | |||
INSIGHT_CAMPAIGN_GROUP_DEVICE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_DEVICE | |||
INSIGHT_CAMPAIGN_GROUP_GEO | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_GEO | |||
INSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENT | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENT | |||
INSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCE | |||||
table | New Table | INSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCE | |||
INSIGHT_CAMPAIGN_RETARGETING_SEGMENT | |||||
table | New Table | INSIGHT_CAMPAIGN_RETARGETING_SEGMENT | |||
INSIGHT_CAMPAIGN_SUPPLY_SOURCE | |||||
table | New Table | INSIGHT_CAMPAIGN_SUPPLY_SOURCE | |||
STATS_DELIVERY | |||||
table | Deprecated Table | STATS_DELIVERY | Data now available in the STATS_DELIVERY_ADVERTISER , STATS_DELIVERY_NATIVE_AD , STATS_DELIVERY_CONVERSION_TRACKER , STATS_DELIVERY_CAMPAIGN_GROUP and STATS_DELIVERY_CAMPAIGN tables. | ||
STATS_DELIVERY_ADVERTISER | |||||
table | New Table | STATS_DELIVERY_ADVERTISER | |||
STATS_DELIVERY_CAMPAIGN | |||||
table | New Table | STATS_DELIVERY_CAMPAIGN | |||
STATS_DELIVERY_CAMPAIGN_GROUP | |||||
table | New Table | STATS_DELIVERY_CAMPAIGN_GROUP | |||
STATS_DELIVERY_CONVERSION_TRACKER | |||||
table | New Table | STATS_DELIVERY_CONVERSION_TRACKER | |||
STATS_DELIVERY_NATIVE_AD | |||||
table | New Table | STATS_DELIVERY_NATIVE_AD | |||
STATS_INSIGHT | |||||
table | Deprecated Table | STATS_INSIGHT | Data now available in the INSIGHT_CAMPAIGN_* tables. |
StarRez
Table/column | Change type | Old name | New name | Notes | |
---|---|---|---|---|---|
APPLICATION_STATUS | |||||
table | New Table | APPLICATION_STATUS | |||
ENTRY_APPLICATION | |||||
table | New Table | ENTRY_APPLICATION | |||
ENTRY_APPLICATION_CUSTOM_FIELD | |||||
table | New Table | ENTRY_APPLICATION_CUSTOM_FIELD | |||
ROOM_CONFIGURATION_TERM_TYPE | |||||
table | New Table | ROOM_CONFIGURATION_TERM_TYPE | |||
ROOM_SPACE_CLOSED | |||||
table | New Table | ROOM_SPACE_CLOSED | |||
ROOM_SPACE_CLOSED_REASON_ENUM | |||||
table | New Table | ROOM_SPACE_CLOSED_REASON_ENUM | |||
ROOM_SPACE_DETAIL | |||||
table | New Table | ROOM_SPACE_DETAIL | |||
TERM_TYPE | |||||
table | New Table | TERM_TYPE |
TikTok Ads
We added a buying_types
filter to our calls to retrieve all possible buying_types entities {AUCTION, RESERVATION_RF, RESERVATION_TOP_VIEW} for the following tables:
- AD_HISTORY
- ADGROUP_HISTORY
- CAMPAIGN_HISTORY
We added the buying_type
field to all three tables (AD_HISTORY, ADGROUP_HISTORY, CAMPAIGN_HISTORY) to reflect the buying_types
filter value used in our data requests.
We added the following fields to the AD_HISTORY table (see the TikTok documentation for details):
aigc_disclosure_type
avatar_icon_web_uri
brand_safety_postbid_partner
brand_safety_vast_url
branded_content_disabled
call_to_action_id
card_id
carousel_image_index
cpp_url
creative_type
dark_post_status
deeplink_type
dynamic_destination
dynamic_format
fallback_type
identity_authorized_bc_id
identity_id
identity_type
item_duet_status
item_stitch_status
music_id
optimization_event
page_id
phone_number
phone_region_calling_code
phone_region_code
product_set_id
product_specific_type
promotional_music_disabled
shopping_ads_deeplink_type
shopping_ads_fallback_type
shopping_ads_video_package_id
tiktok_page_category
tracking_app_id
tracking_pixel_id
vast_moat_enabled
vertical_video_strategy
viewability_postbid_partner
viewability_vast_url
We added the following fields to the ADGROUP_HISTORY table (see the TikTok documentation for details):
adgroup_app_profile_page_state
attribution_event_count
bid_display_mode
brand_safety_partner
brand_safety_type
click_attribution_window
comment_disabled
cpm
delivery_mode
discount_amount
discount_percentage
discount_type
engaged_view_attribution_window
feed_type
identity_authorized_bc_id
identity_id
identity_type
ios14_quota_type
ios14_targeting
is_smart_performance_campaign
next_day_retention
pre_discount_budget
pre_discount_cpm
predict_impression
product_source
promotion_target_type
promotion_type
promotion_website_type
purchased_impression
purchased_reach
rf_estimated_cpr
rf_estimated_frequency
rf_purchased_type
roas_bid
saved_audience_id
scheduled_budget
search_result_enabled
share_disabled
shopping_ads_retargeting_actions_days
shopping_ads_retargeting_custom_audience_relation
shopping_ads_retargeting_type
shopping_ads_type
smart_audience_enabled
smart_interest_behavior_enabled
spending_power
split_test_group_id
split_test_status
store_authorized_bc_id
store_id
String> tiktok_subplacements
vbo_window
vertical_sensitivity_id
video_download_disabled
view_attribution_window
We added the following fields to the CAMPAIGN_HISTORY table (see the TikTok documentation for details):
app_id
app_promotion_type
bid_type
budget_optimize_on
campaign_app_profile_page_state
campaign_product_source
deep_bid_type
is_advanced_dedicated_campaign
is_search_campaign
is_smart_performance_campaign
objective
optimization_goal
postback_window_mode
rf_campaign_type
roas_bid
rta_id
rta_product_selection_enabled
Improvements
Aha!
We now incrementally sync the RELEASE
table.
Assembled
The Assembled connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure Blob Storage
The Azure Blob Storage connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Azure DevOps
The Azure DevOps connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
commercetools
The commercetools connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Delighted
The Delighted connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Google Search Ads 360
We've added the following metadata tables to provide a more comprehensive schema:
ad
ad_group
bidding_strategy
campaign
customer
We've added the following prebuilt reports to our Google Search Ads 360 connector:
ad_conversion_action_and_device_report
ad_device_report
ad_group_conversion_action_and_device_report
ad_group_device_report
ad_group_report
campaign_conversion_action_and_device_report
campaign_device_report
campaign_report
customer_conversion_action_and_device_report
customer_device_report
customer_report
keyword_conversion_action_and_device_report
keyword_device_report
keyword_report
Prebuilt reports are common report configurations that make it easier to get insight into your data without needing to create custom reports. For more details about this update, please refer to the Google Search Ads 360 ERD.
HubSpot
We have added support for HubSpot's Feedback Submissions API to sync the feedback submissions data in your HubSpot account. We are gradually rolling out this improvement to all existing connectors.
Impact
The Impact connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Ironclad
The Ironclad connector now supports OAuth 2.0 authentication. For more information, see our setup instructions.
Lever
The Lever connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Maxio SaaSOptics
We now re-import the INVOICE
table once a week to capture updates and deletes.
OneLake
We have introduced new fields in the setup form: Workspace GUID and Lakehouse GUID.
For new connectors, these fields now replace the existing Workspace Name and Lakehouse Name fields.
For existing connectors, the new GUID fields have been added alongside the current Workspace Name and Lakehouse Name fields. We will sunset the original fields in a future update. Ensure that you update the new GUID fields before this change.
PayPal
The PayPal connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Recurly
The Recurly connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
SFTP
We have made the following updates to the setup form:
- Added a new configuration option, Preview Files to perform an intermediate test during configuration
- Added support for displaying fields based on the file type
- Reorganised fields to make the setup form more intuitive
- Removed Infer as an option from the File Type field
- Removed the Enable Advanced Options toggle
For more information, see our setup instructions. We are gradually rolling out these changes to all existing connectors.
Slack
The Slack connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Sprout Social
The Sprout Social connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Talkdesk
The Talkdesk connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Uservoice
The Uservoice connector now supports the Hybrid Deployment model. For more information, see our setup instructions.
Zendesk Chat
The Zendesk Chat connector now supports the Hybrid Deployment model. For more information, see our setup instructions.