Summary
BigQuery's new 'group by all' clause simplifies query-writing by auto-grouping rows, but caution is advised in production environments. BigQuery Data Transfer Service now includes data transfers from Facebook Ads, Salesforce, Oracle, and ServiceNow. From March 2024, APIs supporting BigQuery Studio will auto-activate in Google Cloud projects with BigQuery. Other updates include anomaly detection with BigQuery ML, dataset undeletion, and reduced time between scheduled queries.