MetricCalculation

Represents the calculation of a metric for a specific time window.

metricCalculationSpec

object

required

The metric to calculate.

Show child attributes

startTime

object

required

Start time of the calculation in terms of exposure.

scheduleIteration

object

required

The iteration of the schedule that this calculation belongs to.

times

object

required

Info about the start / end timestamps used for the calculation

Show child attributes

createTime

object

required

Time when the metric calculation was first created.

updateTime

object

required

Time when the metric calculation was last updated.

creator

string

required

Reference to the identity that created this metric calculation.

updater

string

required

Reference to the identity that last updated this metric calculation.

name

string

Unique identifier of the metric calculation. For example: metricCalculations/0smva5nxuhv4yts6paxt

endTime

object

End time of the calculation in terms of facts. Must be set if exposure_end_time is not set, if exposure_end_time is set, this field will be set to the inferred fact end time.

state

enum<string>

Current state of the calculation.

Available options:

STATE_UNSPECIFIED,

STATE_FAILED,

STATE_RUNNING,

STATE_COMPLETED,

STATE_CANCELLED

metricResults

object

Holds the results of the metric calculate when completed.

Show child attributes

schedule

string

Resource reference to the schedule if the calculation originated from a schedule.

sqlJob

string

Resource name of the corresponding job that performs the calculation.

supersededBy

string

Set if the metric calculation has been replaced by a newer calculation, occurs for example when parameters of the metric changes.

sql

string

The warehouse-specific query that is used to perform the calculation.

superseeds

string

Set if this metric calculation replaced an older metric calculation.

retriggered

boolean

Determines whether this calculation overlaps with a retriggered range

outdatedSourceDataInfo

object

If the underlying tables changed for the queried values since running the calculation, this contains information about what changed and where.

Show child attributes

error

string

Descriptive error if the calculation failed.

labels

object[]

Custom labels for this metric calculation.

Show child attributes

owner

string

The owner of the resource. If not set will default to the creator.

⌘I

{
  "metricCalculationSpec": {
    "metric": "<string>",
    "exposureTable": "<string>",
    "splitDimensions": [
      {
        "column": "<string>",
        "factTable": "<string>",
        "dimensionTable": "<string>",
        "exposureTable": "<string>"
      }
    ],
    "measurementTable": "<string>",
    "exposureGroups": [
      "<string>"
    ]
  },
  "startTime": {},
  "scheduleIteration": {},
  "times": {
    "exposureStartTime": {},
    "exposureEndTime": {},
    "factStartTime": {},
    "factEndTime": {}
  },
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "endTime": {},
  "metricResults": {
    "metricBucketStats": [
      {
        "summaryStats": {
          "averageSummaryStats": {
            "sum": 123,
            "sumOfSquares": 123,
            "count": 123,
            "countMissing": 123,
            "countMissingRows": 123,
            "mean": 123,
            "variance": 123,
            "varianceReductionStats": {
              "count": 123,
              "countMissing": 123,
              "countMissingRows": 123,
              "sum": 123,
              "postSum": 123,
              "postCount": 123,
              "sumOfSquares": 123,
              "sumOfProducts": 123,
              "mean": 123,
              "variance": 123,
              "covariance": 123
            }
          },
          "ratioSummaryStats": {
            "numeratorSum": 123,
            "numeratorSumOfSquares": 123,
            "denominatorSum": 123,
            "denominatorSumOfSquares": 123,
            "sumOfProducts": 123,
            "count": 123,
            "countMissing": 123,
            "countMissingRows": 123,
            "numeratorMean": 123,
            "numeratorVariance": 123,
            "denominatorMean": 123,
            "denominatorVariance": 123,
            "numeratorDenominatorCovariance": 123,
            "varianceReductionStats": {
              "count": 123,
              "countMissing": 123,
              "countMissingRows": 123,
              "numeratorSum": 123,
              "postNumeratorSum": 123,
              "numeratorSumOfSquares": 123,
              "denominatorSum": 123,
              "postDenominatorSum": 123,
              "denominatorSumOfSquares": 123,
              "sumOfProducts": 123,
              "numeratorNumeratorSumOfProducts": 123,
              "numeratorDenominatorSumOfProducts": 123,
              "denominatorNumeratorSumOfProducts": 123,
              "denominatorDenominatorSumOfProducts": 123,
              "numeratorMean": 123,
              "numeratorVariance": 123,
              "denominatorMean": 123,
              "denominatorVariance": 123,
              "numeratorDenominatorCovariance": 123,
              "preNumeratorPostNumeratorCovariance": 123,
              "preNumeratorPostDenominatorCovariance": 123,
              "preDenominatorPostNumeratorCovariance": 123,
              "preDenominatorPostDenominatorCovariance": 123
            }
          }
        },
        "variant": "<string>",
        "dimensions": [
          {
            "dimension": "<string>",
            "value": "<string>"
          }
        ]
      }
    ]
  },
  "schedule": "<string>",
  "sqlJob": "<string>",
  "supersededBy": "<string>",
  "sql": "<string>",
  "superseeds": "<string>",
  "retriggered": true,
  "error": "<string>",
  "labels": [
    {}
  ],
  "owner": "<string>"
}

Get Started

Feature Flags

Metrics

Stats

Experiments

Surfaces

IAM

Connectors