Release - April 30th, 2021

✨ New ✨

Dimension Identifiers in Chart Filters

Details

Product Component

Metrics Catalog

More Detail

Our Metric Chart Filtering is a nifty feature enabling you to filter and split metrics by dimension. In v1 we displayed the dimensions exactly as they are shown in your database with an added dunder (__)separating the table name from the column name. For example, if you have a table called "users" with a column called "user_name" our UI would display "usersuser_name". This is an incredibly useful feature but according to our users, maybe isn't so nice to look at. We listened, so in v2 of Metric Chart Filtering we've updated the way we display dimensions as well as the way we let you select them. You will no longer see the hard to read "usersuser_name" but instead, get "Users > User Name" as well as a spiffy new dropdown to help you select.

Verification Steps

1. Visit any Metric Page and open up the Chart Filters.
2. Open up the Dimension Dropdown to select a dimension identifier (table in your database).
3. After selecting a dimension identifier you will be able to select a dimension type (row in the table in your database. Now you can select the dimension values (values the row in your database) that you would like to filter your chart by.

Query Logs

Details

Product Component

Metrics Catalog

More Detail

The MQL Query Logs allow you to look at the history of activity in the Transform UI to determine what queries were run, when they were run, the identifier of the query, the query execution time, and whether it was successful or failed. In addition, you can dig into the query execution details by looking at the server log and generated SQL from the request — all through the Transform interface. These logs collect information so you can troubleshoot requests and investigate activity on your interface. We realized that, while our customers are awesome, it was unreasonable to assume that they are omnipotent and that they can keep a mental model of all their queries, and so we added this log.

Verification Steps

1. Go to Settings and Select MQL Query Logs
2. View queries - you can search and filter by execution time, metrics, and statuses
3. Click on a query id to dig into logs, SQL, and results. You can share the query log with Transform in case you need the team's help to debug an issue.

As-Table command

Details

Product Component

Interfaces - MQL CLI

More Detail

To write a table in your data warehouse, previously you would use the materialize command. Now, you should use the mql query command with a new argument we added called as-table.

Verification Steps

New Command: mql query --metrics metric_name --dimensions dimension_name --as-table schema.table

Old Command: mql materialize --metrics metric_name --dimensions dimension_name --table schema.table

PS: Don't worry, we will be using the materialize command for an exciting upcoming new feature which you'll hear more about soon!

Clean Up Dimension Names

Details

Product Component

Metrics Catalog

More Detail

We really like underscores, but we know they can be hard to read. We now clean the dimension names in the Filter and Group By dropdown. For example, if the dimension name is "created_at", we will clean it up to display it as "Created At" in the chart interface.

If you would like to choose a different name than what we've inferred, you can add

display_name: <desired_display_name> to a given dimension in the YAML files.

Verification Steps

Navigate to the user interface for any metric and open up the display panel to confirm your dimension names have been cleaned of underscores.

Create Metric Directly from Measure

Details

Product Component

Metrics Framework

More Detail

You can now specify in your metrics.yaml whether you want to create a metric from a measure. By default, we don't create a metric from measures unless you specify create_metric = true.

Verification Steps

Example YAML snippet. Add create_metric: true to create a metric from your measure.

measures:    - name: new_stations      expr: "1"      agg: sum      create_metric: true

Run list-metrics in the CLI or visit the Transform UI and search the measure to confirm your metric is created.

mql list-metrics

🐛 Bug Fixes 🐛

Ratio and Expr Dimension Dropdown Issue

Details

Product Component

Metrics Catalog

More Detail

If you have a metric that's of the type ratio or expr, the dimensions dropdown under the chart to filter would not populate, and it would throw an error. We hope that you didn't think that it was because we didn't want you to filter dimensions on these metrics — it's just that we had a bug (which we fixed)! You can now see and filter the dimensions associated with these metric types.

Verification Steps

Navigate to a metric that's not a measure_proxy and open up the filter panel to confirm your dimensions are populated.

ClI Performance Improvements

Details

Product Component

Interfaces - MQL CLI

More Detail

We've made some performance improvements to our CLI so that commands return results faster. In our testing, we noticed a significant performance boost after releasing these changes.

Verification Steps

This speedup will affect any mql command.

mql identify