Gemini + BigQuery: A New Era of Analytics with AI or Money Down the Drain?

Haven’t tried the Gemini integration with BigQuery yet? Try it for free until January 25, 2025 (after which a subscription will be required).

In my opinion, the most useful features of Gemini + BigQuery are the tools for working with code in BigQuery Studio and Notebooks:

1. SQL generation tool
2. Prompt to generate SQL queries
3. Complete a SQL query
4. Explain a SQL query
5. Generate Python code
6. Python code completion

Although it's still not perfect (but hey, it's free!), the standout feature is Complete a SQL query. It works quite well: just hit space, and Gemini will suggest several code completions, many of which are genuinely helpful. It’s not Copilot, but it definitely cuts down on routine tasks.