Table: sentry_project - Query Sentry Projects using SQL

Sentry is an open-source error tracking tool that helps developers monitor and fix crashes in real time. It provides complete visibility into your stack, enabling you to detect and fix issues as soon as they occur. Sentry supports all major languages and frameworks, and integrates with your existing workflow to identify, respond to, and resolve production software issues.

Table Usage Guide

The sentry_project table provides insights into projects within Sentry. As a developer or DevOps engineer, explore project-specific details through this table, including project id, name, platform, slug, and other related information. Utilize it to manage and monitor your projects, understand their configuration, and quickly identify and resolve issues.

Examples

Basic info

Discover the segments that have access and are public within a certain platform. This is useful in assessing the status and understanding the accessibility of projects within a given platform.

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project;

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project;

List public projects

Explore which projects are publicly accessible, enabling you to identify potential security risks or areas for collaboration.

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  is_public;

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  is_public = 1;

List go based projects

Explore which projects are based on the 'Go' programming language. This is useful to identify and manage projects that are using this specific platform.

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  platform = 'go';

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  platform = 'go';

List projects of a particular organization

Determine the areas in which a specific organization has projects. This can be useful to gain insights into the project status, access details, and platform usage within the organization.

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  organization_slug = 'myorg';

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  organization_slug = 'myorg';

List internal projects

Discover the segments that are classified as internal projects within your organizational structure. This allows you to assess the elements within your organization that are not public-facing, aiding in strategic planning and resource allocation.

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  is_internal;

select
  id,
  name,
  status,
  slug,
  has_access,
  is_public,
  platform
from
  sentry_project
where
  is_internal = 1;

List teams of a particular project

Determine the teams associated with a specific project to understand their roles and contributions. This is useful for project management and resource allocation.

select
  id,
  name,
  t ->> 'id' as team_id,
  t ->> 'name' as team_name,
  t ->> 'slug' as team_slug
from
  sentry_project,
  jsonb_array_elements(teams) as t
where
  slug = 'myproj';

select
  id,
  name,
  json_extract(t.value, '$.id') as team_id,
  json_extract(t.value, '$.name') as team_name,
  json_extract(t.value, '$.slug') as team_slug
from
  sentry_project,
  json_each(teams) as t
where
  slug = 'myproj';

Schema for sentry_project

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
allowed_domains	jsonb		The allowed domains of the project.
avatar	jsonb		Represents an avatar.
color	text		The project color.
data_scrubber	text		The project data scrubber.
data_scrubber_defaults	text		The project default data scrubber.
date_created	timestamp with time zone		The creation timestamp of the project.
digest_max_delay	bigint		The maximum amount of time (in seconds) to wait between scheduling digests for delivery.
digest_min_delay	bigint		The minimum amount of time (in seconds) to wait between scheduling digests for delivery after the initial scheduling.
features	jsonb		The features of the project.
filters	jsonb		The project filters.
fingerprinting_rules	text		The fingerprinting rules of the project.
first_event	timestamp with time zone		The first event timestamp.
grouping_enhancements	text		The grouping enhancements of the project.
has_access	boolean		Check if the project has access.
id	text		The ID of the project.
is_bookmarked	boolean		Check if the project is bookmarked.
is_internal	boolean		Check if the project is internal.
is_member	boolean		Check if the project is member.
is_public	boolean		Check if the project is public.
name	text		The name of the project.
options	jsonb		The project options.
organization	jsonb		The organization to which the project belongs to.
organization_slug	text	=	The slug of the organization the project belongs to.
platform	text		The optional platform for this project.
processing_issues	bigint		The number of processing issues of the project.
resolve_age	bigint		Hours in which an issue is automatically resolve if not seen after this amount of time.
safe_fields	jsonb		The project safe fields.
scrape_java_script	boolean		Check if the project has scrape java script enabled.
scrub_ip_addresses	boolean		Check if the project has scrub IP addresses enabled.
security_token	text		The security token of the project.
security_token_header	text		The security token header of the project.
sensitive_fields	jsonb		The project sensitive fields.
slug	text	=	The slug of the project.
status	text		The status of the project.
subject_prefix	text		The subject prefix of the project.
subject_template	text		The subject template of the project.
teams	jsonb		The project teams.
title	text		Title of the resource.
verify_ssl	boolean		Check if the project is verified with SSL.

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

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

steampipe_export_sentry --config '<your_config>' sentry_project