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.
If you work with GA4 to BigQuery exports, be sure to check out my SQL cheat sheet.
