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 posts in one place? I put 350+ articles on GA4, BigQuery, attribution, and metrics into one searchable library.
Go here to explore it for FREE.
