Stay organized with collections Save and categorize content based on your preferences.
BigQuery DataFrames provides a Pythonic DataFrame and machine learning (ML) API powered by the BigQuery engine.
bigframes.pandas
provides a pandas-compatible API for analytics.
bigframes.ml
provides a scikit-learn-like API for ML.
BigQuery DataFrames is an open-source package. You can run pip install --upgrade bigframes
to install the latest version.
Version 2.0 introduces breaking changes for improved security and performance. Key default behaviors have changed, including
Large Results (>10GB): The default value for allow_large_results
has changed to False
. Methods like to_pandas()
will now fail if the query result’s compressed data size exceeds 10GB, unless large results are explicitly permitted.
Remote Function Security: The library no longer automatically lets the Compute Engine default service account become the identity of the Cloud Run functions. If that is desired, it has to be indicated by passing cloud_function_service_account="default"
. And network ingress now defaults to "internal-only"
.
@remote_function Argument Passing: Arguments other than input_types
, output_type
, and dataset
to remote_function
must now be passed using keyword syntax, as positional arguments are no longer supported.
@udf Argument Passing: Arguments dataset
and name
to udf
are now mandatory.
Endpoint Connections: Automatic fallback to locational endpoints in certain regions is removed.
LLM Updates (Gemini Integration): Integrations now default to the gemini-2.0-flash-001
model. PaLM2 support has been removed; please migrate any existing PaLM2 usage to Gemini. Note: The current default model will be removed in Version 3.0.
Important: If you are not ready to adapt to these changes, please pin your dependency to a version less than 2.0 (e.g., bigframes==1.42.0
) to avoid disruption.
To learn about these changes and how to migrate to version 2.0, see the updated introduction guide.
DocumentationRead Introduction to BigQuery DataFrames and try the BigQuery DataFrames quickstart to get up and running in just a few minutes.
LicenseBigQuery DataFrames is distributed with the Apache-2.0 license.
It also contains code derived from the following third-party packages:
For details, see the third_party directory.
For further help and provide feedback, you can email us at bigframes-feedback@google.com.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-12 UTC.
[[["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-08-12 UTC."],[],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4