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.
Want all my best GA4-BQ queries in one place? I turned them into a Chrome extension — top SQL queries you can search and copy in seconds.
Go here to install it for FREE.
Prefer the web version? It's here.
