Table: linear_team_membership - Query Linear Team Memberships using SQL

Linear Team Memberships are a critical part of the Linear service, defining the relationship between teams and their members. They provide a mechanism for grouping members into teams for better organization and management. Team Memberships in Linear are essential for managing workload distribution, task assignment, and overall project management within the service.

Table Usage Guide

The linear_team_membership table provides insights into the team memberships within Linear. As a project manager or team leader, you can explore specific details about the relationship between teams and members through this table. Use it to understand team composition, member roles, and to manage workload distribution and task assignments more effectively.

Examples

Basic info

Explore the creation and modification details of team memberships in Linear. This information can help to understand team dynamics and track changes over time.

select
  id,
  created_at,
  owner,
  sort_order,
  updated_at
from
  linear_team_membership;

select
  id,
  created_at,
  owner,
  sort_order,
  updated_at
from
  linear_team_membership;

List teams with owner details

Discover the segments that include team ownership details, allowing you to understand who holds control over different teams and when the last updates were made. This can be particularly useful in larger organizations where team ownership may shift frequently.

select
  id,
  jsonb_pretty(team) as team,
  jsonb_pretty(membership_user) as user,
  updated_at
from
  linear_team_membership
where
  owner;

select
  id,
  team,
  membership_user as user,
  updated_at
from
  linear_team_membership
where
  owner;

List members of a particular team

Explore which members belong to a specific team, gaining insights into their user ID, name, admin status, email, and activity status. This is particularly useful for managing team dynamics and understanding the roles of different team members.

select
  membership_user ->> 'id' as user_id,
  membership_user ->> 'name' as name,
  membership_user ->> 'admin' as admin,
  membership_user ->> 'email' as email,
  membership_user ->> 'active' as active
from
  linear_team_membership
where
  team ->> 'name' = 'linear_team';

select
  json_extract(membership_user, '$.id') as user_id,
  json_extract(membership_user, '$.name') as name,
  json_extract(membership_user, '$.admin') as admin,
  json_extract(membership_user, '$.email') as email,
  json_extract(membership_user, '$.active') as active
from
  linear_team_membership
where
  json_extract(team, '$.name') = 'linear_team';

List archived membership

Explore which team memberships in Linear have been archived to manage team structure and access effectively. This could be useful in maintaining the organization's data hygiene and understanding team dynamics over time.

select
  id,
  created_at,
  owner,
  sort_order,
  updated_at
from
  linear_team_membership
where
  archived_at is not null;

select
  id,
  created_at,
  owner,
  sort_order,
  updated_at
from
  linear_team_membership
where
  archived_at is not null;

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_team_membership