Table: sentry_organization_integration - Query Sentry Organization Integrations using SQL

Sentry Organization Integration is a feature within Sentry that allows organizations to integrate their Sentry projects with third-party services. It provides a unified way to manage and use integrations for various purposes, including issue tracking, alerting, data forwarding, and more. Sentry Organization Integration helps in enhancing the functionality of Sentry projects by leveraging the capabilities of other services.

Table Usage Guide

The sentry_organization_integration table provides insights into the integrations enabled for a Sentry organization. As an engineer or administrator, explore integration-specific details through this table, including provider information, integration configuration, and associated metadata. Utilize it to uncover information about integrations, such as their status, the services they connect with, and the configuration settings applied.

Examples

Basic info

Explore which organizations have integrated with Sentry by checking their status and account type. This can help you understand the scope of Sentry's integration within your organization.

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration;

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration;

List integrations which are not active

Discover the segments that include inactive integrations within organizations to assess the areas requiring attention or potential updates. This can be beneficial in enhancing system efficiency and security by identifying and addressing inactive components.

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration
where
  status <> 'active';

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration
where
  status != 'active';

List github integrations

Explore which GitHub integrations are active within your organization by assessing their status, account types, and associated domain names. This can help identify any potential issues or areas for improvement in your organization's use of GitHub.

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration
where
  provider_key = 'github';

select
  id,
  name,
  status,
  organization_slug,
  account_type,
  domain_name
from
  sentry_organization_integration
where
  provider_key = 'github';

Schema for sentry_organization_integration

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_type	text		The account type of the integration.
domain_name	text		The domain name of the integration.
external_id	text		The external id of the integration.
grace_period_end	timestamp with time zone		The grace period end timestamp.
icon	text		The icon of the integration.
id	text		The ID of the integration.
name	text		The name of the integration.
organization_id	text		The organization ID.
organization_integration_status	text		The organization integration status.
organization_slug	text	=	The slug of the organization the integration belongs to.
provider	jsonb		The integration provider.
provider_key	text	=	The integration provider key.
scopes	jsonb		The integration scopes.
status	text		The status of the integration.
title	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)" -- sentry

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

steampipe_export_sentry --config '<your_config>' sentry_organization_integration