Hi team, I'm encountering odd behaviour with the basic normalization. I'm using a modified version of the latest Hubspot connector and for the associations field, I'm building it such that the

companies

table's ticket associations would have the following value:

[ {"company_id": <some_value>, "ticket_id": <some_value>}, {"company_id": <some_value>, "ticket_id": <some_value>} ]

My expectation is it should create a separate table once ingested into my Snowflake warehouse with

company_id

and

ticket_id

as the fields, per this documentation. However, this is not the case. Any idea what I'm missing here?

Hey can you check in the connection settings page what is the schema. If you can share a screenshot?