Official

Premium

Datadog

The CloudQuery Datadog plugin extracts your Datadog information and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v5.7.1

Type

Source

Platforms

Date Published

October 3, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

Overview Configuration

Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync datadog.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

Datadog Source Plugin

The CloudQuery Datadog plugin extracts your Datadog information and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Authentication #

CloudQuery requires only DD_CLIENT_API_KEY and DD_CLIENT_APP_KEY. Follow this guide for how to create an API key and app key for CloudQuery.

CloudQuery requires only read permissions (we will never make any changes to your Datadog account), so, following the principle of the least privilege, it's recommended to grant it read-only permissions.

Query Examples #

Find all not verified users #

SELECT 
    "attributes" ->> 'name' AS username
FROM
    datadog_users
WHERE
    ("attributes" ->> 'verified')::boolean is distinct FROM TRUE

Configuration #

CloudQuery Datadog Source Plugin Configuration Reference

Example #

This example connects a single Datadog account to a Postgres destination. The (top level) source spec section is described in the Source Spec Reference.

kind: source
spec:
  # Source spec section
  name: "datadog"
  path: "cloudquery/datadog"
  registry: "cloudquery"
  version: "v5.7.1"
  tables: ["*"]
  destinations: ["postgresql"]

  spec:
    # required
    accounts:
      - # required
        name: example_account
        # required
        api_key: ${DATADOG_EXAMPLE_ACCOUNT_API_KEY}
        # required
        app_key: ${DATADOG_EXAMPLE_ACCOUNT_APP_KEY}
    # Optional parameters
    # site: datadoghq.eu

Datadog Spec #

This is the (nested) spec used by the Datadog source plugin.

accounts ([]account, required)
Specify which accounts to sync data from.
site (string, optional, default: "")
The Datadog site to connect to. This is usually one of datadoghq.com or datadoghq.eu - see site documentation for more information.
concurrency (int, optional, default: 10000)
A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.

account #

This is used to specify one or more accounts to extract information from. Note that it should be an array of objects, each with the following fields:

name (string, required)
Account name.
api_key (string, required if not using access_token)
Datadog API key.
app_key (string, required if not using access_token)
Datadog App key.
access_token (string)
A valid OAuth access token to use, instead of api_key and app_key.