Monitoring Query Language Now GA In Cloud Monitoring

Monitoring Query Language, MQL - that powers advanced querying for internal Google production users - is now available to Cloud users.

Recently, Google announced the General Availability of Monitoring Query Language (MQL) in Cloud Monitoring.

Google said that Monitoring Query Language represents a decade of learnings and improvements on Google’s internal metric query language. MQL - that  powers advanced querying for internal Google production users - is now available to Google Cloud users.

MQL can be used to create ratio-based charts and alerts, perform time-shift analysis, and apply mathematical, logical, table operations, and other functions to metrics.

It allows you to Fetch, join, and aggregate over multiple metrics; and select by arbitrary, rather than predefined, percentile values. You can also create new labels to aggregate data by, using arbitrary string manipulations including regular expressions.

To access the MQL Query Editor, you just need to click on the button in Cloud Monitoring Metrics Explorer. Create a query in the Metrics Explorer UI, and click the Query Editor button. This converts the existing query into an MQL query.

Source: Google

Monitoring Query Language is built using operations and functions. These operations are linked together using the common ‘pipe’ idiom -  so, the output of one operation becomes the input to the next. This makes it possible to build up complex queries incrementally.