Google has released a Log Analytics query builder, a new tool designed to ease access to observability data in Google Cloud.
Log Analytics can be used to query logs, other telemetry types, and transactional or business datasets from BigQuery. Google says that for many users, writing SQL queries is a significant hurdle, and this is especially true when dealing with critical log data.
The problem is that information is often nested in JSON format with varying schemas, requiring expert knowledge of how SQL works to extract the data. This can slow down troubleshooting and problem diagnostics because of the time and effort required to write effective SQL.
The new Log Analytics query builder aims to make this process easier. Its features start with the ability to create SQL to search all fields: The user simply pastes an error message or string to search across all their data and quickly pinpoint the source of an issue.
[フレーム]
There's a log schema preview that also provides inferred JSON key and value previews, and easier general JSON handling because the query builder automatically discovers and suggests JSON schemas and values. This allows the user to select and extract data without having to use commands such as JSON_VALUE, JSON_EXTRACT and CAST.
The UI also provides intelligent values for fields and filters, derived directly from your dataset, even including the nested fields in JSON. The UI also provides filtering and aggregation options, so users can apply common SQL operators, aggregations such as counts, mean, and percentiles. Creation of group-by clauses is also supported through the UI.
Other improvements include the ability to work with log scopes, so you can apply a query to a log scope by selecting the log scope from the view/scope picker. There's also a real-time SQL preview that updates as you build your query in the UI. You can switch to the code editor at any time to fine-tune your query; and a visualization dashboard that shows your query results and allows you to save them to a dashboard.
Log Analytics Query Builder is available now.
More Information
Related Articles
Google Announces Application Design Center
Google Improves BigLake And BigQuery
To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.
Hour Of AI 2025 About To Start
03/12/2025
Hour Of Code has been renamed. This year and from now on it will be called "Hour Of AI", giving in to this AI-dictated era. Another indication that coding has shifted from a task of manual labor [ ... ]
Robot Army Video As Robots Shipped En Masse
16/11/2025
To mark the "first mass delivery" of its Walker S2 Humanoid Robots, Chinese manufacturer UBTECH posted a spectacular video of its "Robot Army" on YouTube. Watch and be amazed.
- Windows XP Crocs Now On Sale
- Itential Unveils FlowAI: Bringing Governed AI Agents to Infrastructure Orchestration
- Build AI Apps with MCP Servers With DeepLearning.AI
- Microsoft Adds IQ Layer To Fabric
- Linkerd Adds MCP Support
- Apache Grails 7.0 Released
- GitHub Announces Agent HQ Organizer
- Next.js 16 Adds Cache Components
- Swift SDK For Android Now In Preview
- Anthropic's Prompt Engineering Tutorial
- AI Champion Ship Now Open
- Panic Over Arduino Ts and Cs
- Edera Open Sources Sprout
Comments
or email your comment to: comments@i-programmer.info