There shouldn't be anything preventing this in the google-cloud-bigquery DB-API layer, as it converts to dictionaries when reading results of RECORD columns.

Expand for the whole conversion chain.

The DB-API calls list_rows() on the query results table at

https://github.com/GoogleCloudPlatform/google-cloud-python/blob/b8b28b15ebb47461e8c302ecd57d87741211ad10/bigquery/google/cloud/bigquery/dbapi/cursor.py#L191-L198

which returns a RowIterator

https://github.com/GoogleCloudPlatform/google-cloud-python/blob/b8b28b15ebb47461e8c302ecd57d87741211ad10/bigquery/google/cloud/bigquery/table.py#L1099

Which converts the API response to Python objects with _row_tuple_from_json

https://github.com/GoogleCloudPlatform/google-cloud-python/blob/b8b28b15ebb47461e8c302ecd57d87741211ad10/bigquery/google/cloud/bigquery/_helpers.py#L196-L220

Which converts to dictionaries for record types.

https://github.com/GoogleCloudPlatform/google-cloud-python/blob/b8b28b15ebb47461e8c302ecd57d87741211ad10/bigquery/google/cloud/bigquery/_helpers.py#L155-L167

One caveat, is that query parameters containing struct values are not yet supported at the DB-API layer. Feature request at googleapis/google-cloud-python#3524

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

Did not recognize type 'RECORD' , looking to analytcs sessions in bigquery #4

Description

Metadata

Metadata

Assignees

Labels

Type

Fields

Projects

Milestone

Relationships

Development

Issue actions