This package models Asana data from Fivetran's connector. It uses data in the format described by this ERD.
This package enables you to better understand tasks and how they're being worked on in Asana. Its primary focus is to enhance the task table and other core objects that relate to tasks: users, projects, teams, and tags. Each of these objects is enriched with metrics that reflect the volume and breadth of work being done now and the velocity of work that has been completed. Moreover, the daily metrics table lays out a timeline of task creations and completions for understanding the overall pace of deliverables at the organization.
This package contains transformation models, designed to work simultaneously with our Asana source package. A depenedency on the source package is declared in this package's packages.yml file, so it will automatically download when you run dbt deps. The primary outputs of this package are described below. Intermediate models are used to create these output models.
| model | description |
|---|---|
| asana_task | Each record represents an Asana task, enriched with data about its assignee, projects, sections, tasks, teams, tags, parent task, comments, followers, and activity. |
| asana_user | Each record represents an Asana user, enriched with metrics about their completed tasks, open tasks, and the projects they work on. Also includes data about the user's most recently completed task and their next due task. |
| asana_project | Each record represents an Asana project, enriched with metrics about their completed tasks, open tasks, and the users involved in the project. Also includes data about the project's most recently completed task and next due tasks. |
| asana_team | Each record represents an Asana team, enriched with data about their completed tasks, open tasks, their projects, and the users involved with the team. |
| asana_tag | Each record represents an Asana tag, enriched with metrics about open and completed tasks associated with the tag. |
| asana_daily_metrics | Each record represents a single day, enriched with metrics about tasks opened at created that day. |
Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.
By default, this package will look for your Asana data in the asana schema of your target database. If this is not where your Asana data is, please add the following configuration to your dbt_project.yml file:
# dbt_project.yml
...
config-version: 2
vars:
asana_source:
asana_database: your_database_name
asana_schema: your_schema_name Additional contributions to this package are very welcome! Please create issues
or open PRs against master. Check out
this post
on the best workflow for contributing to a package.
- Learn more about Fivetran in the Fivetran docs
- Check out Fivetran's blog
- Learn more about dbt in the dbt docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the dbt blog for the latest news on dbt's development and best practices