How to manage with BigQuery dataset




I have to work on BigQuery dataset and I would like to know what is the more efficient way to structured data into DOMO ?

Some fields are ok but some are aggregated and not understand by DOMO. For example, geo field is aggregated like that


[FieldValue{attribute=PRIMITIVE, value=Europe}, FieldValue{attribute=PRIMITIVE, value=France}, FieldValue{attribute=PRIMITIVE, value=Normandy}, FieldValue{attribute=PRIMITIVE, value=Valognes}, FieldValue{attribute=PRIMITIVE, value=Western Europe}, FieldValue{attribute=PRIMITIVE, value=(not set)}]


How did you manage your data coming from BigQuery ?


Thank you for your help,