Maintained with ☕️ by
IcePanel logo

You can now create and use Python user-defined functions (UDFs) in BigQuery

Share

Services

## Feature You can now create and use [Python user-defined functions](https://cloud.google.com/bigquery/docs/user-defined-functions-python) (UDFs) in BigQuery. Python UDFs support the use of additional libraries and external APIs. This feature is in [preview](https://cloud.google.com/products#product-launch-stages). ## Change The Python code that you generate using [Gemini in BigQuery Notebooks](https://cloud.google.com/bigquery/docs/write-sql-gemini) is now much more likely to leverage your data. With this change, BigQuery Notebooks can intelligently pull relevant table names directly from your BigQuery project, resulting in personalized, executable Python code. ## Feature You can now [generate Dataframes code in BigQuery Notebooks](https://cloud.google.com/bigquery/docs/write-sql-gemini#dataframe) that use BigFrames libraries. In your code generation prompt, include the word `BigFrames` to generate code that uses [BigQuery DataFrames](https://cloud.google.com/bigquery/docs/use-bigquery-dataframes). This feature is in [preview](https://cloud.google.com/products#product-launch-stages).