NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI
PyPI
BigQuery DataFrames -- scalable analytics and machine learning with BigQuery
Latest stable
2.52.0
Last release 18 days ago
04 Nov 2026
Ships fairly regularly
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
1 version withdrawn
withdrawn after publishing
4 years old
130 releases · first in 2023
Drag across the ruler to compare, or tap a release to open it.
add back bigframes.bigquery.extract and bigframes.bigquery.generate_date_array
bigframes.bigquery.extract and bigframes.bigquery.generate_date_array (55482db)Your coding agent can read these notes before it upgrades. Set up the MCP server →
read BigLake Lakehouse tables through tables.get instead of pyiceberg
[1]: https://pypi.org/project/bigframes/#history
DataFrame.bigquery.ai.evaluate accessor (df96c47)bigframes.bigquery.ai.evaluate (AI.EVALUATE) (5aca1ed)support inplace parameter on DataFrame.fillna() and Series.fillna()
DataFrame.fillna() and Series.fillna()StreamingDataFrameINTO keyword in LOAD DATA OVERWRITE DDLOR expressions for AND chaining in SQLGlotbigframes.bigquery.extract and bigframes.bigquery.generate_date_array functionsclient_json_credentials samplecreate_table tri-library sampleextract_table combined sampleextract_table_json combined sampleload_table_gcs_csv combined samplepandas_to_gbq_simple combined sampleread_gbq_simple combined samplesamples/snippets directorybigframes.bigquery.ml APIbigframes.bigquery.ml module and partial orderingbigframes.bigquery.ml APIbigframes.bigquery.ml APIsload_table_dataframe to combined samplebigframes.bigquery.ml API and partial orderingquery_results_dataframe to combined samplebigframes: Transpiler supports more string ops
2.48.0
(2026-08-12)
This PR was generated with Release
Please. See
documentation.
Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>
GitOrigin-RevId: 102c940183ac1cf5670b46c17a47f559926634de
Change-Id: Ia15429511df3ebed77f5b4ad45779f8c6be0316d
bigframes: add ai.embed and ai.similarity to bigquery accessor
bigframes: Support groupby.agg/transform with udf transpiler
bigframes: add ai.classify, ai.score, ai.if_ to the df bq accessor
add date functions to bigframes.bigquery module
bigframes.bigquery module (#17514) (e5d2e35)add bigframes.bigquery.bit_count and conversion scalar function
bigframes.bigquery.bit_count and conversion scalar function (#17433) (7f29823f)preserve aliases on cast columns and fix star selection in sqlglot (#17394) (#17455) (145034a3)
improve error message when unescaped { are found in SQL cells (#17346) (3a90cc8e)
bump pyarrow from 15.0.2 to 23.0.1 in /packages/bigframes (#17386) (f59c2b2a)
bigframes.bigquery.bit_count and conversion scalar function (#17433) (7f29823fadb3cff42dbe666f8c7aa33bab3c7021){ are found in SQL cells (#17346) (3a90cc8e867c8a2d2f8060858fde9eda94f80a54)Add ai_generate functions to the dataframe bq accessor
Add ai_generate functions to the dataframe bq accessor (#17302) (6b62cb6f)
support automatic per-cell execution history filtering and isolated callbacks (#17144) (7d440111)
create Series.bigquery.function_name accessors for array and AEAD functions (#17279) (d01a4ba3)
Series.bigquery.function_name accessors for array and AEAD functions (#17279) (d01a4ba30040cfcb6498d0e9ef3ed3a54d56239d)complete deprecation and cleanup of multimodal blob APIs
bigframes.bigquery (#17213) (4f8a6c81797204f4334c7251c244bc0b6bd568e2)bigframes.bigquery.deterministic_decrypt* and bigframes.bigquery.deterministic_encrypt functions (#17212) (85f36725802f3e7ad16156ca9e957e61d57d3112)bigframes.bigquery.aead.* scalar functions (#17168) (a7e4d048e254cdb723df0a47ccbd8d09aed00c7a)Add docs to the to_csv methods of dataframe and series
hparam_range and hparam_candidates to bigframes.bigquery.create_model (#16640) (ca47835ce0e381c0833545ca1cf7734c3c34ceb5)copy argument warning in to_pandas (#16917) (fe5245b8f20dd94231e72e2572609e029ee137c7)add df.bigquery.ai.forecast method to pandas dataframe accessor
add df.bigquery.ai.forecast method to pandas dataframe accessor (#2518) (1126cec9)
support full round-trip persistence for multimodal reference cols (#2511) (494a0a11)
expose DataFrame.bigquery in both pandas and bigframes DataFrames (#2533) (69fe3176)
to_gbq may swap data columns when replace table (#2532) (17ecc65e)
handle aggregate operations on empty selections (#2510) (34fb5daa)
Localize BigQuery log suppression for gbq.py (#2541) (af49ca29)
Respect remote function config changes even if logic unchanged (#2512) (b9524284)
support melting empty DataFrames without crashing (#2509) (e8c46032)
df.bigquery.ai.forecast method to pandas dataframe accessor (#2518) (1126cec9cdfcc1ec1062c60e5affbe1b60223767)Add bigframes.bigquery.rand() function
Add bigframes.bigquery.rand() function (#2501) (5c43efb7)
add df.bigquery pandas accessor (#2513) (91b6c245)
Add str, dt accessors to pd.col Expression objects (#2488) (ce5de570)
add bigquery.ml.get_insights function (#2493) (d29a6095)
use EUC for AI IF, CLASSIFY, and SCORE when connection is not provided (#2507) (fe94910a)
handle unsupported types and empty results in describe (#2506) (2326ad6a)
no longer automatically use anywidget in the %%bqsql magics (#2504) (43353e2b)
df.bigquery pandas accessor (#2513) (91b6c245521218bb78b543885e1b9424278ce2ab)bigframes.bigquery.rand() function (#2501) (5c43efb745118f506ecc30196da68e9d6f4346dc)%%bqsql magics (#2504) (43353e2bc9ffbc38b7383c24ecaac80d3b8bab32)Add cloud_function_cpus option to remote_function
Add cloud_function_cpus option to remote_function (#2475) (4caf74cc)
add display.render_mode to control DataFrame/Series visualization (#2413) (7813eaa6)
Support pd.col expressions with .loc and getitem (#2473) (ae5c8b32)
add support for Python 3.14 (#2232) (c25a6d01)
Support pd.col simple aggregates (#2480) (cb00daab)
add dt.tz_localize() (#2469) (f70f93a1)
Update bigquery.ai.generate_table output_schema to allow Mapping type (#2463) (f7fd1895)
upload local data through write API if nested JSONs detected (#2478) (01dc5a34)
allow IsInOp with same dtypes regardless nullable (#2466) (1d81b414)
Add code examples to configuration docstrings (#2352) (3c21993e)
Move readme content to new User Guide section (#2464) (61a94845)
add code sample and docstring for bpd.options.experiments.sql_compiler (#2474) (867951bc)
use direct API for image (#2465) (8a1a82f7)
Fix recall_score doc example (#2477) (a6f499c1)
Skip inherited methods, use autosummary only for big classes (#2470) (a9512498)
add bigframes default connection warning (#2471) (f1bbba23)
Initial support for biglake iceberg tables
fix generate_text and generate_table input docs (#2455) (078bd32e)
update multimodal dataframe notebook to use public APIs (#2456) (342fa723)
use direct API for pdf chunk and pdf extract (#2452) (543ce52c)
Add EXIF metadata extraction example to multimodal notebook (#2429) (84c6f883)
Update multimodal notebook to use public runtime helpers (#2451) (e36dd8b4)
Add bigframes.pandas.col with basic operators
Add bigframes.pandas.col with basic operators (#2405) (12741677)
remove redundant "started." messages from progress output (#2440) (2017cc2f)
add bigframe.bigquery.load_data function (#2426) (4b0f13b2)
Disable progress bars in Anywidget mode (#2444) (4e2689a1)
add bigquery.ai.generate_text function (#2433) (5bd0029a)
Disable progress bars in Anywidget mode to reduce notebook clutter (#2437) (853240da)
Add a bigframes cell magic for ipython (#2395) (e6de52de)
add bigframes.bigquery.ai.generate_embedding (#2343) (e91536c8)
always display the results in the %%bqsql cell magics output (#2439) (2d973b54)
exlcude gcsfs 2026.2.0 (#2445) (311de31e)
suppress JSONDtypeWarning in Anywidget mode and clean up progress output (#2441) (e0d185ad)
bigframes.bigquery.ai.generate_embedding (#2343) (e91536c8a5b2d8d896767510ced80c6fd2a68a97)%%bqsql cell magics output (#2439) (2d973b54550f30429dbd10894f78db7bb0c57345)add deprecation warnings for .blob accessor and read_gbq_object_table
bigframes.pandas.options.experiments.sql_compiler for switching the backend compiler (#2417) (7eba6ee03f07938315d99e2aeaf72368c02074cf)add bigquery.ml.transform function
add bigquery.ml.transform function (#2394) (1f9ee373)
Add dark mode to anywidget mode (#2365) (2763b41d)
Add max_columns control for anywidget mode (#2374) (34b5975f)
Configure Biome for Consistent Code Style (#2364) (81e27b3d)
Add BigQuery ObjectRef functions to bigframes.bigquery.obj (#2380) (9c3bbc36)
Stabilize interactive table height to prevent notebook layout shifts (#2378) (a634e976)
implement retry logic for cloud function endpoint fetching (#2369) (0f593c27)
Throw if write api commit op has stream_errors (#2385) (7abfef05)
bigframes.bigquery.obj (#2380) (9c3bbc36983dffb265454f27b37450df8c5fbc71)generate sitemap.xml for better search indexing
add bigframes.bigquery.ml methods
add bigframes.bigquery.ml methods (#2300) (719b278c)
add 'weekday' property to DatatimeMethod (#2304) (fafd7c73)
_repr_mimebundle_ (#2316) (e4e3ec85)bigframes.bigquery.ml methods (#2300) (719b278c844ca80c1bec741873b30a9ee4fd6c56)Support mixed scalar-analytic expressions
Support mixed scalar-analytic expressions (#2239) (20ab469d)
Allow drop_duplicates over unordered dataframe (#2303) (52665fa5)
Preserve source names better for more readable sql (#2243) (64995d65)
use end user credentials for bigframes.bigquery.ai functions when connection_id is not present (#2272) (7c062a68)
pivot_table supports fill_value arg (#2257) (8f490e68)
Support builtins funcs for df.agg (#2256) (956a5b00)
add bigquery.json_keys (#2286) (b487cf1f)
Add agg/aggregate methods to windows (#2288) (c4cb39dc)
Add bigframes.pandas.crosstab (#2231) (c62e5535)
Implement single-column sorting for interactive table widget (#2255) (d1ecc61b)
Pass credentials properly for read api instantiation (#2280) (3e3fe259)
Update max_instances default to reflect actual value (#2302) (4489687e)
Improve Anywidget pagination and display for unknown row counts (#2258) (508deae5)
Fix issue with stream upload batch size upload limit (#2290) (6cdf64b0)
calling info() on empty dataframes no longer leads to errors (#2267) (95a83f77)
do not warn with DefaultIndexWarning in partial ordering mode (#2230) (cc2dbae6)
update docs and tests for Gemini 2.5 models (#2279) (08c0c0c8)
Add Google Analytics configuration to conf.py (#2301) (0b266da1)
fix LogisticRegression docs rendering (#2295) (32e53134)
update API reference to new dataframes.bigquery.dev location (#2293) (da064397)
use autosummary to split documentation pages (#2251) (f7fd2d20)
dataframes.bigquery.dev location (#2293) (da064397acd2358c16fdd9659edf23afde5c882a)bigframes.bigquery.ai functions when connection_id is not present (#2272) (7c062a68c6a3c9737865985b4f1fd80117490c73)Full Changelog: https://github.com/googleapis/python-bigquery-dataframes/compare/v2.29.0...v2.29.1 ### Bug Fixes * Bound sqlglot version below 28
Full Changelog: https://github.com/googleapis/python-bigquery-dataframes/compare/v2.29.0...v2.29.1
Add bigframes.bigquery.st_regionstats to join raster data from Earth Engine
to_pandas_batches() (#2216) (3d8b17f)Add bigframes.bigquery.st_simplify
read_gbq (#1895) (d97cafc)Update AI operators deprecation notice
np.isnan and np.isfinite ufuncs (#2188) (68723bc)turn Series.struct.dtypes into a property to match pandas
all and any compatible with integer columns on Polars session (#2154) (6353d6e)blob.display() shows <NA> for null rows (#2158) (ddb4df0)Add Index.__eq__ for consts, aligned objects
cut, DataFrame, MultiIndex, Index, Series, to_datetime, and to_timedelta methods (#2157) (5e1e809)Add ai.classify() to bigframes.bigquery package
Add ai.generate_double to bigframes.bigquery package
Add ai.generate_int to bigframes.bigquery package
GroupBy.__iter__ (#1394) (c56a78c)Index.to_list() (#2106) (60056ca)DataFrame.drop (#2105) (3487f13)Support average='binary' in precision_score()
Add __dataframe__ interchange support
__dataframe__ interchange support (#2063) (3b46a0d)repr_mode (#2082) (5ce5d63)add allow_large_results option to read_gbq_query, aligning with bpd.options.compute.allow_large_results option
allow_large_results option to read_gbq_query, aligning with bpd.options.compute.allow_large_results option (#1935)allow_large_results option to read_gbq_query, aligning with bpd.options.compute.allow_large_results option (#1935) (a7963fe)Add reset_index names, col_level, col_fill, allow_duplicates args
Add bigframes.pandas.options.display.precision option
bigframes.pandas.options.display.precision option (#1979) (15e6175)repr_mode = "anywidget", numeric values align right (15e6175)Add st_buffer, st_centroid, and st_convexhull and their corresponding GeoSeries methods
st_buffer, st_centroid, and st_convexhull and their corresponding GeoSeries methods (#1963) (c4c7fa5)remote_function more robust when there are create_function retries (#1973) (cd954ac)Dynamic table width for better display across devices
_read_gbq_colab creates hybrid session
Add code samples for dbt bigframes integration
max_batching_rows, container_cpu, and container_memory for udf (#1897) (8baa912)Add __contains__ to Index, Series, DataFrame
__contains__ to Index, Series, DataFrame (#1899) (07222bf)thresh param for Dataframe.dropna (#1885) (1395a50)date data type for to_datetime() (#1902) (24050cb)df.to_pandas_batches() returns one empty DataFrame if df is empty
Add bpd.read_arrow to convert an Arrow object into a bigframes DataFrame
bpd.read_arrow to convert an Arrow object into a bigframes DataFrame (#1855) (633bf98)deploy_remote_function and deploy_udf functions to immediately deploy functions to BigQuery (#1832) (c706759)dry_run=True from bpd._read_gbq_colab with local pandas DataFrame (#1867) (fab3c38)add required param 'engine' to multimodal functions
bpd.options.compute.maximum_result_rows option to limit client data download (#1829) (e22a3f6)bpd.options.display.repr_mode = "anywidget" to create an interactive display of the results (#1820) (be0a3cf)Add bbq.json_query_array and warn bbq.json_extract_array deprecated
remote_function (#1796) (e586151)Implement item() for Series and Index
read_csv with both index_col and use_cols behavior inconsistency with pandas (#1785) (ba7c313)Add bbq.json_query and warn bbq.json_extract deprecated
ai.map() parameter list is not backward-compatiblebpd.options.bigquery.requests_transport_adapters option (#1755) (bb45db8)inplace=True in rename and rename_axis (#1744) (734cc65)unique() for Index (#1750) (27fac78)MatrixFactorization.score(X, y) (#1726) (55c07e9)allow_large_results=False (#1763) (15f3f2a)GeminiTextGenerator.predict(..., output_schema={...}) sample notebook (#1748) (bd07e05)bqclient._http.credentials instead of bqclient._credentials (#1784) (6e63eca)Deprecate bpd.options.bigquery.allow_large_results in favor of bpd.options.compute.allow_large_results
dt accessors (#1692) (9d4a59d).dt.days, .dt.seconds, dt.microseconds, and dt.total_seconds() for timedelta series. (#1713) (2b3a45f)DatetimeIndex class (#1719) (c3c830c)isocalendar() for dt accessor" (#1717) (0479763)Series.apply for direct udfs (#1673) (1a658b2)_TABLE_SUFFIX in to_gbq() (#1691) (8ec6079)read_gbq with wildcard tables (#1661) (5c125c9)bpd.options.bigquery.allow_large_results in favor of bpd.options.compute.allow_large_results (#1597) (18780b4)Add dry_run parameter to read_gbq(), read_gbq_table() and read_gbq_query()
Add gemini-2.0-flash-001 and gemini-2.0-flash-lite-001 to fine tune score endponts and multimodal endpoints
PreviewWarning for the bpd.udf (#1629) (48d10d1)Add bigframes.bigquery.st_distance function
bigframes.bigquery.st_distance function (#1637) (bf1ae70)read_csv index_col parameter support (#1631) (f4e5b26)Warn the deprecated max_download_size, random_state and sampling_method parameters in (DataFrame|Series).to_pandas()
dataset and name params mandatory in udf (#1619)remote_function to internal-only (#1544)remote_function params keyword only (#1537)remote_function default service account explicit (#1537)allow_large_results=False by default (#1541)on parameter in dataframe.rolling() and dataframe.groupby.rolling() (#1556) (45c9d9f)input_types, output_type, and dataset to be used positionally in remote_function (#1560) (bcac8c6)remote_function to internal-only (#1544) (c848a80)remote_function default service account explicit (#1537) (9eb9089)allow_large_results=False by default (#1541) (e9fb712)max_download_size, random_state and sampling_method parameters in (DataFrame|Series).to_pandas() (#1573) (b9623da)to_pandas_batches() respects page_size and max_results again (#1572) (27c5905)page_size works correctly in to_pandas_batches when max_results is not set (#1588) (570cff3)dataset and name params mandatory in udf (#1619) (637e860)KeyError in bpd.concat with empty DF and struct/array types DF (#1568) (b4da1cf)bigquery_connection in [@bpd](https://github.com/bpd).udf docstring (#1609) (ef63772)time_series_id_col feature (#1577) (1e4cd9c)TextEmbedddingGenerator, GeminiTextGenerator, and other bigframes.ml.llm classes (#1570) (89ab33e)GeminiTextGenerator (#1562) (0cc6784)Remove gemini-1.5 deprecation warning for GeminiTextGenerator
remote_function to internal-only (#1544)remote_function params keyword only (#1537)remote_function default service account explicit (#1537)allow_large_results=False by default (#1541)input_types, output_type, and dataset to be used positionally in remote_function (#1560) (bcac8c6)remote_function to internal-only (#1544) (c848a80)remote_function default service account explicit (#1537) (9eb9089)allow_large_results=False by default (#1541) (e9fb712)KeyError in bpd.concat with empty DF and struct/array types DF (#1568) (b4da1cf)GeminiTextGenerator (#1562) (0cc6784)Add deprecation warning to TextEmbeddingGenerator model, espeically gemini-1.0-X and gemini-1.5-X
closed parameter in rolling() (#1539) (8bcc89b)GeoSeries.difference() and bigframes.bigquery.st_difference() (#1471) (e9fe815)GeoSeries.intersection() and bigframes.bigquery.st_intersection() (#1529) (8542bd4)to_pandas() (#1436) (75fc7e0)udf to preview (#1536) (4a7fe4d)Add support for the 'right' parameter in 'pandas.cut'
read_gbq_function (#1476) (802183d)reading JSON data as a custom arrow extension type
== instead of is for timedelta type equality checks (#1480) (0db248b)(Preview) Support diff() for date series
diff() for date series (#1423) (521e987)allow_large_results option to many I/O methods. Set to False to reduce latency (#1428) (dd2f488)GeoSeries.boundary() (#1435) (32cddfe)cloud_function_service_account is used in remote_function (#1424) (fe7463a)(Preview) Support diff aggregation for timestamp series.
GeoSeries.from_wkt() and GeoSeries.to_wkt() (#1401) (2993b28)read_gbq_function (#1412) (4b60049)One column per quarter.