Snowflake List Filters or List "used-in".

[phdm3]

We are using Snowflake to query Hubspot data.  We are attempting to do some list maintenence and we are wanting to get a better understanding of which lists are used for each marketing email.  

Is it possible to query which lists are used for each email?

Along similar lines, we are also trying to query the parameters/filters that are used in creating a list. 

Has anybody managed to query these items? 

[PamCotton]

Hey @phdm3, thank you for reaching out to our Community!

To query which lists are used for each marketing email in HubSpot via Snowflake, you'll need to combine data from the Email Events API and the Lists API. This will give you insights into the recipient list IDs for your emails. Currently, HubSpot doesn’t provide a way to query these relationships directly.

To query the parameters/filters used in creating a list, you can use the Lists API to get the list details and filters applied to them.

To our top experts @Anton and @DanielSanchez do you have any recommendations for @phdm3?

Thank you,

Pam