Spoiler
Spoiler
We need to know the sources for each property that we have in hubspot. (e.g. reason_for_churn is a property for COMPANY - object). The only way to know the sources for the properties is through the UI, on this URL https://app.hubspot.com/data-quality/8467430/properties/0-2/reason_for_churn , where I can see the sources for that specific property. However I need those sources to be in one of the data models that we ingest through the Hubspot Data Share Query HubSpot data in Snowflake. Could be an array of all the sources and another column with the most recent one.