metrics-sql-api.md

title	sidebar_label	sidebar_position
Metrics SQL API	Metrics SQL API	50

Metrics SQL API allows you to query data from your predefined metrics view using Metrics SQL dialect.

Example:

type: api
metrics_sql: SELECT dimension, measure FROM my_metrics

where my_metrics is your metrics view name, measure is a metrics that you have defined in the metrics view and dimension is a dimension defined in the metrics view.

Read more the dialect here: Metrics SQL.

Templating

It supports templating the same way as SQL API Templating.