Decodes a column from a protobuf value to a Python object. This function
should only be called for result sets that use lazy_decoding=True.
The object that is returned by this function is the same as the object
that would have been returned by the rows iterator if lazy_decoding=False.
decode_row
decode_row(row:[])-> []
Decodes a row from protobuf values to Python objects. This function
should only be called for result sets that use lazy_decoding=True.
The array that is returned by this function is the same as the array
that would have been returned by the rows iterator if lazy_decoding=False.
one
one()
Return exactly one result, or raise an exception.
Exceptions
Type
Description
NotFound
If there are no results.
ValueError
If there are multiple results.
RuntimeError
If consumption has already occurred, in whole or in part.
one_or_none
one_or_none()
Return exactly one result, or None if there are no results.
Exceptions
Type
Description
ValueError
If there are multiple results.
RuntimeError
If consumption has already occurred, in whole or in part.
to_dict_list
to_dict_list()
Return the result of a query as a list of dictionaries.
In each dictionary the key is the column name and the value is the
value of the that column in a given row.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[],[],null,["# Class StreamedResultSet (3.57.0)\n\nVersion latestkeyboard_arrow_down\n\n- [3.57.0 (latest)](/python/docs/reference/spanner/latest/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.56.0](/python/docs/reference/spanner/3.56.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.55.0](/python/docs/reference/spanner/3.55.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.54.0](/python/docs/reference/spanner/3.54.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.53.0](/python/docs/reference/spanner/3.53.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.52.0](/python/docs/reference/spanner/3.52.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.51.0](/python/docs/reference/spanner/3.51.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.50.1](/python/docs/reference/spanner/3.50.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.46.0](/python/docs/reference/spanner/3.46.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.45.0](/python/docs/reference/spanner/3.45.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.44.0](/python/docs/reference/spanner/3.44.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.43.0](/python/docs/reference/spanner/3.43.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.42.0](/python/docs/reference/spanner/3.42.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.41.0](/python/docs/reference/spanner/3.41.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.40.1](/python/docs/reference/spanner/3.40.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.39.0](/python/docs/reference/spanner/3.39.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.38.0](/python/docs/reference/spanner/3.38.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.37.0](/python/docs/reference/spanner/3.37.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.36.0](/python/docs/reference/spanner/3.36.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.35.1](/python/docs/reference/spanner/3.35.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.34.0](/python/docs/reference/spanner/3.34.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.33.0](/python/docs/reference/spanner/3.33.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.32.0](/python/docs/reference/spanner/3.32.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.31.0](/python/docs/reference/spanner/3.31.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.30.0](/python/docs/reference/spanner/3.30.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.29.0](/python/docs/reference/spanner/3.29.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.28.0](/python/docs/reference/spanner/3.28.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.27.1](/python/docs/reference/spanner/3.27.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.26.0](/python/docs/reference/spanner/3.26.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.25.0](/python/docs/reference/spanner/3.25.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.24.0](/python/docs/reference/spanner/3.24.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.23.0](/python/docs/reference/spanner/3.23.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.22.2](/python/docs/reference/spanner/3.22.2/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.21.0](/python/docs/reference/spanner/3.21.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.20.0](/python/docs/reference/spanner/3.20.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.19.0](/python/docs/reference/spanner/3.19.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.18.0](/python/docs/reference/spanner/3.18.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.17.0](/python/docs/reference/spanner/3.17.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.16.0](/python/docs/reference/spanner/3.16.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.15.1](/python/docs/reference/spanner/3.15.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.14.1](/python/docs/reference/spanner/3.14.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.13.0](/python/docs/reference/spanner/3.13.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.12.1](/python/docs/reference/spanner/3.12.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.11.1](/python/docs/reference/spanner/3.11.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.10.0](/python/docs/reference/spanner/3.10.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.9.0](/python/docs/reference/spanner/3.9.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.8.0](/python/docs/reference/spanner/3.8.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.7.0](/python/docs/reference/spanner/3.7.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.6.0](/python/docs/reference/spanner/3.6.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.5.0](/python/docs/reference/spanner/3.5.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.4.0](/python/docs/reference/spanner/3.4.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.3.0](/python/docs/reference/spanner/3.3.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.2.0](/python/docs/reference/spanner/3.2.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.1.0](/python/docs/reference/spanner/3.1.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [3.0.0](/python/docs/reference/spanner/3.0.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [2.1.1](/python/docs/reference/spanner/2.1.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [2.0.0](/python/docs/reference/spanner/2.0.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.19.3](/python/docs/reference/spanner/1.19.3/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.18.0](/python/docs/reference/spanner/1.18.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.17.1](/python/docs/reference/spanner/1.17.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.16.0](/python/docs/reference/spanner/1.16.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.15.1](/python/docs/reference/spanner/1.15.1/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.14.0](/python/docs/reference/spanner/1.14.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.13.0](/python/docs/reference/spanner/1.13.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.12.0](/python/docs/reference/spanner/1.12.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.11.0](/python/docs/reference/spanner/1.11.0/google.cloud.spanner_v1.streamed.StreamedResultSet)\n- [1.10.0](/python/docs/reference/spanner/1.10.0/google.cloud.spanner_v1.streamed.StreamedResultSet) \n\n StreamedResultSet(\n response_iterator, source=None, column_info=None, lazy_decode: bool = False\n )\n\nProcess a sequence of partial result sets into a single set of row data.\n\nProperties\n----------\n\n### fields\n\nField descriptors for result set columns.\n\n### metadata\n\nResult set metadata\n\n### stats\n\nResult set statistics\n\nMethods\n-------\n\n### decode_column\n\n decode_column(row: [], column_index: int)\n\nDecodes a column from a protobuf value to a Python object. This function\nshould only be called for result sets that use `lazy_decoding=True`.\nThe object that is returned by this function is the same as the object\nthat would have been returned by the rows iterator if `lazy_decoding=False`.\n\n### decode_row\n\n decode_row(row: []) -\u003e []\n\nDecodes a row from protobuf values to Python objects. This function\nshould only be called for result sets that use `lazy_decoding=True`.\nThe array that is returned by this function is the same as the array\nthat would have been returned by the rows iterator if `lazy_decoding=False`.\n\n### one\n\n one()\n\nReturn exactly one result, or raise an exception.\n\n### one_or_none\n\n one_or_none()\n\nReturn exactly one result, or None if there are no results.\n\n### to_dict_list\n\n to_dict_list()\n\nReturn the result of a query as a list of dictionaries.\nIn each dictionary the key is the column name and the value is the\nvalue of the that column in a given row."]]