@kapa.ai I am using the Hubspot connector and am getting the email_events, marketing_emails tables. How do i determine for every event in the events table, which EMAIL the user was clicking or opening

The knowledge sources don't contain enough detail about the specific schema fields of the HubSpot

email_events

stream to give you a definitive join key. However, based on what is available, here's what can be said: What the knowledge sources tell us

marketing_emails

stream records include fields like

id

,

updated

,

delivered

,

opens

,

clicks

,

bounces

, etc. [HubSpot test source] Per-record enrichment: The HubSpot connector fetches statistics for each marketing email by making a separate call to

/marketing/v3/emails/{emailId}/statistics

and merging those stats directly into the email record. [HubSpot CONTRIBUTING] What the knowledge sources do NOT cover The knowledge sources do not explicitly describe the schema of the

email_events

table for HubSpot, nor do they document a specific foreign key field (e.g.,

emailId

or

contentId

) that links an event row to a specific email in

marketing_emails

. Recommended approach Based on general HubSpot API knowledge (outside these sources), the

email_events

stream typically contains a field like

emailCampaignId

or

contentId

that can be correlated with the

id

field in

marketing_emails

. However, I cannot confirm this from the provided knowledge sources. I'd suggest: 1. Inspecting the actual schema of your

email_events

table in your destination (e.g., look for fields like

emailId

,

contentId

, or

emailCampaignId

). 2. Checking the official Airbyte HubSpot connector docs for the full stream schema, which is not included in the provided knowledge sources. If you share the column names from your

email_events

table, I can help you reason through the join logic. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.