Google has announced the preview release of Python code completion for all BigQuery projects, powered by Gemini AI. This new feature aims to enhance the coding experience in BigQuery Studio by providing contextual code suggestions.

Key Features:

1. Contextual Recommendations:

   • Gemini offers suggestions based on the content in the query editor.
   • Provides logical next steps relevant to the current code context.

2. Availability:

   • Now available for all BigQuery projects in preview mode.

3. Permissions:

   • Requires the cloudaicompanion.instances.completeCode permission.
   • Included in the Cloud AI Companion User IAM role.

4. User Interface:

   • Accessible through the BigQuery Studio page.
   • Enabled via the Gemini toolbar option.

5. Customization:

   • Users can disable specific Gemini features if desired.

6. Feedback and Improvement:

   • Option to provide feedback on Gemini suggestions.
   • Users can opt to share prompt data to help improve the AI's performance.

This update reflects Google's ongoing efforts to integrate AI capabilities into its cloud services, potentially streamlining the coding process for BigQuery users working with Python notebooks.