Loading

Using BigQuery Standard SQL and Nested Fields

Udgivelsesdato: Apr 30, 2025
Beskrivelse
When connecting to a BigQuery table that contains repeated RECORD fields, the following error may occur:
 
The Google BigQuery service was unable to compile the query.
Cannot access field allocation_method on a value with type ARRAY<STRUCT<value_type STRING, value STRING, allocation_method STRING, ...>> at [1:<number>]

Cause

The ability to query repeated RECORD fields in a Google BigQuery connection is currently not built into the product.
Løsning
As a possible workaround, the FLATTEN() function can be used in Google BigQuery to expand the nested fields into flat tables. Those tables, as saved views, can then be connected with Tableau Desktop.

Note: While we make every effort to keep references to third-party content accurate, the information we provide here might change without notice.
Yderligere ressourcer
To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea:
FLATTEN() function by Google.com
 
Note: Non-repeated RECORD fields are supported.
Vidensartikelnummer

001498373

 
Indlæser
Salesforce Help | Article