Im trying to move from BQ to Snowflake but I have a problem creating my table schema.
I have a in BQ columns defined as:

ARRAY<STRUCT<name STRING, id STRING>>

But I didnt find how to do the same in Snowflake.
I have read both docs:
https://cloud.google.com/bigquery/docs/migration/snowflake-sql

https://docs.snowflake.com/en/sql-reference/data-types-structured#label-structured-types-specifying-map

And I dont understand how to do it.