Table: doppler_project - Query Doppler Projects using SQL

Doppler is a universal secrets management platform that helps developers to securely manage and quickly access secrets, such as database credentials, API keys, and tokens, in any environment. It allows users to centralize and manage secrets across all applications and services, ensuring secure access and handling. Doppler Projects are a key resource within Doppler, acting as a container for environments and their associated secrets.

Table Usage Guide

The doppler_project table provides insights into Projects within Doppler's secrets management platform. As a security engineer or developer, explore project-specific details through this table, including project ID, name, and associated environment variables. Utilize it to manage and monitor the security of secrets across different projects and environments.

Examples

Basic info

Explore the basic details of your projects, including their creation date and unique identifiers, to gain a better understanding of your project timeline and organization. This can be particularly useful for managing multiple projects and ensuring each one is progressing as expected.

select
  id,
  name,
  created_at,
  slug,
  description
from
  doppler_project;

select
  id,
  name,
  created_at,
  slug,
  description
from
  doppler_project;

List projects created between two specific dates

Discover the projects that were initiated within a certain time frame, specifically between two given dates. This is useful for assessing the volume and pace of project creation during a specific period.

select
  name,
  id,
  created_at
from
  doppler_project
where
  created_at between '2022-01-01' and '2022-12-31';

select
  name,
  id,
  created_at
from
  doppler_project
where
  created_at between '2022-01-01' and '2022-12-31';

Get particular project details

Explore particular project details to understand its creation time, description, and other key information. This is useful when you need a quick overview of a specific project without having to go through all the project data.

select
  id,
  name,
  created_at,
  description,
  slug
from
  doppler_project
where
  name = 'my_first_project';

select
  id,
  name,
  created_at,
  description,
  slug
from
  doppler_project
where
  name = 'my_first_project';

Schema for doppler_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time when the project was created.
description	text		The description of the project.
id	text		ID is the unique identifier for the object.
name	text		The name of the project.
slug	text		Slug is an abbreviated name for the project.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The name of the workplace.
workplace_id	text	=, !=, ~~, ~~, !~~, !~~	The ID of the workplace.
workplace_name	text		Title of the resource.

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)" -- doppler

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

steampipe_export_doppler --config '<your_config>' doppler_project