Back to source list
Official
Premium
Datadog
The CloudQuery Datadog plugin extracts your Datadog information and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.8.1
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Set up process #
brew install cloudquery/tap/cloudquery
1. Download CLI and login
2. Create source and destination configs
Plugin configurationOverview #
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.8.1"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/datadog_source
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 ofdatadoghq.com
ordatadoghq.eu
- see site documentation for more information.concurrency
(integer
, optional, default:10000
)A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.scheduler
(string
, optional, default:dfs
)The scheduler to use when determining the priority of resources to sync. Supported values aredfs
(depth-first search),round-robin
,shuffle
andshuffle-queue
.For more information about this, see performance tuning.
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 usingaccess_token
)Datadog API key.app_key
(string
, required if not usingaccess_token
)Datadog App key.access_token
(string
)A valid OAuth access token to use, instead ofapi_key
andapp_key
.