Asana connector reference

Beta

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Asana from the Previews page. See Manage 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
`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

Source table	Primary key	Description	Sync mode
`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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

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`

Supported source tables​

Connector options​

Destination table schemas​

workspaces​

users​

teams​

team_memberships​

projects​

sections​

tasks​

stories​

tags​

custom_fields​

task_attachments​

portfolios​

portfolio_memberships​

portfolio_items​

project_memberships​

custom_field_settings​

project_status_updates​

portfolio_status_updates​

goal_status_updates​

workspace_memberships​

goals​

goal_relationships​

time_tracking_entries​

project_attachments​

Supported source tables

Connector options

Destination table schemas

`workspaces`

`users`

`teams`

`team_memberships`

`projects`

`sections`

`tasks`

`stories`

`tags`

`custom_fields`

`task_attachments`

`portfolios`

`portfolio_memberships`

`portfolio_items`

`project_memberships`

`custom_field_settings`

`project_status_updates`

`portfolio_status_updates`

`goal_status_updates`

`workspace_memberships`

`goals`

`goal_relationships`

`time_tracking_entries`

`project_attachments`