Changelog#

PyPI History

2.49.0 (2026-09-09)#

Features#

  • support iceberg geo types

  • support inplace parameter on DataFrame.fillna() and Series.fillna()

Bug Fixes#

  • configure continuous query connection properties and assert job error status

  • enable compiler fallback for dry runs

  • fix quotation error for SQLGlot compiler for StreamingDataFrame

  • handle time and date literals in SQLGlot compiler properly

  • omit INTO keyword in LOAD DATA OVERWRITE DDL

  • parenthesize OR expressions for AND chaining in SQLGlot

  • quote literal values for strings in SQLGlot

  • remove broken bigframes.bigquery.extract and bigframes.bigquery.generate_date_array functions

  • session lifecycle and Python 3.14 syntax

  • support bool coercion for non-numerical values in SQLGlot compiler

Documentation#

  • add client_json_credentials sample

  • add create_table tri-library sample

  • add extract_table combined sample

  • add extract_table_json combined sample

  • add load_table_gcs_csv combined sample

  • add pandas_to_gbq_simple combined sample

  • add read_gbq_simple combined sample

  • restore samples/snippets directory

  • update BigQuery DataFrames boosted tree model snippet to use bigframes.bigquery.ml API

  • update BigQuery DataFrames k-means snippet to use the bigframes.bigquery.ml module and partial ordering

  • update BigQuery DataFrames ML (linear regression) tutorial to use the bigframes.bigquery.ml API

  • update BQML getting started tutorial to use bigframes.bigquery.ml APIs

  • update load_table_dataframe to combined sample

  • update logistic regression prediction snippets to use bigframes.bigquery.ml API and partial ordering

  • update multimodal sample models

  • update query_results_dataframe to combined sample

2.48.0 (2026-08-12)#

