Skip to content
Book a demoStart free
Connectors

Shortcut connector

Set up the Shortcut connector in Kaivo: authentication, configuration, the 23 BigQuery tables it syncs, and answers to common questions.

Shortcut connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Shortcut data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your project management data instead of moving it.

Sync your Shortcut stories, epics, and iterations into BigQuery with Kaivo to report on engineering delivery alongside the rest of your data.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service

Getting started with the Shortcut connector

Section titled “Getting started with the Shortcut connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Shortcut account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

Kaivo syncs 23 tables from Shortcut into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

categories (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
archived BOOL
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
categories_milestones (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
completed BOOL
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
position FLOAT64
started BOOL
started_at_override STRING
state STRING
stats__num_related_documents FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • categories_milestones__categories (11 columns)
  • categories_milestones__key_result_ids (4 columns)
categories_objectives (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
completed BOOL
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
position FLOAT64
started BOOL
started_at_override STRING
state STRING
stats__num_related_documents FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • categories_objectives__categories (11 columns)
  • categories_objectives__key_result_ids (4 columns)
custom-fields (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
canonical_name STRING
created_at STRING
enabled BOOL
entity_type STRING
field_type STRING
fixed_position BOOL
id STRING
name STRING
position FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • custom-fields__story_types (4 columns)
  • custom-fields__values (9 columns)
epic-workflow (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
default_epic_state_id FLOAT64
entity_type STRING
id FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • epic-workflow__epic_states (12 columns)
epics (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_state_id FLOAT64
global_id STRING
group_id STRING
id FLOAT64
milestone_id FLOAT64
name STRING
planned_start_date STRING
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
state STRING
stats__last_story_update STRING
stats__num_points FLOAT64
stats__num_points_backlog FLOAT64
stats__num_points_done FLOAT64
stats__num_points_started FLOAT64
stats__num_points_unstarted FLOAT64
stats__num_related_documents FLOAT64
stats__num_stories_backlog FLOAT64
stats__num_stories_done FLOAT64
stats__num_stories_started FLOAT64
stats__num_stories_total FLOAT64
stats__num_stories_unestimated FLOAT64
stats__num_stories_unstarted FLOAT64
stories_without_projects FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • epics__follower_ids (4 columns)
  • epics__group_ids (4 columns)
  • epics__group_mention_ids (4 columns)
  • epics__label_ids (4 columns)
  • epics__labels (13 columns)
  • epics__member_mention_ids (4 columns)
  • epics__mention_ids (4 columns)
  • epics__objective_ids (4 columns)
  • epics__owner_ids (4 columns)
  • epics__project_ids (4 columns)
epics_comments (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
author_id STRING
created_at STRING
deleted BOOL
entity_type STRING
id FLOAT64
text STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • epics_comments__comments (11 columns)
  • epics_comments__comments__comments (4 columns)
  • epics_comments__comments__group_mention_ids (4 columns)
  • epics_comments__comments__member_mention_ids (4 columns)
  • epics_comments__comments__mention_ids (4 columns)
  • epics_comments__group_mention_ids (4 columns)
  • epics_comments__member_mention_ids (4 columns)
  • epics_comments__mention_ids (4 columns)
epics_stories (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
archived BOOL
blocked BOOL
blocker BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_id FLOAT64
estimate FLOAT64
global_id STRING
group_id STRING
id FLOAT64
iteration_id FLOAT64
moved_at STRING
name STRING
num_tasks_completed FLOAT64
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
stats__num_related_documents FLOAT64
story_type STRING
updated_at STRING
workflow_id FLOAT64
workflow_state_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • epics_stories__comment_ids (4 columns)
  • epics_stories__custom_fields (4 columns)
  • epics_stories__external_links (4 columns)
  • epics_stories__file_ids (4 columns)
  • epics_stories__follower_ids (4 columns)
  • epics_stories__group_mention_ids (4 columns)
  • epics_stories__label_ids (4 columns)
  • epics_stories__labels (4 columns)
  • epics_stories__linked_file_ids (4 columns)
  • epics_stories__member_mention_ids (4 columns)
  • epics_stories__mention_ids (4 columns)
  • epics_stories__owner_ids (4 columns)
  • epics_stories__previous_iteration_ids (4 columns)
  • epics_stories__story_links (4 columns)
  • epics_stories__task_ids (4 columns)
files (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
content_type STRING
created_at STRING
entity_type STRING
filename STRING
id FLOAT64
name STRING
size FLOAT64
updated_at STRING
uploader_id STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • files__group_mention_ids (4 columns)
  • files__member_mention_ids (4 columns)
  • files__mention_ids (4 columns)
  • files__story_ids (4 columns)
groups (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
entity_type STRING
global_id STRING
id STRING
mention_name STRING
name STRING
num_epics_started FLOAT64
num_stories FLOAT64
num_stories_backlog FLOAT64
num_stories_started FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • groups__member_ids (4 columns)
  • groups__workflow_ids (4 columns)
groups_stories (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
archived BOOL
blocked BOOL
blocker BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_id FLOAT64
estimate FLOAT64
global_id STRING
group_id STRING
id FLOAT64
iteration_id FLOAT64
moved_at STRING
name STRING
num_tasks_completed FLOAT64
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
stats__num_related_documents FLOAT64
story_type STRING
updated_at STRING
workflow_id FLOAT64
workflow_state_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • groups_stories__comment_ids (4 columns)
  • groups_stories__custom_fields (4 columns)
  • groups_stories__external_links (4 columns)
  • groups_stories__file_ids (4 columns)
  • groups_stories__follower_ids (4 columns)
  • groups_stories__group_mention_ids (4 columns)
  • groups_stories__label_ids (4 columns)
  • groups_stories__labels (4 columns)
  • groups_stories__linked_file_ids (4 columns)
  • groups_stories__member_mention_ids (4 columns)
  • groups_stories__mention_ids (4 columns)
  • groups_stories__owner_ids (4 columns)
  • groups_stories__previous_iteration_ids (4 columns)
  • groups_stories__story_links (4 columns)
  • groups_stories__task_ids (4 columns)
iterations (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
created_at STRING
end_date STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
start_date STRING
stats__num_points FLOAT64
stats__num_points_backlog FLOAT64
stats__num_points_done FLOAT64
stats__num_points_started FLOAT64
stats__num_points_unstarted FLOAT64
stats__num_related_documents FLOAT64
stats__num_stories_backlog FLOAT64
stats__num_stories_done FLOAT64
stats__num_stories_started FLOAT64
stats__num_stories_unestimated FLOAT64
stats__num_stories_unstarted FLOAT64
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • iterations__follower_ids (4 columns)
  • iterations__group_ids (4 columns)
  • iterations__group_mention_ids (4 columns)
  • iterations__label_ids (4 columns)
  • iterations__labels (4 columns)
  • iterations__member_mention_ids (4 columns)
  • iterations__mention_ids (4 columns)
iterations_stories (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
archived BOOL
blocked BOOL
blocker BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_id FLOAT64
estimate FLOAT64
global_id STRING
group_id STRING
id FLOAT64
iteration_id FLOAT64
moved_at STRING
name STRING
num_tasks_completed FLOAT64
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
stats__num_related_documents FLOAT64
story_type STRING
updated_at STRING
workflow_id FLOAT64
workflow_state_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • iterations_stories__comment_ids (4 columns)
  • iterations_stories__custom_fields (4 columns)
  • iterations_stories__external_links (4 columns)
  • iterations_stories__file_ids (4 columns)
  • iterations_stories__follower_ids (4 columns)
  • iterations_stories__group_mention_ids (4 columns)
  • iterations_stories__label_ids (4 columns)
  • iterations_stories__labels (4 columns)
  • iterations_stories__linked_file_ids (4 columns)
  • iterations_stories__member_mention_ids (4 columns)
  • iterations_stories__mention_ids (4 columns)
  • iterations_stories__owner_ids (4 columns)
  • iterations_stories__previous_iteration_ids (4 columns)
  • iterations_stories__story_links (4 columns)
  • iterations_stories__task_ids (4 columns)
labels (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
color STRING
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
stats__num_epics FLOAT64
stats__num_epics_completed FLOAT64
stats__num_epics_in_progress FLOAT64
stats__num_epics_total FLOAT64
stats__num_epics_unstarted FLOAT64
stats__num_points_backlog FLOAT64
stats__num_points_completed FLOAT64
stats__num_points_in_progress FLOAT64
stats__num_points_total FLOAT64
stats__num_points_unstarted FLOAT64
stats__num_related_documents FLOAT64
stats__num_stories_backlog FLOAT64
stats__num_stories_completed FLOAT64
stats__num_stories_in_progress FLOAT64
stats__num_stories_total FLOAT64
stats__num_stories_unestimated FLOAT64
stats__num_stories_unstarted FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
member (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
mention_name STRING
name STRING
workspace2__url_slug STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • member__workspace2__estimate_scale (4 columns)
members (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
created_without_invite BOOL
disabled BOOL
entity_type STRING
global_id STRING
id STRING
profile__deactivated BOOL
profile__email_address STRING
profile__entity_type STRING
profile__gravatar_hash STRING
profile__id STRING
profile__is_owner BOOL
profile__mention_name STRING
profile__name STRING
profile__two_factor_auth_activated BOOL
role STRING
state STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • members__group_ids (4 columns)
milestones (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
completed BOOL
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
position FLOAT64
started BOOL
started_at_override STRING
state STRING
stats__num_related_documents FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • milestones__categories (11 columns)
  • milestones__key_result_ids (4 columns)
milestones_epics (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
archived BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_state_id FLOAT64
global_id STRING
group_id STRING
id FLOAT64
milestone_id FLOAT64
name STRING
planned_start_date STRING
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
state STRING
stats__last_story_update STRING
stats__num_points FLOAT64
stats__num_points_backlog FLOAT64
stats__num_points_done FLOAT64
stats__num_points_started FLOAT64
stats__num_points_unstarted FLOAT64
stats__num_related_documents FLOAT64
stats__num_stories_backlog FLOAT64
stats__num_stories_done FLOAT64
stats__num_stories_started FLOAT64
stats__num_stories_total FLOAT64
stats__num_stories_unestimated FLOAT64
stats__num_stories_unstarted FLOAT64
stories_without_projects FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • milestones_epics__follower_ids (4 columns)
  • milestones_epics__group_ids (4 columns)
  • milestones_epics__group_mention_ids (4 columns)
  • milestones_epics__label_ids (4 columns)
  • milestones_epics__labels (4 columns)
  • milestones_epics__member_mention_ids (4 columns)
  • milestones_epics__mention_ids (4 columns)
  • milestones_epics__objective_ids (4 columns)
  • milestones_epics__owner_ids (4 columns)
  • milestones_epics__project_ids (4 columns)
objectives (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
app_url STRING
archived BOOL
completed BOOL
created_at STRING
entity_type STRING
global_id STRING
id FLOAT64
name STRING
position FLOAT64
started BOOL
started_at_override STRING
state STRING
stats__num_related_documents FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • objectives__categories (11 columns)
  • objectives__key_result_ids (4 columns)
objectives_epics (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
archived BOOL
completed BOOL
created_at STRING
deadline STRING
entity_type STRING
epic_state_id FLOAT64
global_id STRING
group_id STRING
id FLOAT64
milestone_id FLOAT64
name STRING
planned_start_date STRING
position FLOAT64
requested_by_id STRING
started BOOL
started_at STRING
state STRING
stats__last_story_update STRING
stats__num_points FLOAT64
stats__num_points_backlog FLOAT64
stats__num_points_done FLOAT64
stats__num_points_started FLOAT64
stats__num_points_unstarted FLOAT64
stats__num_related_documents FLOAT64
stats__num_stories_backlog FLOAT64
stats__num_stories_done FLOAT64
stats__num_stories_started FLOAT64
stats__num_stories_total FLOAT64
stats__num_stories_unestimated FLOAT64
stats__num_stories_unstarted FLOAT64
stories_without_projects FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • objectives_epics__follower_ids (4 columns)
  • objectives_epics__group_ids (4 columns)
  • objectives_epics__group_mention_ids (4 columns)
  • objectives_epics__label_ids (4 columns)
  • objectives_epics__labels (4 columns)
  • objectives_epics__member_mention_ids (4 columns)
  • objectives_epics__mention_ids (4 columns)
  • objectives_epics__objective_ids (4 columns)
  • objectives_epics__owner_ids (4 columns)
  • objectives_epics__project_ids (4 columns)
stories_comments (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
app_url STRING
author_id STRING
created_at STRING
deleted BOOL
entity_type STRING
id FLOAT64
linked_to_slack BOOL
position FLOAT64
story_id FLOAT64
text STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • stories_comments__group_mention_ids (4 columns)
  • stories_comments__member_mention_ids (4 columns)
  • stories_comments__mention_ids (4 columns)
  • stories_comments__reactions (4 columns)
story_history (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
changed_at STRING
id STRING
member_id STRING
primary_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • story_history__actions (21 columns)
  • story_history__actions__follower_ids (4 columns)
  • story_history__actions__owner_ids (4 columns)
  • story_history__actions__task_ids (4 columns)
  • story_history__references (8 columns)
workflows (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
auto_assign_owner BOOL
created_at STRING
default_state_id FLOAT64
entity_type STRING
id FLOAT64
name STRING
team_id FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • workflows__project_ids (4 columns)
  • workflows__states (15 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Shortcut supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Shortcut?

Section titled “How long does the initial sync take for Shortcut?”

It depends on how much history is in your Shortcut account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Shortcut’s schema changes?

Section titled “What happens when Shortcut’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Shortcut, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Shortcut instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Shortcut connector in Kaivo and all of its synced data is deleted with it.

Use stories and iterations to measure velocity and completion rates.

Track epics and their stories to report on progress against larger initiatives.

Analyse story states and timestamps to measure how long work takes.

Break stories down by group to monitor throughput and workload.

Once Shortcut data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Shortcut data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Shortcut connector pricing and plan details.

  • ClickUp: Sync ClickUp to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.
  • Harvest: Sync Harvest to BigQuery.
  • Jira: Sync Jira to BigQuery.
  • Kellokortti: Sync Kellokortti to BigQuery.