I’m trying to create a key feature data mart using nested structs in BigQuery. Everything is working fine except that an unwanted random field is being created in the inner ARRAY_STRUCT (e.d struct) while creating the final CTE “fin_table.”
It seems that the number of columns being created exceeds the number specified in the struct_fields variable for dynamic fields, which is denoted by %s.↳