HubSpot connector reference

This page provides reference information about the managed HubSpot connector in Lakeflow Connect, including supported source tables and their update patterns.

Supported source tables

The HubSpot connector supports the following source tables from HubSpot Marketing Hub and CRM Hub. Some tables support incremental updates, while others require a full refresh on each pipeline run.

Beta

Ingestion from HubSpot CRM Hub is in Beta. CRM Hub tables are available only in workspaces that opt into the hubspot_connector_crm_objects preview. See Configure OAuth for HubSpot ingestion.

Tables that support incremental updates

The following tables support incremental ingestion, where only new or modified records are retrieved during each pipeline update:

Marketing Hub

• email_events
• email_subscription_change
• marketing_emails

CRM Hub

• calls
• companies
• contacts
• deals
• emails
• leads
• line_items
• meetings
• notes
• orders
• products
• tasks
• tickets

Tables that support batch updates only

The following tables require full refresh on each pipeline update because the HubSpot API doesn't provide a way to filter records based on a cursor:

Marketing Hub

• email_campaign
• email_campaign_list
• email_subscriptions
• form_submissions
• forms
• marketing_campaign_asset
• marketing_campaign_budget
• marketing_campaign_spend
• marketing_campaigns
• marketing_event_list
• marketing_events

CRM Hub

• deals_pipelines
• owners
• tickets_pipelines