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, platformfrom sentry_project;
select id, name, status, slug, has_access, is_public, platformfrom 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, platformfrom sentry_projectwhere is_public;
select id, name, status, slug, has_access, is_public, platformfrom sentry_projectwhere 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, platformfrom sentry_projectwhere platform = 'go';
select id, name, status, slug, has_access, is_public, platformfrom sentry_projectwhere 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, platformfrom sentry_projectwhere organization_slug = 'myorg';
select id, name, status, slug, has_access, is_public, platformfrom sentry_projectwhere 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, platformfrom sentry_projectwhere is_internal;
select id, name, status, slug, has_access, is_public, platformfrom sentry_projectwhere 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_slugfrom sentry_project, jsonb_array_elements(teams) as twhere 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_slugfrom sentry_project, json_each(teams) as twhere 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