Asana connector reference

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Asana from the Previews page. See Manage Azure Databricks previews.

The managed Asana connector in Lakeflow Connect supports 24 source tables in the default schema. All tables use full refresh, so each pipeline update reingests every record.

Supported source tables

The Asana connector supports the following source tables, all under the default source schema:

Source table Primary key Description Sync mode Cursor field
workspaces gid Workspaces and organizations that the authorizing user belongs to. Full refresh only
users workspace_gid, gid Users in each workspace, including their email addresses and profile photos. Full refresh only
teams workspace_gid, gid Teams in each organization, including their descriptions and access settings. Full refresh only
team_memberships team_gid, gid Memberships of users in each team. Full refresh only
projects team_gid, gid Projects in each team, including their status, dates, owners, and members. Full refresh only
sections project_gid, gid Sections in each project. Full refresh only
tasks section_gid, gid Tasks in each project section, including assignees, dates, memberships, and custom field values. Full refresh only
stories section_gid, task_gid, gid Stories on each task, including comments and activity such as field changes. Full refresh only
tags workspace_gid, gid Tags in each workspace. Full refresh only
custom_fields workspace_gid, gid Custom field definitions in each workspace. Full refresh only
task_attachments section_gid, task_gid, gid Attachments on each task. Full refresh only
portfolios workspace_gid, gid Portfolios that the authorizing user owns in each workspace. Full refresh only
portfolio_memberships portfolio_gid, gid Memberships of users in each portfolio that the authorizing user owns. Full refresh only
portfolio_items portfolio_gid, gid Items in each portfolio that the authorizing user owns. Full refresh only
project_memberships project_gid, gid Memberships of users and teams in each project. Full refresh only
custom_field_settings project_gid, gid Custom fields associated with each project. Full refresh only
project_status_updates project_gid, gid Status updates on each project. Full refresh only
portfolio_status_updates portfolio_gid, gid Status updates on each portfolio that the authorizing user owns. Full refresh only
goal_status_updates goal_gid, gid Status updates on each goal. Full refresh only
workspace_memberships workspace_gid, gid Memberships of users in each workspace. Full refresh only
goals workspace_gid, gid Goals in each workspace. Full refresh only
goal_relationships goal_gid, gid Relationships between each goal and the projects, portfolios, or goals that support it. Full refresh only
time_tracking_entries section_gid, task_gid, gid Time tracking entries on each task. Full refresh only
project_attachments project_gid, gid Attachments on each project. Full refresh only

Connector options

The Asana connector has no additional configuration options beyond the pipeline settings available for all managed connectors. See Ingest data from Asana.

Destination table schemas

workspaces

Primary key: gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
email_domains ARRAY<STRING>
is_organization BOOLEAN

users

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
custom_fields ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
email STRING
photo STRUCT<image_21x21: STRING, image_27x27: STRING, image_36x36: STRING, image_60x60: STRING, image_128x128: STRING, image_1024x1024: STRING>
workspaces ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace_gid STRING

teams

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
custom_field_settings ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
description STRING
edit_team_name_or_description_access_level STRING
edit_team_visibility_or_trash_team_access_level STRING
endorsed BOOLEAN
guest_invite_management_access_level STRING
html_description STRING
join_request_management_access_level STRING
member_invite_management_access_level STRING
organization STRUCT<gid: STRING, resource_type: STRING>
permalink_url STRING
team_content_management_access_level STRING
team_member_removal_access_level STRING
visibility STRING
workspace_gid STRING

team_memberships

Primary key: team_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
is_admin BOOLEAN
is_guest BOOLEAN
is_limited_access BOOLEAN
team STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user STRUCT<gid: STRING, resource_type: STRING, name: STRING>
team_gid STRING

projects

Primary key: team_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
archived BOOLEAN
color STRING
completed BOOLEAN
completed_at TIMESTAMP
completed_by STRUCT<gid: STRING, resource_type: STRING>
created_at TIMESTAMP
created_from_template STRUCT<gid: STRING, resource_type: STRING>
current_status STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type STRUCT<gid: STRING, resource_type: STRING>
default_access_level STRING
default_view STRING
is_template BOOLEAN
due_date DATE
due_on DATE
followers ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes STRING
icon STRING
members ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization STRING
minimum_access_level_for_sharing STRING
modified_at TIMESTAMP
notes STRING
owner STRUCT<gid: STRING, resource_type: STRING>
permalink_url STRING
privacy_setting STRING
project_brief STRUCT<gid: STRING, resource_type: STRING>
public BOOLEAN
resource_subtype STRING
start_on DATE
team STRUCT<gid: STRING, resource_type: STRING>
workspace STRUCT<gid: STRING, resource_type: STRING>
team_gid STRING

sections

Primary key: project_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
created_at TIMESTAMP
project STRUCT<gid: STRING, resource_type: STRING, name: STRING>
projects ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
project_gid STRING

tasks

