v3.19.0

3.19.0 (2024-03-11)

Features

• Support RANGE query parameters (#1827) (b359a9a)
• Support range sql (#1807) (86a45c9)

Bug Fixes

• Add google-auth as a direct dependency (713ce2c)
• Augment universe_domain handling (#1837) (53c2cbf)
• deps: Require google-api-core>=1.34.1, >=2.11.0 (713ce2c)
• Supplementary fix to env-based universe resolution (#1844) (b818992)
• Supplementary fix to env-based universe resolution (#1847) (6dff50f)

v3.18.0

3.18.0 (2024-02-29)

Features

• Support nullable boolean and Int64 dtypes in insert_rows_from_dataframe (#1816) (ab0cf4c)
• Support slot_ms in QueryPlanEntry (#1831) (d62cabb)

Bug Fixes

• Keyword rendering and docstring improvements (#1829) (4dfb920)

Documentation

• samples: Updates to urllib3 constraint for Python 3.7 (#1834) (b099c32)
• Update client_query_w_named_params.py to use query_and_wait API (#1782) (89dfcb6)

v3.17.2

3.17.2 (2024-01-30)

Bug Fixes

• Change load_table_from_json autodetect logic (#1804) (6249032)

Documentation

• Update to use API (#1781) (81563b0)
• Update client_query_destination_table.py sample to use query_and_wait (#1783) (68ebbe1)
• Update query_external_sheets_permanent_table.py to use query_and_wait API (#1778) (a7be88a)
• Update sample for query_to_arrow to use query_and_wait API (#1776) (dbf10de)
• Update the query destination table legacy file to use query_and_wait API (#1775) (ef89f9e)
• Update to use query_and_wait in client_query_w_positional_params.py (#1786) (410f71e)
• Update to use query_and_wait in samples/client_query_w_timestamp_params.py (#1785) (ba36948)
• Update to_geodataframe to use query_and_wait functionality (#1800) (1298594)

v3.17.1

3.17.1 (2024-01-24)

Bug Fixes

• Add pyarrow.large_strign to the _ARROW_SCALAR_IDS_TO_BQ map (#1796) (b402a6d)
• Retry 'job exceeded rate limits' for DDL queries (#1794) (39f33b2)

v3.17.0

3.17.0 (2024-01-24)

Features

• Support universe resolution (#1774) (0b5c1d5)

Bug Fixes

• query_and_wait now retains unknown query configuration _properties (#1793) (4ba4342)
• Raise ValueError in query_and_wait with wrong job_config type (4ba4342)

Documentation

• Remove unused query code sample (#1769) (1f96439)
• Update snippets.py to use query_and_wait (#1773) (d90602d)
• Update multiple samples to change query to query_and_wait (#1784) (d1161dd)
• Update the query with no cache sample to use query_and_wait API (#1770) (955a4cd)
• Updates query to query and wait in samples/desktopapp/user_credentials.py (#1787) (89f1299)

v3.16.0

3.16.0 (2024-01-12)

Features

• Add table_constraints field to Table model (#1755) (a167f9a)
• Support jsonExtension in LoadJobConfig (#1751) (0fd7347)

Bug Fixes

• Add detailed message in job error (#1762) (08483fb)

v3.15.0

3.15.0 (2024-01-09)

Features

• Support JSON type in insert_rows and as a scalar query parameter (#1757) (02a7d12)
• Support RANGE in schema (#1746) (8585747)

Bug Fixes

• Deserializing JSON subfields within structs fails (#1742) (0d93073)
• Due to upstream change in dataset, updates expected results (#1761) (132c14b)
• Load_table_from_dataframe for higher scale decimal (#1703) (b9c8be0)
• Updates types-protobuf version for mypy-samples nox session (#1764) (c0de695)

Performance Improvements

• DB-API uses more efficient query_and_wait when no job ID is provided (#1747) (d225a94)

v3.14.1

3.14.1 (2023-12-13)

Bug Fixes

• Add missing handler for deserializing json value (#1587) (09017a9)

v3.14.0

3.14.0 (2023-12-08)

Features

• Add Client.query_and_wait which directly returns a RowIterator of results (#1722) (89a647e)
• Add job_id, location, project, and query_id properties on RowIterator (#1733) (494f275)
• Add job_timeout_ms to job configuration classes (#1675) (84d64cd)
• Add support dataset.max_time_travel_hours (#1683) (f22eff2)
• Add support for Dataset.isCaseInsensitive (#1671) (386fa86)
• Add support for Python 3.12 (#1736) (3c0976a)
• Removed pkg_resources from all test files and moved importlib into pandas extra (#1726) (1f4ebb1)
• Support data_governance_type (#1708) (eff365d)

Bug Fixes

• load_table_from_dataframe now assumes there may be local null values (#1735) (f05dc69)
• Ensure query job retry has longer deadline than API request deadline (#1734) (5573579)
• Keep RowIterator.total_rows populated after iteration (#1748) (8482f47)
• Move grpc, proto-plus and protobuf packages to extras (#1721) (5ce4d13)

Performance Improvements

• Use the first page a results when query(api_method="QUERY") (#1723) (6290517)

v3.14.0rc0

3.14.0rc0 (2023-11-30)

Features

• Add job_id, location, project, and query_id properties on RowIterator (#1733) (494f275)
• Add job_timeout_ms to job configuration classes (#1675) (84d64cd)
• Add support dataset.max_time_travel_hours (#1683) (f22eff2)
• Add support for Dataset.isCaseInsensitive (#1671) (386fa86)
• Removed pkg_resources from all test files and moved importlib into pandas extra (#1726) (1f4ebb1)
• Support data_governance_type (#1708) (eff365d)

Bug Fixes

• load_table_from_dataframe now assumes there may be local null values (#1735) (f05dc69)
• Ensure query job retry has longer deadline than API request deadline (#1734) (5573579)
• Move grpc, proto-plus and protobuf packages to extras (#1721) (5ce4d13)

Performance Improvements

• Use the first page a results when query(api_method="QUERY") (#1723) (6290517)