steampipe plugin install linear

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
archived_attimestamp with time zoneThe time at which the entity was archived. Null if the entity has not been archived.
created_attimestamp with time zoneThe time at which the entity was created.
creatorjsonbThe user that added the integration.
idtext=The unique identifier of the entity.
organizationjsonbThe organization that the integration is associated with.
servicetextThe integration's type.
teamjsonbThe team that the integration is associated with.
titletextThe integration's title.
updated_attimestamp with time zoneThe 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