Solved

bigQuery multilevel data (json)

  • 21 March 2023
  • 1 reply
  • 46 views

We connected to bigquery where we have the data imported following way

https://prnt.sc/bjL3_rN6kTLj

activity
Level 2 status
Level 2 authorization_date
Level 2 reception_date
Level 2 received_date
Level 2 controlled_date
Level 2 refunded_date

but in gooddata we only see level 1 data such as activity which clearly is not working :))

https://prnt.sc/IRbYP9g3PmBc

how can we drill down?

icon

Best answer by Julius Kos 21 March 2023, 21:29

View original

1 reply

Userlevel 2

Hello Virgil, 


I’m afraid that similar scenario with RECORD datatype is not supported in GoodData. Please see the bellow docs for the reference of supported datatypes from BigQuery:

https://help.gooddata.com/doc/enterprise/en/data-integration/data-preparation-and-distribution/direct-data-distribution-from-data-warehouses-and-object-storage-services/gooddata-bigquery-integration-details/

 

I would also recommend you to check the bellow BigQuery integration documentation which will provide you with more useful information:

https://www.gooddata.com/developers/cloud-native/doc/cloud/connect-data/create-data-sources/bigquery/#additional-information

 

Maybe for similar purposes (if I understood correctly how you wish to set up your data) you might want to consider using Labels instead:

https://www.gooddata.com/developers/cloud-native/doc/2.1/model-data/concepts/label/

Reply