Primary key: section_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
actual_time_minutes DOUBLE
approval_status STRING
assigned_by STRUCT<gid: STRING, resource_type: STRING>
assignee STRUCT<gid: STRING, resource_type: STRING>
assignee_section STRUCT<gid: STRING, resource_type: STRING>
assignee_status STRING
completed BOOLEAN
completed_at TIMESTAMP
completed_by STRUCT<gid: STRING, resource_type: STRING>
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING>
custom_fields VARIANT
custom_type STRUCT<gid: STRING, resource_type: STRING>
custom_type_status_option STRUCT<gid: STRING, resource_type: STRING>
dependencies ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
dependents ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
due_at TIMESTAMP
due_on DATE
effective_memberships VARIANT
external STRUCT<gid: STRING, data: STRING>
followers ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
hearted BOOLEAN
hearts ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_notes STRING
is_rendered_as_separator BOOLEAN
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
memberships VARIANT
modified_at TIMESTAMP
notes STRING
num_hearts BIGINT
num_likes BIGINT
num_subtasks BIGINT
parent STRUCT<gid: STRING, resource_type: STRING>
permalink_url STRING
projects ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
resource_subtype STRING
start_at TIMESTAMP
start_on DATE
tags ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
workspace STRUCT<gid: STRING, resource_type: STRING>
project_gid STRING
section_gid STRING

stories

Primary key: section_gid, task_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
assignee STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
custom_field STRUCT<gid: STRING, resource_type: STRING, name: STRING>
dependency STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicate_of STRUCT<gid: STRING, resource_type: STRING, name: STRING>
duplicated_from STRUCT<gid: STRING, resource_type: STRING, name: STRING>
follower STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted BOOLEAN
hearts ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text STRING
is_editable BOOLEAN
is_edited BOOLEAN
is_pinned BOOLEAN
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
new_approval_status STRING
new_date_value VARIANT
new_dates VARIANT
new_enum_value VARIANT
new_multi_enum_values VARIANT
new_name STRING
new_number_value BIGINT
new_people_value ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
new_resource_subtype STRING
new_section STRUCT<gid: STRING, resource_type: STRING, name: STRING>
new_text_value STRING
num_hearts BIGINT
num_likes BIGINT
old_approval_status STRING
old_date_value VARIANT
old_dates VARIANT
old_enum_value VARIANT
old_multi_enum_values VARIANT
old_name STRING
old_number_value BIGINT
old_people_value ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
old_resource_subtype STRING
old_section STRUCT<gid: STRING, resource_type: STRING, name: STRING>
old_text_value STRING
previews VARIANT
project STRUCT<gid: STRING, resource_type: STRING, name: STRING>
reaction_summary ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype STRING
source STRING
sticker_name STRING
story STRUCT<gid: STRING, resource_type: STRING, name: STRING>
tag STRUCT<gid: STRING, resource_type: STRING, name: STRING>
target STRUCT<gid: STRING, resource_type: STRING>
task STRUCT<gid: STRING, resource_type: STRING, name: STRING>
text STRING
type STRING
section_gid STRING
task_gid STRING

tags

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
color STRING
created_at TIMESTAMP
followers ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
notes STRING
permalink_url STRING
workspace STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid STRING

custom_fields

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
asana_created_field STRING
created_by STRUCT<gid: STRING, resource_type: STRING>
currency_code STRING
custom_label STRING
custom_label_position STRING
date_value STRUCT<date: STRING, date_time: STRING>
default_access_level STRING
description STRING
display_value STRING
enabled BOOLEAN
enum_options ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
enum_value STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>
format STRING
has_notifications_enabled BOOLEAN
html_text_value STRING
id_prefix STRING
input_restrictions ARRAY<STRING>
is_formula_field BOOLEAN
is_global_to_workspace BOOLEAN
is_value_read_only BOOLEAN
multi_enum_values ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>
number_value DOUBLE
people_value ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
precision BIGINT
privacy_setting STRING
reference_value ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
representation_type STRING
resource_subtype STRING
text_value STRING
type STRING
workspace_gid STRING

task_attachments

Primary key: section_gid, task_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
connected_to_app BOOLEAN
created_at TIMESTAMP
download_url STRING
host STRING
parent STRUCT<gid: STRING, resource_type: STRING>
permanent_url STRING
resource_subtype STRING
size BIGINT
view_url STRING
section_gid STRING
task_gid STRING

portfolios

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
archived BOOLEAN
color STRING
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
current_status_update STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type STRUCT<gid: STRING, resource_type: STRING>
default_access_level STRING
due_on DATE
members ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
owner STRUCT<gid: STRING, resource_type: STRING, name: STRING>
permalink_url STRING
privacy_setting STRING
project_templates ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
public BOOLEAN
resource_subtype STRING
start_on DATE
workspace STRUCT<gid: STRING, resource_type: STRING>
workspace_gid STRING

portfolio_memberships

Primary key: portfolio_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
access_level STRING
member STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent STRUCT<gid: STRING, resource_type: STRING, name: STRING>
portfolio_gid STRING

portfolio_items

