Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

Implement AI.GENERATE_EMBEDDING function in bigframes.bigquery.ai.

---
*PR created automatically by Jules for task
[11924477578091076513](https://jules.google.com/task/11924477578091076513)
started by @tswast*

---------

Co-authored-by: google-labs-jules[bot] <161369871+google-labs-jules[bot]@users.noreply.github.com>
Co-authored-by: Tim Sweña <swast@google.com>
Co-authored-by: Shenyang Cai <sycai@users.noreply.github.com>

Skip all blob tests

Fixes #<481790217> 🦕

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

* Added the API for ai.generate_text
* Fixed SQL syntax bug of ai.generate_embedding
* Refactored the code base to keep util functions organized.

Fixes b/481092205

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

…2439)

This changes makes the magics function more similar to SQL Cell.

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

…ter (#2437)

This PR improves the user experience of the interactive Anywidget
display mode by automatically disabling progress bars and job logging
during widget operations.

  Changes:
- Wrapped the get_anywidget_bundle call in repr_mimebundle with
option_context("display.progress_bar", None) to silence the initial
widget load.
- Wrapped TableWidget._initial_load and TableWidget._set_table_html
methods to silence subsequent interactions like pagination and sorting.


  Motivation:
When interacting with the TableWidget (paging, sorting), the repeated
appearance of progress bars creates visual noise and clutter in the
notebook output cell, distracting from the interactive data exploration
experience. This change ensures a clean and seamless interface.

Verified at:
- vs code notebook:
https://screencast.googleplex.com/cast/NTY2NDkzOTc4Mjk2MzIwMHwwYjU0Njc1MS03MA
- colab notebook:
https://screencast.googleplex.com/cast/NjIzMjM0NTEyNzQxOTkwNHxiMDM0YzM2Ni1iZQ

Fixes #<482120359> 🦕

…ook clutter" (#2442)

Reverts #2437

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<482422167> 🦕

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Fixes #<issue_number_goes_here> 🦕

This PR improves the user experience of the interactive Anywidget
display mode by automatically disabling progress bars and job logging
during widget operations.

Changes:

Wrapped the get_anywidget_bundle call in repr_mimebundle with
option_context("display.progress_bar", None) to silence the initial
widget load.
Wrapped TableWidget._initial_load and TableWidget._set_table_html
methods to silence subsequent interactions like pagination and sorting.
Motivation:
When interacting with the TableWidget (paging, sorting), the repeated
appearance of progress bars creates visual noise and clutter in the
notebook output cell, distracting from the interactive data exploration
experience. This change ensures a clean and seamless interface.

Verified at:

vs code notebook: screen/B7hCnXdLeTiFshr
colab notebook: screen/4d8Kpo5ZbbfZUBb

Fixes #< 482120359 > 🦕

Follow-up to
#2419

Thank you for opening a Pull Request! Before submitting your PR, there
are a few things you can do to make sure it goes smoothly:
- [ ] Make sure to open an issue as a
[bug/issue](https://github.com/googleapis/python-bigquery-dataframes/issues/new/choose)
before writing your code! That way we can discuss the change, evaluate
designs, and agree on the general idea
- [ ] Ensure the tests and linter pass
- [ ] Code coverage does not decrease (if any source code was changed)
- [ ] Appropriate docs were updated (if necessary)

Context: b/479944983 🦕

…s output (#2441)

This PR improves the user experience when using the interactive
anywidget display mode (bpd.options.display.repr_mode = "anywidget") by
reducing console noise.

Verified at:
vs code notebook: screen/ACCJRLwyThciMk8
colab notebook: screen/BhNxzpvckYg9Wp8

Fixes #<482120359> 🦕

PR created by the Librarian CLI to initialize a release. Merging this PR
will auto trigger a release.

Librarian Version: v0.7.0
Language Image:
us-central1-docker.pkg.dev/cloud-sdk-librarian-prod/images-prod/python-librarian-generator@sha256:e7cc6823efb073a8a26e7cefdd869f12ec228abfbd2a44aa9a7eacc284023677
<details><summary>bigframes: 2.35.0</summary>

##
[2.35.0](v2.34.0...v2.35.0)
(2026-02-07)

### Features

* Add bigframes.pandas.col with basic operators (#2405)
([1274167](12741677))

* remove redundant &#34;started.&#34; messages from progress output
(#2440)
([2017cc2](2017cc2f))

* add bigframe.bigquery.load_data function (#2426)
([4b0f13b](4b0f13b2))

* Disable progress bars in Anywidget mode (#2444)
([4e2689a](4e2689a1))

* add bigquery.ai.generate_text function (#2433)
([5bd0029](5bd0029a))

* Disable progress bars in Anywidget mode to reduce notebook clutter
(#2437)
([853240d](853240da))

* Add a bigframes cell magic for ipython (#2395)
([e6de52d](e6de52de))

* add `bigframes.bigquery.ai.generate_embedding` (#2343)
([e91536c](e91536c8))

### Bug Fixes

* always display the results in the `%%bqsql` cell magics output (#2439)
([2d973b5](2d973b54))

* exlcude gcsfs 2026.2.0 (#2445)
([311de31](311de31e))

* suppress JSONDtypeWarning in Anywidget mode and clean up progress
output (#2441)
([e0d185a](e0d185ad))

### Documentation

* fix cast method shown on public docs (#2436)
([ad0f33c](ad0f33c6))

</details>