Asana dbt Package
This dbt package transforms data from Fivetran's Asana connector into analytics-ready tables.
Resources
- Number of materialized models¹: 28
- Connector documentation
- dbt package documentation
What does this dbt package do?
This package enables you to enhance task, user, project, team, and tag tables with metrics and provide daily metrics for task tracking. It creates enriched models with metrics focused on work volume, breadth, and velocity.
Output schema
Final output tables are generated in the following target schema:
<your_database>.<connector/schema_name>_asana
Final output tables
By default, this package materializes the following final tables:
| Table | Description |
|---|---|
| asana__task | Provides comprehensive task-level data including assignments, due dates, completion status, project associations, and custom field values to track work progress and team productivity. Example Analytics Questions:
|
| asana__user | Summarizes user activity and workload including assigned tasks, created tasks, completion metrics, and project involvement to understand individual productivity and capacity. Example Analytics Questions:
|
| asana__project | Tracks all Asana projects with completion metrics, ownership details, and privacy settings to understand project status, workload distribution, and team organization. Example Analytics Questions:
|
| asana__team | Tracks team-level metrics including total tasks, completion rates, and project counts to monitor team performance and workload balance across the organization. Example Analytics Questions:
|
| asana__tag | Aggregates task metrics by tag to categorize work, track themes, and analyze patterns across projects using Asana's tagging system. Example Analytics Questions:
|
| asana__daily_metrics | Summarizes daily task activity including tasks created, completed, and overall team productivity to track workflow trends and identify peak productivity periods. Example Analytics Questions:
|
¹ Each Quickstart transformation job run materializes these models if all components of this data model are enabled. This count includes all staging, intermediate, and final models materialized as view, table, or incremental.
Prerequisites
To use this dbt package, you must have the following:
- At least one Fivetran Asana connection syncing data into your destination.
- A BigQuery, Snowflake, Redshift, PostgreSQL, or Databricks destination.
How do I use the dbt package?
You can either add this dbt package in the Fivetran dashboard or import it into your dbt project:
- To add the package in the Fivetran dashboard, follow our Quickstart guide.
- To add the package to your dbt project, follow the setup instructions in the dbt package's README file to use this package.
How is this package maintained and can I contribute?
Package Maintenance
The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.
Contributions
A small team of analytics engineers at Fivetran develops these dbt packages. However, the packages are made better by community contributions.
We highly encourage and welcome contributions to this package. Learn how to contribute to a package in dbt's Contributing to an external dbt package article.