Google has enhanced its BigQuery ML platform with new formatting capabilities for bucketing functions and improvements to set operations.
Enhanced Bucketing Function Formatting
The ML.BUCKETIZE and ML.QUANTILE_BUCKETIZE functions now support customizable output formatting through the output_format argument. Users can format results in three ways:
- String format:
bin_<bucket_index> - Interval notation
- JSON-formatted string
Set Operation Improvements
BigQuery has made the BY NAME and CORRESPONDING modifiers generally available for set operations. These modifiers enable:
- Column matching by name instead of position
- Enhanced flexibility in data manipulation
- Simplified set operation syntax
These updates represent Google's continued effort to improve BigQuery's functionality and user experience in handling complex data operations.
