Google Enhances Gemini in BigQuery with Python Code Completion

Google has expanded its Gemini in BigQuery capabilities with a new Python code completion feature, now generally available (GA). This addition focuses specifically on providing contextually relevant Python code suggestions within the BigQuery environment.

The newly released Python code completion functionality offers recommendations that are contextually appropriate as users type. This intelligent assistance suggests logical next steps relevant to the current code context, helping users iterate on their Python code more efficiently within BigQuery notebooks.

How to Access Python Code Completion

Users can try this new feature by following these steps:

1. Navigate to the BigQuery Studio page
2. In the query editor's tab bar, click the drop-down arrow next to SQL query, then select Python notebook
3. A new notebook will open with example queries against the bigquery-public-data.ml_datasets.penguins public dataset
4. Begin typing Python code (for example %%bigquery)
5. Gemini in BigQuery will provide inline code suggestions while typing
6. Press Tab to accept any suggestion

Managing Gemini Features

For users who prefer to customize their experience:

1. Go to the BigQuery Studio page in the Google Cloud console
2. Click Gemini in the BigQuery toolbar
3. Clear specific query assistant features you want to turn off from the displayed list

This Python code completion enhancement represents Google's continued investment in improving developer productivity within its BigQuery platform through targeted AI-powered assistance.