schema in bigquery field: items type: string
Value in table in items field is stored as string
{"data": [{"id": "1234", "plan": {"sub_id": "567", "metadata": {"currentlySelling": "true", "custom_attributes": "{\"shipping\": true,\"productLimit\":10}", "Features": "[\"10 products\", \"Online support\"]"}, "name": "Personal", "object": "plan"}, "quantity": 1}], "has_more": false}
Two Questions 1) How can i query within array eg: where shipping is true or where one of the features is "Online support" 2) The reason I had to store the data as string because "custom_attributes" value can change. Is there a better way to store data in bigquery when value of one of the nested key can change?