steampipe plugin install linear

Table: linear_attachment - Query Linear Attachments using SQL

Linear is a streamlined software designed to manage software projects, where Attachments serve as a crucial resource. Attachments in Linear refer to any files or resources attached to issues within the project management tool. This includes a variety of file types, such as images, documents, or any other file that provides additional context or information about an issue.

Table Usage Guide

The linear_attachment table provides insights into attachment details within Linear's issue management system. As a project manager or software developer, explore attachment-specific details through this table, including file types, associated issues, and original upload dates. Utilize it to uncover information about issue-related resources, such as the types of files most commonly attached to issues, the issues with the most attachments, and the chronology of attachment uploads.

Examples

Basic info

This query allows you to gain insights into the basic information of attachments in a Linear project. It's useful when you need to quickly assess details like titles, subtitles, source types, creation and update dates, and URLs, which can help in managing and organizing project resources.

select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment;
select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment;

List attachments where source type is unknown

Identify instances where attachments have an unknown source type. This can be useful in assessing potential data integrity issues or tracking unclassified data within your system.

select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
source_type = 'unknown';
select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
source_type = 'unknown';

List archived attachments

Discover the segments that contain archived attachments to understand their relevance and the time when they were last updated. This is useful in managing storage and ensuring efficient data use.

select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
archived_at is not null;
select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
archived_at is not null;

List attachments where source information is unavailable

Discover the attachments that lack source information, enabling you to identify and rectify gaps in your data. This is particularly useful in maintaining data integrity and ensuring comprehensive record-keeping.

select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
source is null;
select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
source is null;

List attachments created by admin

Explore which attachments have been created by an admin to gain insights into the source and timing of these documents. This can be useful for auditing purposes or to understand administrative contribution to content.

select
id,
title,
source_type,
created_at,
creator
from
linear_attachment
where
creator ->> 'admin' = 'true';
select
id,
title,
source_type,
created_at,
creator
from
linear_attachment
where
json_extract(creator, '$.admin') = 'true';

List attachments for a particular issue

Explore which attachments are linked to a specific issue. This is useful for quickly accessing all relevant files and data associated with a particular problem or topic.

select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
issue ->> 'title' = 'attachment check';
select
id,
title,
subtitle,
source_type,
created_at,
updated_at,
url
from
linear_attachment
where
json_extract(issue, '$.title') = 'attachment check';

Schema for linear_attachment

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 zone=, >, >=, <=, <The time at which the entity was created.
creatorjsonbThe creator of the attachment.
group_by_sourcebooleanIndicates if attachments for the same source application should be grouped in the Linear UI.
idtext=The unique identifier of the entity.
issuejsonbThe issue this attachment belongs to.
metadatajsonbCustom metadata related to the attachment.
sourcejsonbInformation about the source which created the attachment.
source_typetext=An accessor helper to source.type, defines the source type of the attachment.
subtitletext=Content for the subtitle line in the Linear attachment widget.
titletext=The attachment'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.
urltext=Location of the attachment which is also used as an identifier.

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_attachment