Table: datadog_user - Query Datadog Users using SQL

Datadog is a monitoring and analytics tool that helps companies gain visibility into application performance, infrastructure, and logs. The user resource in Datadog represents a user in the Datadog organization. It contains information about the user's details, including their name, email, status, and role.

Table Usage Guide

The datadog_user table provides insights into user details within Datadog. As a system administrator, explore user-specific details through this table, including their name, email, status, and role. Utilize it to uncover information about users, such as their status and role within the organization, and to verify the email addresses associated with each user.

Examples

Basic info

Explore the user details in your Datadog account by identifying their email, name and associated roles. This can be useful for auditing user access and understanding the distribution of roles within your team.

select
  email,
  name,
  role_ids
from
  datadog_user;

select
  email,
  name,
  role_ids
from
  datadog_user;

List active users

Explore which users are currently active in your Datadog account. This can aid in understanding user engagement and activity levels within your system.

select
  email,
  id,
  disabled
from
  datadog_user
where
  status = 'Active'

select
  email,
  id,
  disabled
from
  datadog_user
where
  status = 'Active'

List service accounts

Explore which Datadog user accounts are service accounts to manage access controls and user privileges effectively. This is useful to ensure security and compliance by identifying potentially unauthorized or redundant service accounts.

select
  email,
  id,
  created_at,
  disabled,
  status
from
  datadog_user
where
  service_account;

select
  email,
  id,
  created_at,
  disabled,
  status
from
  datadog_user
where
  service_account = 1;

List users created in the last 7 days

Discover the details of recently added users within the past week. This can be useful for monitoring account creation trends or identifying potential security concerns.

select
  handle,
  id,
  status,
  created_at
from
  datadog_user
where
  created_at > current_timestamp - interval '7 days';

select
  handle,
  id,
  status,
  created_at
from
  datadog_user
where
  created_at > datetime('now', '-7 days');

Schema for datadog_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		Creation time of the user.
disabled	boolean		Indicates if the user is disabled.
email	text		Email of the user.
handle	text		Handle of the user.
icon	text		URL of the user's icon.
id	text	=	Id of the user.
modified_at	timestamp with time zone		Time that the user was last modified.
name	text		Name of the user.
relationships	jsonb		Relationships of the user object returned by the API.
role_ids	jsonb		A list of role IDs attached to user.
service_account	boolean		Indicates if the user is a service account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text	=	Status of the user.
title	text		Title of the user.
verified	boolean		Indicates the verification status of the user.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- datadog

You can pass the configuration to the command with the --config argument:

steampipe_export_datadog --config '<your_config>' datadog_user