Skip to content
Book a demoStart free
Connectors

Asana connector

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

Asana connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Asana 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 Asana project data into BigQuery with Kaivo to report on tasks, progress, and workload across your workspace.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Asana 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 Personal Access Token.

Field Description
Personal Access Token
Asana Personal Access Token (generate yours here).

|

When you set up the connector, you provide:

Field Description
Organization Export IDs
Globally unique identifiers for the organization exports

|

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

custom_fields (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
created_by__gid STRING
created_by__resource_type STRING
created_by__name STRING
currency_code STRING
custom_label STRING
custom_label_position STRING
description STRING
display_value STRING
enabled BOOL
enum_value__gid STRING
enum_value__resource_type STRING
enum_value__color STRING
enum_value__enabled BOOL
enum_value__name STRING
format STRING
has_notifications_enabled BOOL
is_global_to_workspace BOOL
number_value FLOAT64
precision INT64
resource_subtype STRING
text_value STRING
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
color STRING
enabled BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
user__gid STRING
user__resource_type STRING
user__name STRING
resource__gid STRING
resource__resource_type STRING
resource__name STRING
type STRING
action STRING
parent__gid STRING
parent__resource_type STRING
parent__name STRING
created_at TIMESTAMP
change__field STRING
change__action STRING
change__new_value__gid STRING
change__new_value__resource_type STRING
change__added_value__gid STRING
change__added_value__resource_type STRING
change__removed_value__gid STRING
change__removed_value__resource_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organization_exports (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
created_at TIMESTAMP
download_url STRING
state STRING
organization__gid STRING
organization__resource_type STRING
organization__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
portfolio_items (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
portfolios (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
color STRING
created_at TIMESTAMP
created_by__gid STRING
created_by__resource_type STRING
created_by__name STRING
current_status_update__gid STRING
current_status_update__resource_type STRING
current_status_update__title STRING
current_status_update__resource_subtype STRING
due_on TIMESTAMP
members__gid STRING
members__resource_type STRING
members__name STRING
owner__gid STRING
owner__resource_type STRING
owner__name STRING
start_on TIMESTAMP
workspace__gid STRING
workspace__resource_type STRING
workspace__name STRING
permalink_url STRING
public BOOL
project_templates__gid STRING
project_templates__resource_type STRING
project_templates__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
portfolios_compact (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
portfolios_memberships (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
portfolio__gid STRING
portfolio__resource_type STRING
portfolio__name STRING
user__gid STRING
user__resource_type STRING
user__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
archived BOOL
color STRING
created_at TIMESTAMP
current_status__gid STRING
current_status__resource_type STRING
current_status__title STRING
current_status__author__gid STRING
current_status__author__resource_type STRING
current_status__author__name STRING
current_status__color STRING
current_status__html_text STRING
current_status__modified_at TIMESTAMP
current_status__text STRING
current_status__created_at TIMESTAMP
current_status__created_by__gid STRING
current_status__created_by__resource_type STRING
current_status__created_by__name STRING
default_view STRING
due_date DATE
due_on DATE
html_notes STRING
is_template BOOL
modified_at TIMESTAMP
notes STRING
public BOOL
start_on DATE
workspace__gid STRING
workspace__resource_type STRING
workspace__name STRING
icon STRING
owner__gid STRING
owner__resource_type STRING
owner__name STRING
permalink_url STRING
team__gid STRING
team__resource_type STRING
team__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
display_value STRING
enabled BOOL
name STRING
number_value FLOAT64
resource_subtype STRING
text_value BOOL
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: projects__custom_fields__enum_options

Section titled “Subtable: projects__custom_fields__enum_options”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
color STRING
enabled BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sections_compact (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stories_compact (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
created_at TIMESTAMP
created_by__gid STRING
created_by__resource_type STRING
created_by__name STRING
resource_subtype STRING
text STRING
type STRING
task__gid STRING
task__resource_type STRING
task__name STRING
task__resource_subtype STRING
target__gid STRING
target__resource_type STRING
target__name STRING
target__resource_subtype STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
color STRING
name STRING
permalink_url STRING
workspace__gid STRING
workspace__resource_type STRING
workspace__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
approval_status STRING
completed BOOL
completed_at TIMESTAMP
completed_by__gid STRING
completed_by__resource_type STRING
completed_by__name STRING
created_at TIMESTAMP
due_at TIMESTAMP
due_on DATE
external__data STRING
external__gid STRING
hearted BOOL
html_notes STRING
is_rendered_as_separator BOOL
liked BOOL
modified_at TIMESTAMP
notes STRING
num_hearts INT64
num_likes INT64
num_subtasks INT64
actual_time_minutes INT64 The actual time spent on the task in minutes
resource_subtype STRING
start_on DATE
assignee__gid STRING
assignee__resource_type STRING
assignee__name STRING
parent__gid STRING
parent__resource_type STRING
parent__name STRING
permalink_url STRING
workspace__gid STRING
workspace__resource_type STRING
workspace__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
user__gid STRING
user__resource_type STRING
user__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
user__gid STRING
user__resource_type STRING
user__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
project__gid STRING
project__resource_type STRING
project__name STRING
section__gid STRING
section__resource_type STRING
section__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
created_by__gid STRING
created_by__resource_type STRING
created_by__name STRING
currency_code STRING
custom_label STRING
custom_label_position STRING
description STRING
display_value STRING
enabled BOOL
enum_value__gid STRING
enum_value__resource_type STRING
enum_value__color STRING
enum_value__enabled BOOL
enum_value__name STRING
format STRING
has_notifications_enabled BOOL
is_global_to_workspace BOOL
name STRING
number_value FLOAT64
precision INT64
resource_subtype STRING
text_value STRING
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: tasks__custom_fields__enum_options

Section titled “Subtable: tasks__custom_fields__enum_options”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
color STRING
enabled BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
team_memberships (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
is_guest BOOL
team__gid STRING
team__resource_type STRING
team__name STRING
user__gid STRING
user__resource_type STRING
user__name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
description STRING
html_description STRING
organization__gid STRING
organization__resource_type STRING
organization__name STRING
permalink_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
email STRING
photo__image_128x128 STRING
photo__image_21x21 STRING
photo__image_27x27 STRING
photo__image_36x36 STRING
photo__image_60x60 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workspaces (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
gid STRING
resource_type STRING
name STRING
is_organization BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Asana 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 Asana?

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

It depends on how much history is in your Asana 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 Asana’s schema changes?

Section titled “What happens when Asana’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 Asana, 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 Asana 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 Asana connector in Kaivo and all of its synced data is deleted with it.

Track tasks against projects and sections to see what is on time and what is slipping.

Join tasks with users and teams to balance load across the team.

Use portfolios to roll up status across many projects at once.

Bring custom_fields into BigQuery to slice work by your own categories.

Once Asana 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 Asana 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 Asana 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.