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. Tokens 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.
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";
+---------------------+----------------+----------+------------------------------------------+-------------------+------------------------+
| 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:
