Does Snowplow BigQuery support structured data using Arrays and Structs?

Hi, I’m new to Snowplow and couldn’t find this in the docs. If I send structured data in an event will it end up structured or stringified in BigQuery? Thank you!

Hi @andrewreedy,

No, it will not end up stringified (as it would in Redshift), but as properly typed STRUCT.

Just make sure you’re sending self-describing (aka “unstructured” - poor legacy naming you still can find in docs) events and context. Structured events are different things.

2 Likes

Thank you @anton!! Very helpful.