Google BigQuery has introduced new AI-powered SQL translation capabilities using the Gemini model, offering enhanced translation customization and explanation features.
Interactive Translation Mode
Now generally available:
- Customizable GoogleSQL translations
- Translation rule creation
- Migration-specific adjustments
- Location-specific support
- Rule-based translation modifications
Batch Translation Features
Preview features include:
- AI-powered translation suggestions
- Gemini model integration
- Configuration YAML file support
- Automated batch processing
- Enhanced translation accuracy
Query Explanation Tools
New preview capabilities:
- Gemini-generated explanations
- SQL query summaries
- Translation difference identification
- Inconsistency detection
- Source-to-target comparisons
Implementation Details
The update provides:
- Interactive customization tools
- Batch processing options
- Automated explanations
- Migration support features
- Enhanced translation accuracy
These new features represent BigQuery's integration of Gemini AI capabilities to improve SQL translation and understanding across different SQL dialects.