Table: linear_integration - Query Linear Integrations using SQL

Linear Integration is a feature within Linear that enables the connection and interaction of third-party tools with the Linear workspace. It facilitates the seamless integration of various tools, enhancing productivity and collaboration among team members. Linear Integration is instrumental in streamlining workflows and tasks, making project management more efficient.

Table Usage Guide

The linear_integration table provides insights into the integrated third-party tools in the Linear workspace. As a project manager or a team lead, you can explore detailed information about these integrations through this table, including their types, configurations, and associated metadata. Utilize it to manage and optimize the use of integrated tools, thereby improving team collaboration and project efficiency.

Examples

Basic info

Explore the creation and modification timelines of various services. This query is useful in tracking the lifecycle of each service, aiding in maintenance and management tasks.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration;

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration;

List integration which are not associated with any team

Explore which integrations are not linked to any team, to understand potential areas of resource allocation or reorganization. This can help streamline your workflow and ensure all integrations are being utilized effectively.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  team is null;

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  team is null;

Show github integrations

This query is designed to identify all integrations with GitHub in Linear. This can be useful for tracking and managing these integrations, ensuring they're up to date and functioning properly.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  service = 'github';

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  service = 'github';

Show archived integrations

Discover the segments that have archived integrations, providing a historical view of your service integrations. This can be useful for auditing purposes or for understanding changes in your integration landscape over time.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  archived_at is not null;

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  archived_at is not null;

List integrations created by admin

Identify integrations that have been created by an admin. This can be useful for auditing purposes, helping to ensure there are no unauthorized integrations in your system.

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  creator ->> 'admin' = 'true';

select
  id,
  created_at,
  service,
  updated_at
from
  linear_integration
where
  json_extract(creator, '$.admin') = 'true';

Schema for linear_integration

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
archived_at	timestamp with time zone		The time at which the entity was archived. Null if the entity has not been archived.
created_at	timestamp with time zone		The time at which the entity was created.
creator	jsonb		The user that added the integration.
id	text	=	The unique identifier of the entity.
organization	jsonb		The organization that the integration is associated with.
organization_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the organization.
service	text		The integration's type.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team	jsonb		The team that the integration is associated with.
title	text		The integration's title.
updated_at	timestamp with time zone		The last time at which the entity was meaningfully updated, i.e., for all changes of syncable properties except those for which updates should not produce an update to updatedAt (see skipUpdatedAtKeys). This is the same as the creation time if the entity hasn't been updated after creation.

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

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

steampipe_export_linear --config '<your_config>' linear_integration