Hubspot

Hubspot

Generally AvailableETL Sources

Extract data from this source and load it into your data warehouse.

Features

Feature Name	Supported	Notes
OAuth	✓	OAuth 2.0 authentication
Access Token	✓	API key or access token
Full Refresh	✓	Complete data reload
Incremental Sync	✓	Only new/updated records
Distribution Stage	✓	Generally Available
Dynamic Streams	✓	Streams are built dynamically
Start Date	—
Column Hashing	—

Sync Overview

• Total Streams: 56
• Parent Streams: 25
• Sub-Streams: 31
• Supported Sync Modes: Incremental, Full Refresh

Available Streams

• company (Full Refresh, Incremental)
  • company_property_history
• company_delete_webhook (Incremental)
• contact (Full Refresh, Incremental)
  • contact_form_submission
  • contact_property_history
• contact_delete_webhook (Incremental)
• contact_list (Full Refresh)
• contact_list_member (Full Refresh, Incremental)
• deal (Full Refresh, Incremental)
  • deal_property_history
  • deal_stage
• deal_delete_webhook (Incremental)
• deal_pipeline (Full Refresh, Incremental)
  • deal_pipeline_stage
• email_campaign (Full Refresh, Incremental)
• email_event (Full Refresh, Incremental)
  • email_event_bounce
  • email_event_click
  • email_event_deferred
  • email_event_delivered
  • email_event_dropped
  • email_event_open
  • email_event_sent
  • email_event_spam_report
  • email_event_status_change
  • email_event_suppressed
• email_subscription (Full Refresh)
• email_subscription_change (Full Refresh, Incremental)
  • email_subscription_change
• engagement (Incremental, Full Refresh)
  • engagement_company
  • engagement_contact
  • engagement_deal
  • engagement_property_history
• feedback_submission (Full Refresh, Incremental)
  • feedback_submission_property_history
• form (Full Refresh)
• line_item (Full Refresh, Incremental)
  • line_item_property_history
• marketing_email (Full Refresh, Incremental)
  • marketing_email_campaign
  • marketing_email_contact
  • marketing_email_contact_list
• owner (Full Refresh, Incremental)
  • owner_team
• product (Full Refresh, Incremental)
  • product_property_history
• property (Full Refresh, Incremental)
  • property_option
• role (Full Refresh)
• task (Full Refresh, Incremental)
  • task_property_history
• team (Full Refresh)
  • team_user
• users (Full Refresh)

Next Steps

• Setup Guide - Learn how to connect Hubspot
• API Configuration - View schema and API details
• Release Notes - See recent changes