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.