Comment on page

Datadog

To export monitoring data from your Upsolver account, you must first create a connection that provides the appropriate credentials to access your Datadog account.
Syntax
CREATE DATADOG CONNECTION <connection_identifier>
    API_KEY = '<api_key>'
    [ API_HOSTNAME = '<api_hostname>' ]
    [ COMMENT = '<comment>' ];
Jump to
​API_KEY​
​API_HOSTNAME​
​COMMENT​
Connection Options
API_KEY
Type: text
The API key for your Datadog account.
API_HOSTNAME
Type: text
The API hostname for your Datadog account.
COMMENT — editable
Type: text
(Optional) A description or comment regarding this connection.
Examples
Create a connection
The following example creates a new connection named my_datadog_connection that will be used to send monitoring information to Datadog.
CREATE DATADOG CONNECTION my_datadog_connection
    API_KEY = 'my_api_key'
    API_HOSTNAME = 'app.datadoghq.eu'
    COMMENT = 'Datadog connection for Upsolver metrics';
Like any other connection you create in Upsolver, the connection is persistent, so you need only create this once. 
Create a job
The following script creates a job named send_monitoring_data_to_datadog that sends cluster metrics to the Datadog account my_datadog_connection created in the above example:
CREATE JOB send_monitoring_data_to_datadog
    START_FROM = NOW
AS INSERT INTO my_datadog_connection
    MAP_COLUMNS_BY_NAME
       SELECT utilization_percent AS utilization_percent,
              tasks_in_queue AS tasks_in_queue,
              memory_load_percent AS memory_load_percent,
              cluster_id AS tags.cluster_id,
              cluster_name AS tags.cluster_name,
              RUN_START_TIME() AS time
       FROM system.monitoring.clusters;
The job includes the cluster_id and cluster_name as tags, which is helpful if you have multiple clusters in your organization. 

Amazon CloudWatch

Errors

Last modified 1mo ago

Datadog

Syntax

Jump to

Connection Options

`API_KEY`

`API_HOSTNAME`

`COMMENT` — editable

Examples

Create a connection

Create a job