Warehouse native metrics

This topic explains how to configure a warehouse native metric for use in an experiment. Warehouse native metrics are metrics that measure events stored in an external warehouse, such as Snowflake.

Prerequisites

Before you can create a warehouse native metric, you must configure a warehouse native Experimentation integration and create at least one metric data source for the integration. To learn more, read Metric data sources. You can optionally create a new data source when you create a new metric.

Warehouse native metric requirements

Warehouse native metrics must be custom metrics or ratio metric.

Experiments that use warehouse native metrics cannot use:

Create a warehouse native metric

To create a warehouse native metric:

  1. Open the Data section and navigate to the Metrics list.
  2. Click Create metric. The “Create metric” dialog appears.
  3. Select either Simple or Ratio as the metric structure.
  4. Select a configured warehouse integration from the Define metric using menu.
  5. Select an existing data source from Metric data source, or click Create metric data source to create a new one.

Selecting a data source for a warehouse native metric.

Selecting a data source for a warehouse native metric.
  1. Enter a new or existing event key to use for creating the metric.
  2. (Optional) Use the Filter by event properties field to create a filter query to choose the specific events you want to select for this metric. This field is available only for metrics created from Snowflake data sources. To learn more, read Filtering custom metric events.
  3. Finish creating the metric by continuing the procedure as described in custom conversion binary, custom conversion count, custom numeric, or ratio metric.

You can now create an experiment by selecting this metric.