Release Notes
April 2023
We have added a new optional toggle, Show Advanced Options, to the connector setup form. The toggle allows you to filter the project list by team ID when you select the Synchronize specific projects sync mode. For more information, see our setup instructions.
December 2022
We have added a new table, GOAL_RELATIONSHIP
, which stores information about the relationship between a goal and another goal, a project, or a portfolio.
We will deprecate the GOAL_SUPPORTING_WORK
table on February 1, 2023. Be sure to update your queries.
September 2022
We now check the following columns of the following user-related tables during the sync to ensure data completeness in the USER
table:
TABLE | COLUMNS |
---|---|
PORTFOLIO | owner_id and created_by_id |
PORTFOLIO_MEMBER | user_id |
STORY | created_by_id |
STORY_HEART | user_id |
TASK | assignee_id and completed_by_id |
TASK_FOLLOWER | user_id |
TAG_FOLLOWER | user_id |
Previously, some user records synced to the USER
table might have been missed during syncs.
July 2022
We have added the Date
and Person
custom fields to the TASK
and PORTFOLIO
tables.
April 2022
We have added the following new tables that store data about goals in Asana:
GOAL
GOAL_FOLLOWER
GOAL_STATUS
GOAL_SUPPORTING_WORK
March 2022
We now sync a new column, created_by_id
, to the TASK
table.
January 2022
We now sync a new column, portfolio_id
, and portfolio custom fields to the CUSTOM_FIELD
table.
December 2021
We have added a new table, PROJECT_STATUS
, that stores historical information about project status changes.
We now sync the following custom field properties to the CUSTOM_FIELD
table:
id
name
description
type
workspace_id
project_id
November 2021
We have added a new column, resource_subtype
, to the TASK
table.
If you want to sync historical data for this column, contact Fivetran Support to re-sync the TASK
table.
October 2021
We now sync the Multi-select enums
custom field.
September 2021
Our Asana connector now uses multithreading when syncing projects. To avoid exceeding API rate limits, we use 3 parallel threads for Asana Basic accounts and 10 parallel threads for Asana Premium, Business, and Enterprise accounts.
July 2021
Now we use the Asana Batch API during the initial sync. According to our benchmarks, the initial sync time was reduced, on average, by 40%. We are gradually rolling out this feature.
We have added custom fields for the PROJECT
table.
We have added the following tables:
PORTFOLIO
PORTFOLIO_MEMBER
PORTFOLIO_ITEM
IMPORTANT: The current API user should be the owner of the portfolios to sync the tables. Portfolios are available to Asana Business and Asana Enterprise users. If you are not on any these plans, we cannot sync project-level custom fields and portfolio-related tables.
June 2021
We have removed the hearted
and assignee_status
fields from the TASK
table.
We have added a new field, num_likes
, to replace the num_hearts
field in the TASK
table. Asana has deprecated the num_hearts
field. We will deprecate the num_hearts
field from the TASK
table after July 31, 2021. Be sure to update your queries.
May 2021
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Asana connector by adding the auth
section to payloads.
We have added a new field, current_status_color
, to the PROJECT
table to represent the overall state of the project (green
- On Track, yellow
- At Risk, red
- Off Track, blue
- On Hold).
March 2021
We have added a new field, liked
, to replace the hearted
field in the TASK
table. Asana has deprecated the hearted
field. We will deprecate the hearted
field from the TASK
table after May 31, 2021. Be sure to update your queries.
We will deprecate the assignee_status
field to support Asana's breaking changes after May 31, 2021. Be sure to update your queries.
August 2020
We have released pre-built, dbt Core-compatible data models for Asana. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
June 2020
You can now control which projects will be synced. Project IDs are now listed in the Specific Projects section of the Fivetran setup form.
May 2020
You can now configure your Asana connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
February 2020
We have added the completed_by_id
column to the TASK
table. Asana recently added this field to the Asana API Task endpoint. It lets you know who completed the task.
March 2019
We have added a new column, start_on
, to the TASK
table.
August 2018
We have added a new table, TASK_SECTION
, which is a join table of the TASK
and SECTION
tables.
We have deprecated the section_id
column from the TASK
table.
July 2018
We have removed the STORY_EVENT
table.