1 Reply Latest reply on Dec 15, 2018 9:08 PM by Chris McClellan

    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?