How do I query on a nested field within arrays?
You can check all elements in your log event using the FLATTEN command. This Snowflake article provides an example of how to use the FLATTEN function to parse nested arrays.
FLATTEN