AdminAudit and usageUsage overview

Materializations usage dashboard

View as Markdown

The Materializations usage dashboard shows how your organization uses materialization, including data regarding which documents and elements are materialized, how often those materializations run, whether runs succeed, and how often queries actually use the materialized data.

Use this dashboard to find materializations that fail or run slowly, and to compare run cost against how often a materialization is used. For information about creating and scheduling materializations, see About materialization. To pause, resume, or review schedules, see Manage materializations.

This document explains how to access the Materializations usage dashboard and interpret the data, including utilization ratio.

Requirements

To access the Materializations usage dashboard, you must be assigned the Admin account type or a custom account type with the View usage dashboard permission enabled.

About the Materializations usage dashboard

The Materializations usage dashboard provides KPI charts, leaderboards, a document-level summary, run logs, and daily trends for materialization activity across your organization.

A key metric on this dashboard is utilization ratio. For each materialized element, Sigma tracks the number of queries that used the materialization and divides that by the number of materialization runs. The result is the average number of queries served per run.

A higher utilization ratio means more queries used the materialized data for each run. A lower ratio means the materialization runs more often than queries use it. See Interpret materialization usage data.

The dashboard includes the following tabs:

SectionDescription
OverviewProvides a run-level log of materialization jobs, including success, error messages, runtime, and row counts, as well as several KPI charts showing organization-level statistics, including rows materialized, total and average materialization time, and the failure rate.
LeaderboardCompare documents and materialized elements. Includes total and average materialization time, number of runs, storage, and a Utilization Ratio per Materialization bar chart.
DocumentsA document-level summary table, including Queries, Materializations, and Utilization Ratio.
TrendA combo chart showing the trend of materialization activity over time, including total materialization time, number of runs, and failures.
HeatmapA heatmap showing the distribution of materialization statistics by hour and day of week.

For custom views, filters, and exports that apply to all usage dashboards, see Usage overview.

Leaderboard tab

The Leaderboard section compares materializations so you can see which documents use the most runtime or storage, as well as which elements return the most queries per run.

ChartDescription
Total materialization minutesTotal materialization runtime, in minutes, by document.
Average materialization minutesAverage materialization runtime, in minutes, by document.
# MaterializationsNumber of materialization runs by document.
StorageData platform storage used by materialized data, in GB, by document.
Utilization Ratio per MaterializationUtilization ratio by materialized element.

Documents tab

The Documents table summarizes materialization activity at the document level. Use it to find documents with high failure rates, long runtimes, or low utilization.

Column nameDescriptionHow it’s calculated
Document nameThe name of the document that contains the materialization.If multiple documents have the same name, a number is appended based on when the document was created.
Document typeThe type of document, such as workbook or data model.No calculation
Document created byThe user who created the document.No calculation
Last materializedWhen the document last ran a materialization.Timestamp of the most recent materialization run.
# MatsNumber of materialization runs for the document in the selected period.Count of materialization runs.
# FailuresNumber of failed materialization runs.Count of failed runs.
Failure rateHow often materialization runs fail for the document.# Failures / # Mats.
Total mat. time (min)Combined runtime of materialization runs for the document.Sum of runtimes, in minutes.
% of totalShare of organization-wide materialization runtime.Document total runtime / organization total runtime.
Total mat. time (hours)Total runtime of materialization runs for the document, in hours.Sum of runtimes, in hours.
Max mat. time (min)Longest runtime of a materialization run for the document.Longest runtime of a run, in minutes.
Avg mat. time (min)Typical runtime of a materialization run for the document.Total runtime / # Mats.
Last mat. time (min)Runtime of the most recent materialization run for the document.Runtime of the most recent materialization run, in minutes.
Last vs avg (min)How the most recent run compares to the average runtime.Last run time − average run time, in minutes.
Time since last mat (mins)How long since the most recent materialization run.Time since last run, in minutes.
QueriesNumber of queries that used the materialization in the document.Count of queries served by the materialized data.
MaterializationsNumber of materialization runs used to calculate utilization.Count of materialization runs.
Utilization ratioAverage queries served per run.Queries served / # Materializations.
# RowsNumber of rows in the materialized data.No calculation
GBStorage used by the materialized data.Size of materialized data, in GB.
Last run successful?Whether the most recent materialization run succeeded.No calculation

Interpret materialization usage data

Use the following notes when you review utilization ratio and other materialization usage data.