steampipe plugin install linear

Table: linear_project - Query Linear Projects using SQL

Linear Project is a resource in Linear, a software development management tool. It allows users to organize tasks, issues, and objectives into specific projects. Each project in Linear has a unique identifier, name, and status, and may contain additional details such as description, label, and team information.

Table Usage Guide

The linear_project table provides insights into projects within Linear. As a project manager or a software development team member, you can explore project-specific details through this table, including their status, description, and associated team information. Utilize it to manage and monitor the progress of different projects, understand their scope, and ensure timely completion of tasks and objectives.

Examples

Basic info

Discover the segments that are currently in progress within your projects and assess their status and timeline. This can help you understand the overall progress and manage your projects more efficiently.

select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project;
select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project;

List planned projects

Explore which projects are in the planning stage to effectively manage resources and prioritize tasks. This aids in strategic decision-making by providing insights into upcoming projects.

select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
state = 'planned';
select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
state = 'planned';

List projects which are incomplete

Explore which projects are still ongoing. This is useful for tracking progress and identifying tasks that may need additional resources or attention.

select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
completed_at is null;
select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
completed_at is null;

List projects created by admin

Discover the projects that were established by administrative users. This can be particularly useful for auditing or understanding the distribution of project creation responsibilities within your team.

select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
creator ->> 'admin' = 'true';
select
id,
title,
created_at,
color,
progress,
scope,
state,
updated_at
from
linear_project
where
json_extract(creator, '$.admin') = 'true';

Show lead details of each project

Explore the leadership details of each project to gain insights into their activity status and roles. This can help in assessing the active involvement and administrative roles of the leads in different projects.

select
lead ->> 'id' as lead_id,
lead ->> 'name' as name,
lead ->> 'email' as email,
lead ->> 'active' as active,
lead ->> 'admin' as admin,
lead ->> 'statusLabel' as status_label
from
linear_project;
select
json_extract(lead, '$.id') as lead_id,
json_extract(lead, '$.name') as name,
json_extract(lead, '$.email') as email,
json_extract(lead, '$.active') as active,
json_extract(lead, '$.admin') as admin,
json_extract(lead, '$.statusLabel') as status_label
from
linear_project;

Schema for linear_project

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.
auto_archived_attimestamp with time zoneThe time at which the project was automatically archived by the auto pruning process.
canceled_attimestamp with time zoneThe time at which the project was moved into canceled state.
colortextThe project's color.
completed_attimestamp with time zoneThe time at which the project was moved into completed state.
completed_issue_count_historyjsonbThe number of completed issues in the project after each week.
completed_scope_historyjsonbThe number of completed estimation points after each week.
converted_from_issuejsonbThe project was created based on this issue.
created_attimestamp with time zone=, >, >=, <=, <The time at which the entity was created.
creatorjsonbThe user who created the project.
descriptiontextThe project's description.
icontextThe icon of the project.
idtext=The unique identifier of the entity.
in_progress_scope_historyjsonbThe number of in progress estimation points after each week.
integrations_settingsjsonbSettings for all integrations associated with that project.
issue_count_historyjsonbThe total number of issues in the project after each week.
leadjsonbThe project lead.
nametext=The project's name.
progressdouble precisionThe overall progress of the project. This is the (completed estimate points + 0.25 * in progress estimate points) / total estimate points.
project_update_reminders_paused_until_attimestamp with time zoneThe time until which project update reminders are paused.
scopedouble precisionThe overall scope (total estimate points) of the project.
scope_historyjsonbThe total number of estimation points after each week.
slack_issue_commentsbooleanWhether to send new issue comment notifications to Slack.
slack_issue_statusesbooleanWhether to send new issue status updates to Slack.
slack_new_issuebooleanWhether to send new issue notifications to Slack.
slug_idtext=The project's unique URL slug.
sort_orderdouble precisionThe sort order for the project within the organization.
start_datetimestamp with time zone=, >, >=, <=, <The estimated start date of the project.
started_attimestamp with time zoneThe time at which the project was moved into started state.
statetext=The type of the state.
target_datetimestamp with time zone=, >, >=, <=, <The estimated completion date of the project.
titletextThe project's title.
updated_attimestamp 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.
urltextProject URL.

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_project