How to manage with BigQuery dataset

Hello,

 

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,

 

Philippe.

Comments