Where can I quickly test custom metric queries?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2024 02:48 PM
I'm working on adapting some custom metrics to add to the tables' dashboard. Right now when I throw in a test query, I need to refresh metrics and it takes 5-10 minutes to let me know I've probably forgotten a parenthesis somewhere.
Where can I test the python style of metric generation more quickly?
As an example from the documentation, is there a query editor I can use to make changes to this:
from databricks.sdk.service.catalog import MonitorMetric, MonitorMetricType from pyspark.sql import types as T MonitorMetric( type=MonitorMetricType.CUSTOM_METRIC_TYPE_AGGREGATE, name="squared_avg", input_columns=["f1", "f2"], definition="avg(`{{input_column}}`*`{{input_column}}`)", output_data_type=T.StructField("output", T.DoubleType()).json(), )