Features#

  • bigframes: Transpiler supports more string ops (#17693) (7d2bc21)

Bug Fixes#

  • bigframes: fix field name typos for ai.generate* functions (#17983) (1b5c48b)

  • bigframes: resolve session-scoped API method logging (#18076) (ace618b)

  • bigframes: update GeminiTextGenerator default model to gemini-2.5-flash (#18060) (5770ff6)

  • bump @angular/compiler, @angular/common, @angular/core, @angular/forms, @angular/platform-browser, @angular/router and @angular/compiler-cli in /packages/bigframes/bigframes/display/table_widget_angular (#17992) (346aaab)

  • bump fast-uri from 3.1.4 to 3.1.5 in /packages/bigframes/bigframes/display/table_widget_angular (#17989) (3b3f3f4)

  • bump hono from 4.12.31 to 4.13.1 in /packages/bigframes/bigframes/display/table_widget_angular (#18032) (cddf35b)

  • bump ip-address and express-rate-limit in /packages/bigframes/bigframes/display/table_widget_angular (#17985) (02ed656)

  • bump undici and @angular/build in /packages/bigframes/bigframes/display/table_widget_angular (#17986) (6938061)

  • bump undici from 7.25.0 to 7.29.0 in /packages/bigframes/tests/js (#17987) (65a3571)

2.47.0 (2026-08-03)#

Features#

  • bigframes: add ai.embed and ai.similarity to bigquery accessor (#17927) (2d1372b)

Bug Fixes#

  • bigframes: fix mypy errors in _magics.py related to get_ipython (#17979) (24d955e)

  • bump brace-expansion from 5.0.6 to 5.0.7 in /packages/bigframes/bigframes/display/table_widget_angular (#17794) (2df1bb5)

  • bump fast-uri from 3.1.1 to 3.1.4 in /packages/bigframes/bigframes/display/table_widget_angular (#17828) (8ce495a)

  • bump hono from 4.12.16 to 4.12.31 in /packages/bigframes/bigframes/display/table_widget_angular (#17829) (6d6fa39)

  • bump immutable from 5.1.7 to 5.1.9 in /packages/bigframes/bigframes/display/table_widget_angular (#17830) (6abb1da)

  • bump postcss from 8.5.14 to 8.5.23 in /packages/bigframes/bigframes/display/table_widget_angular (#17908) (e68eb8f)

  • bump tar from 7.5.16 to 7.5.20 in /packages/bigframes/bigframes/display/table_widget_angular (#17793) (3502d41)

  • require Protobuf 6.33.5+ (#17743) (d267342)

2.46.0 (2026-07-16)#

Features#

  • bigframes: Support groupby.agg/transform with udf transpiler (#17613) (cae94f9)

  • bigframes: support offset-based column access via iloc (#17367) (4253fab)

Bug Fixes#

  • bigframes: Fix sqlglot backend regressions (#17655) (91f93bc)

  • bump gradio from 6.15.0 to 6.15.1 in /packages/bigframes (#17712) (a85d59f)

  • bump mistune from 3.2.1 to 3.3.0 in /packages/bigframes (#17694) (e5f7fef)

  • bump soupsieve from 2.7 to 2.8.4 in /packages/bigframes (#17695) (635da34)

  • bump transformers from 5.3.0 to 5.5.0 in /packages/bigframes (#17700) (4b049c4)

  • emit bracketed inline array syntax for scalar subquery expressions (#17716) (ce5fd50)

Documentation#

  • make landing page quickstart runnable (fc423c8)

  • make landing page quickstart runnable (#17687) (fc423c8)

2.45.0 (2026-07-08)#

Features#

  • bigframes: add ai.classify, ai.score, ai.if_ to the df bq accessor (#17569) (4f94be8)

  • bigframes: Enable local udf execution (#17588) (b8ed34c)

  • bigframes: UDF transpiler handles some control flow (#17558) (a8cbde3)

  • support gemini-3.x models (#17615) (5d0efa3)

Bug Fixes#

  • bump gdal from 3.13.0 to 3.13.1 in /packages/bigframes (#17609) (0f4bfed)

  • bump gradio from 5.39.0 to 6.15.0 in /packages/bigframes (#17619) (bddda6a)

  • bump transformers from 4.54.1 to 5.3.0 in /packages/bigframes (#17610) (10eca3f)

2.44.0 (2026-06-25)#

Features#

  • add date functions to bigframes.bigquery module (#17514) (e5d2e35)

  • bigframes: add AI TVFs to the pandas bq accessor (#17402) (ee74e31)

  • Experimental transpilation of unannotated python callables (#17419) (ea9aad9)

  • support gemini-3.x models in loader and update default model to gemini-3.5-flash (#17557) (3619b29)

  • support interactive execution of deferred DataFrames in TableWidget (#17486) (421eebd)

Bug Fixes#

  • avoid invalid CAST(NULL AS NULL) in SQLGlot compiler (#17487) (3b79caa)

  • bigframes: world-readable temp zip in create_cloud_function (#17522) (e726878)

  • bump @angular/common, @angular/forms, @angular/platform-browser and @angular/router in /packages/bigframes/bigframes/display/table_widget_angular (#17525) (2f893b1)

  • bump langsmith from 0.8.0 to 0.8.18 in /packages/bigframes (#17518) (f23063f)

  • bump msgpack from 1.1.1 to 1.2.1 in /packages/bigframes (#17520) (36b5b7e)

  • bump undici and @angular/build in /packages/bigframes/bigframes/display/table_widget_angular (#17519) (6fc45e3)

  • handle empty endpoints during cloud function reuse (#17501) (4f5593a)

Documentation#

  • ensure that PlotAccessor is included in the API reference (#17513) (6febabf)

2.43.0 (2026-06-12)#

Documentation#

Features#

Bug Fixes#

2.42.0 (2026-06-08)#

Features#

Bug Fixes#

2.41.0 (2026-05-28)#

Documentation#

Features#

Bug Fixes#

Dependencies#

2.40.0 (2026-05-13)#

Documentation#

Features#

Bug Fixes#

2.39.0 (2026-03-31)#

Documentation#

Features#

Bug Fixes#

2.38.0 (2026-03-16)#

Documentation#

Features#

Bug Fixes#

2.37.0 (2026-03-03)#

Documentation#

Features#

Bug Fixes#

2.36.0 (2026-02-17)#

Documentation#

Features#

2.35.0 (2026-02-07)#

Documentation#

Features#

Bug Fixes#

2.34.0 (2026-02-02)#

Features#

Bug Fixes#

2.33.0 (2026-01-22)#

Features#

Bug Fixes#

2.32.0 (2026-01-05)#

Documentation#

Features#

Bug Fixes#

2.31.0 (2025-12-10)#

Features#

Bug Fixes#

2.30.0 (2025-12-03)#

Documentation#

Features#

Bug Fixes#

2.29.0 (2025-11-10)#

Features#

  • Add bigframes.bigquery.st_regionstats to join raster data from Earth Engine (#2228) (10ec52f)

  • Add DataFrame.resample and Series.resample (#2213) (c9ca02c)

  • SQL Cell no longer escapes formatted string values (#2245) (d2d38f9)

  • Support left_index and right_index for merge (#2220) (da9ba26)

Bug Fixes#

  • Correctly iterate over null struct values in ManagedArrowTable (#2209) (12e04d5)

  • Simplify UnsupportedTypeError message (#2212) (6c9a18d)

  • Support results with STRUCT and ARRAY columns containing JSON subfields in to_pandas_batches() (#2216) (3d8b17f)

Documentation#

  • Switch API reference docs to pydata theme (#2237) (9b86dcf)

  • Update notebook for JSON subfields support in to_pandas_batches() (#2138) (5663d2a)

2.28.0 (2025-11-03)#

Features#

Bug Fixes#

  • Correct connection normalization in blob system tests (#2222) (a0e1e50)

  • Improve error handling in blob operations (#2194) (d410046)

  • Resolve AttributeError in TableWidget and improve initialization (#1937) (4c4c9b1)

Documentation#

  • Update bq_dataframes_llm_output_schema.ipynb (#2004) (316ba9f)

2.27.0 (2025-10-24)#

Features#

Documentation#

2.26.0 (2025-10-17)#

⚠ BREAKING CHANGES#

  • turn Series.struct.dtypes into a property to match pandas (https://github.com/googleapis/python-bigquery-dataframes/pull/2169)

Features#

  • Add df.sort_index(axis=1) (#2173) (ebf95e3)

  • Enhanced multimodal error handling with verbose mode for blob image functions (#2024) (f9e28fe)

  • Implement cos, sin, and log operations for polars compiler (#2170) (5613e44)

  • Make all and any compatible with integer columns on Polars session (#2154) (6353d6e)

Bug Fixes#

  • blob.display() shows <NA> for null rows (#2158) (ddb4df0)

  • Turn Series.struct.dtypes into a property to match pandas (https://github.com/googleapis/python-bigquery-dataframes/pull/2169) (62f7e9f)

Documentation#

  • Clarify that only NULL values are handled by fillna/isna, not NaN (#2176) (8f27e73)

  • Remove import bigframes.pandas as bpd boilerplate from many samples (#2147) (1a01ab9)

2.25.0 (2025-10-13)#

Features#

  • Add barh, pie plot types (#2146) (5cc3c5b)

  • Add Index.eq for consts, aligned objects (#2141) (8514200)

  • Add output_schema parameter to ai.generate() (#2139) (ef0b0b7)

  • Create session-scoped cut, DataFrame, MultiIndex, Index, Series, to_datetime, and to_timedelta methods (#2157) (5e1e809)

  • Replace ML.GENERATE_TEXT with AI.GENERATE for audio transcription (#2151) (a410d0a)

  • Support string literal inputs for AI functions (#2152) (7600001)

Bug Fixes#