CREATE METRICS INTEGRATION
metrics_integration_name
WITH (metrics_integration_parameter = value [, ... ]);
Description
Metrics integrations make it possible for organizations to configure an integration that enables scraping of query metrics. You can use tokens with the specified access.region that are valid for 90 days.
Arguments
metrics_integration_name
Specifies the name of the new metrics integration. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.
WITH (metrics_integration_parameter = value [, … ])
This clause specifies metrics integration parameters; see below for more information.
Metrics Integration Parameters
Parameter Name
Description
access_region
Region for which the metrics integration is valid.
Required: Yes
Examples
Create a metrics integration
The following creates a new metrics integration with name my-integration and is valid for AWS us-east-1:
demodb.public/demostore# CREATE METRICS INTEGRATION "my-integration" WITH ('access_region' = "AWS us-east-1");
+---------------------+----------------+----------+------------------------------------------+-------------------+------------------------+
| Type | Name | Command | Summary | Token | Uri |
+=====================+================+==========+==========================================+===================+========================+
| metrics integration | my-integration | CREATE | metrics integration my-integration was | <my access token> | https://uri/to/metrics |
| | | | successfully created | | |
+---------------------+----------------+----------+------------------------------------------+-------------------+------------------------+
The command will output a URI and token you can add as a metric endpoint in Prometheus in Grafana. See Guide to Add Metrics Integration to Prometheus for more information.
If you have an active query you can test the URI and token with the following curl command. Use the URI from CREATE METRICS INTEGRATION output:
