Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

<@U04S8PLJWMT> which stream to use in hubspot to get emails open and close information

Based on the available knowledge sources, the HubSpot source connector documentation doesn't explicitly detail a stream specifically for email open/close (read) tracking data.
However, the knowledge sources do mention the *`marketing_emails`* stream, which relates to marketing email data. This stream was migrated from HubSpot's v1 API to the v3 API in connector version 6.0.0 and now supports incremental sync. [<https://docs.airbyte.com/integrations/sources/hubspot-migrations|HubSpot Migration Guide>]
For broader email engagement metrics (opens, clicks, bounces, etc.), you may want to consider the *HubSpot Destination* or look at related connectors. For example, if you're using *Iterable* as your email platform, it has dedicated streams like `Email Open`, `Email Click`, `Email Bounce`, etc. [<https://docs.airbyte.com/integrations/sources/iterable#supported-streams|Iterable streams>]
Unfortunately, the knowledge sources do not contain enough detail about the full list of HubSpot source streams to confirm whether a dedicated "email open/read" tracking stream exists in the HubSpot source connector. I'd recommend checking the full <https://docs.airbyte.com/integrations/sources/hubspot|HubSpot source connector documentation> directly for a complete list of available streams and their descriptions. :thumbsup: 0 button :thumbsdown: 0 button :information_source: *Tip:* Mention *@kapa.ai* in the thread for follow-ups or *DM the app* for *1-to-1* help.