0 Replies Latest reply on Nov 24, 2018 10:53 AM by Elliott Amador

    Cant access certain fields from Google BigQuery

    Elliott Amador

      i have connected to our Database in Google BigQuery and i have dragged the table i am wanting to use on the Tableau Data section. I then go to Sheet1 and try to add certain rows to the sheet and am getting the below error message:

       

      An error occurred while communicating with the Google BigQuery data source 'com_mojiit_app_Mojiit_Sticker_IOS (crashlytics)'.

       

       

      The Google BigQuery service was unable to compile the query.

      Cannot access field name on a value with type ARRAY<STRUCT<timestamp TIMESTAMP, name STRING, params ARRAY<STRUCT<key STRING, value STRING>>>> at [1:22]

       

      What is the solution to this, as i am unsure why this is happening?