Primary key: portfolio_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
archived BOOLEAN
color STRING
completed BOOLEAN
completed_at TIMESTAMP
completed_by STRUCT<gid: STRING, resource_type: STRING>
created_at TIMESTAMP
created_from_template STRUCT<gid: STRING, resource_type: STRING>
current_status STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>
current_status_update STRUCT<gid: STRING, resource_type: STRING>
custom_field_settings ARRAY<STRUCT<gid: STRING, resource_type: STRING>>
custom_fields ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
custom_type STRUCT<gid: STRING, resource_type: STRING>
default_access_level STRING
default_view STRING
is_template BOOLEAN
due_date DATE
due_on DATE
followers ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
html_notes STRING
icon STRING
members ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
minimum_access_level_for_customization STRING
minimum_access_level_for_sharing STRING
modified_at TIMESTAMP
notes STRING
owner STRUCT<gid: STRING, resource_type: STRING>
permalink_url STRING
privacy_setting STRING
project_brief STRUCT<gid: STRING, resource_type: STRING>
public BOOLEAN
resource_subtype STRING
start_on DATE
team STRUCT<gid: STRING, resource_type: STRING>
workspace STRUCT<gid: STRING, resource_type: STRING>
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
project_templates ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
portfolio_gid STRING

project_memberships

Primary key: project_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
access_level STRING
write_access STRING
member STRUCT<gid: STRING, resource_type: STRING, name: STRING>
parent STRUCT<gid: STRING, resource_type: STRING>
project_gid STRING

custom_field_settings

Primary key: project_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
custom_field VARIANT
is_important BOOLEAN
parent STRUCT<gid: STRING, resource_type: STRING>
project STRUCT<gid: STRING, resource_type: STRING>
project_gid STRING

project_status_updates

Primary key: project_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
author STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted BOOLEAN
hearts ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text STRING
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at TIMESTAMP
num_hearts BIGINT
num_likes BIGINT
parent STRUCT<gid: STRING, resource_type: STRING>
reaction_summary ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype STRING
status_type STRING
text STRING
title STRING
project_gid STRING

portfolio_status_updates

Primary key: portfolio_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
author STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted BOOLEAN
hearts ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text STRING
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at TIMESTAMP
num_hearts BIGINT
num_likes BIGINT
parent STRUCT<gid: STRING, resource_type: STRING>
reaction_summary ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype STRING
status_type STRING
text STRING
title STRING
portfolio_gid STRING

goal_status_updates

Primary key: goal_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
author STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at TIMESTAMP
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
hearted BOOLEAN
hearts ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
html_text STRING
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
modified_at TIMESTAMP
num_hearts BIGINT
num_likes BIGINT
parent STRUCT<gid: STRING, resource_type: STRING>
reaction_summary ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>
resource_subtype STRING
status_type STRING
text STRING
title STRING
goal_gid STRING

workspace_memberships

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
created_at TIMESTAMP
is_active BOOLEAN
is_admin BOOLEAN
is_guest BOOLEAN
is_view_only BOOLEAN
user STRUCT<gid: STRING, resource_type: STRING, name: STRING>
user_task_list STRUCT<gid: STRING, resource_type: STRING>
vacation_dates STRUCT<start_on: STRING, end_on: STRING>
workspace STRUCT<gid: STRING, resource_type: STRING, name: STRING>
workspace_gid STRING

goals

Primary key: workspace_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
owner STRUCT<gid: STRING, resource_type: STRING>
team STRUCT<gid: STRING, resource_type: STRING>
workspace STRUCT<gid: STRING, resource_type: STRING>
html_notes STRING
notes STRING
due_on DATE
start_on DATE
status STRING
metric STRUCT<gid: STRING, resource_subtype: STRING, precision: BIGINT, unit: STRING, currency_code: STRING, initial_number_value: DOUBLE, target_number_value: DOUBLE, current_number_value: DOUBLE, current_display_value: STRING, progress_source: STRING, is_custom_weight: BOOLEAN, can_manage: BOOLEAN>
time_period STRUCT<gid: STRING, resource_type: STRING>
is_workspace_level BOOLEAN
liked BOOLEAN
likes ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>
num_likes BIGINT
followers ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>
current_status_update STRUCT<gid: STRING, resource_type: STRING>
created_by STRUCT<gid: STRING, resource_type: STRING>
workspace_gid STRING

goal_relationships

Primary key: goal_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
resource_subtype STRING
supporting_resource STRUCT<gid: STRING, resource_type: STRING, name: STRING>
supported_goal STRUCT<gid: STRING, resource_type: STRING, name: STRING>
contribution_weight DOUBLE
goal_gid STRING

time_tracking_entries

Primary key: section_gid, task_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
duration_minutes BIGINT
entered_on DATE
created_by STRUCT<gid: STRING, resource_type: STRING, name: STRING>
created_at TIMESTAMP
section_gid STRING
task_gid STRING

project_attachments

Primary key: project_gid, gid

Sync mode: Full refresh only

Field Data type
gid STRING
resource_type STRING
name STRING
connected_to_app BOOLEAN
created_at TIMESTAMP
download_url STRING
host STRING
parent STRUCT<gid: STRING, resource_type: STRING>
permanent_url STRING
resource_subtype STRING
size BIGINT
view_url STRING
project_gid STRING
  • Last updated on