Google BigQuery now allows admins to customize the BigQuery Studio interface for projects or organizations. It supports Spanner external datasets with enhanced security features. Data loading options include time zone and date/time formatting parameters in preview. A new Apache Spark demo notebook is available to demonstrate serverless Spark capabilities. These updates improve integration, flexibility, and user experience.
Looker Studio enables Code Interpreter by default for Pro users when Gemini in Looker and Trusted Tester settings are active in the Google Cloud project. It converts natural language questions into Python code for advanced analysis and visualizations. Admins can control the feature via User Settings. Requirements include a Pro subscription, Google Cloud project, and enabled settings, enhancing AI-powered analytics in Looker Studio.
Google BigQuery offers continuous queries for real-time data processing and ML inference, outputting to BigQuery, Pub/Sub, or Bigtable. It supports multiple ingestion methods, monitoring, and autoscaling. Use cases include personalized messaging, anomaly detection, event-driven pipelines, data enrichment, and reverse ETL. Spanner supports cross-regional federated queries from BigQuery, enabling cross-region queries without egress fees in preview.
Create professional Google Ads performance reports in Google Slides with AI insights and visualizations. Transform Google Ads data into polished presentations featuring AI-generated insights and custom visuals to impress stakeholders and streamline reporting. Use cases include reducing manual reporting time, presenting insights without design skills, maintaining reporting schedules, identifying trends, and sharing campaign insights for strategic decisions.
BigQuery now allows scheduling automated data transfers from Snowflake using the Data Transfer Service, currently in preview, staging data in the same cloud or Amazon S3 for AWS accounts. It supports cross-region batch loading and exporting data across any regions with simple commands, now generally available. Vector indexes support the TreeAH type with Google's ScaNN algorithm for efficient batch processing of many embeddings, also generally available.
Google Cloud has introduced a Generative AI Leader certification for non-technical professionals, reflecting the rising need for AI skills across various roles. This certification enables managers to leverage generative AI effectively. The $99 exam evaluates knowledge in AI fundamentals, Google Cloud's offerings, techniques for enhancing AI output, and business strategies. A free learning path is also provided to help candidates prepare.
Google has announced new SQL features in BigQuery that enhance data grouping and query flexibility. The GROUP BY STRUCT feature allows grouping of STRUCT types if all fields are groupable, applicable only in GROUP BY or SELECT DISTINCT clauses. The GROUP BY ARRAY feature supports ARRAY types under similar conditions. Additionally, the GROUP BY ALL clause infers grouping keys from SELECT items while excluding expressions with aggregate or window functions.
Google has introduced enhanced grid line customization for cartesian charts in Looker Studio, allowing users to set specific colors and line styles for individual axis grid lines. This update improves clarity in multi-axis charts and is available for reports with modern charts enabled. This feature enhances visualization flexibility, giving data analysts more control over their visualizations and supporting clearer communication of information.
'Google has enhanced BigQuery with improved resource monitoring tools, including a six-hour event timeline and a new reservation slot usage view for better resource management. Users can visualize query execution flows more effectively with the new Query text section. Additionally, BigQuery now supports multimodal analysis and transformation workflows in SQL and Python, allowing integration of unstructured data and generative AI for analysis.
Google has introduced an autosave feature for BigQuery saved queries that automatically saves changes to query text two seconds after typing stops. These changes are visible in the Version history as "Your changes" but do not create a new version until saved. Users can save a new version through the Google Cloud console. This feature enhances productivity while allowing users to control when changes are visible to collaborators.
