Google launched Python Completion in BigQuery

Gemini based Python Code Completion for the Editor

Photo by Pete Alexopoulos on Unsplash

After Google already launched Data Preparation and Joins helper based on Gemini for BigQuery they now also made Python Completion via Gemini general available for BigQuery.

Google announced that now Gemini in BigQuery can help you to complete Python code with contextually appropriate recommendations that are based on content in the query editor[1].

Google launched BigQuery Context aware Join Operation Recommendations

Within the BigQuery home menu you can use Python notebooks to query your data:

In these notebooks you can now use Gemini recommendations by typing Python code. For example %%bigquery. Gemini in BigQuery suggests code inline while you type. To turn on/off Gemini in BigQuery you need to activate the API and click on the Gemini icon in the right corner:

The Python integration makes Google BigQuery more attractive for Data Analyst and Data Scientists which are using Python over SQL in their daily activities. With these new Gemini features Python can also be an option to users…