This plugin is in preview.
The Linear Cloud source plugin for CloudQuery extracts configuration from the Linear REST API and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v1.0.0
Type
Source
Platforms
Date Published
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
api_key field, or use an environment variable:spec:
api_key: "${LINEAR_API_KEY}"
kind: source
spec:
name: "linear"
path: "cloudquery/linear"
registry: "cloudquery"
version: "v1.0.0"
destinations: ["postgresql"]
# Linear specific configuration
spec:
api_key: "${LINEAR_API_KEY}"
api_key (string) (required)concurrency (integer) (optional, default: 100)select identifier, title, priority_label, assignee->>'name' as assignee_name
from linear_issues
where state->>'type' != 'completed' and state->>'type' != 'canceled'
order by priority;
select identifier, title, due_date, assignee->>'name' as assignee_name, team->>'name' as team_name
from linear_issues
where due_date < now()
and state->>'type' not in ('completed', 'canceled')
order by due_date;
select team->>'name' as team_name, priority_label, count(*) as issue_count
from linear_issues
where state->>'type' not in ('completed', 'canceled')
group by team->>'name', priority_label
order by team_name, issue_count desc;
select name, status->>'name' as status, progress, start_date, target_date, lead->>'name' as lead_name
from linear_projects
where status->>'type' not in ('canceled', 'completed')
order by target_date;
select u.name, u.email, u.admin as is_admin, u.active as is_active
from linear_users u
where u.active is true
order by u.name;
select identifier, title, team->>'name' as team_name, created_at
from linear_issues
where assignee is null
and state->>'type' not in ('completed', 'canceled')
order by created_at desc;
select team->>'name' as team_name, name as state_name, type, position
from linear_workflow_states
order by team->>'name', position;
select c.body, c.created_at, c.user->>'name' as commenter, c.issue->>'identifier' as issue_identifier
from linear_comments c
order by c.created_at desc
limit 50;
select c.name as cycle_name, c.starts_at, c.ends_at, c.progress
from linear_cycles c
where c.starts_at <= now() and c.ends_at >= now()
order by c.starts_at;
select title, updated_at, creator->>'name' as author, project->>'name' as project_name
from linear_documents
order by updated_at desc
limit 20;