The REGEXP_EXTRACT_GROUPS function produces substrings that match multiple capturing groups in a regular expression.

The Data Engineering Agent now integrates with Google Drive, letting you provide Google Sheets files, CSV, or JSONL files as input for your data engineering…

The Data Engineering Agent now integrates with Google Drive, letting you provide Google Sheets files, CSV, or JSONL files as input for your data engineering pipelines.

You can now use conversational analytics in Connected Sheets to ask questions and analyze your BigQuery data using natural language.

The Gemini side panel can help you translate your questions into optimized SQL queries and execute them, summarize key trends, and insert live, refreshable database objects directly into your workbook.