Asana Premium datasource
Asana is a project management tool that helps teams track their tasks and projects.
This slice collects data from an Asana account that have Asana Premium, Business or Enterprise subscriptions Asana API. This slice supports incremental data extracts for tasks and task related load units.
Steps to add this slice to your installation
The steps to launch your slice are:
- Generate Asana API keys
- Specify the slice config
- Add the Asana slice
1. Generate Asana API keys
Before getting started please make sure to have the following information:
- Access to an active Asana account
- Asana Premium, Business or Enterprise subscription level
The Asana slice requires an auth token to collect data. An auth token can be obtained from Asana through the following steps:
- Click on your initials in the right top corner of the Asana navigation banner and access "Admin Console"
- In the left sidebar menu, navigate to Apps > Service accounts.
- Click on "Add Service Account".
- Provide a name for the token, like "datacoral" and copy the Token
- Click on "Save Changes"
Adding the Asana slice
Step 1: Step 1: Download the params template
To get a template for the Asana Premium slice configuration save the output of the
describe --input-parameters command as follows:
Step 2: Populate auth_token information
asana_parameters_file file to add the auth_token generated from Asana
Step 3: Add the slice
Add the Asana slice to your installation
Slice load units
The Asana slice collects the following objects from the Asana API and makes them available for analysis.
workspaces: captures all the attributes for workspaces that anchors all data within Asana
projects: captures all the attributes for projects within a workspace
project_members: represents all members associated with a project projects. This information is derived from the project members array
project_current_status: represents the status of the project projects as of the load time. This loadunit is intended to be loaded incrementally to the destination table for historical views
project_sections: represents all sections associated with a project projects. This information is derived from the project sections array
sections: represents the sections. This slice will extract all section data upon execution.
stories: represents the stories. This slice will extract all story data upon execution.
task_stories: represents the task stories associated with tasks.
tasks: represents the core object of Asana, tasks. This slice will extract all task data upon execution. Incremental data fetch is recommended for large workspaces (look at the asanapremium).
task_custom_fields: represents the custom fields associated with tasks
task_memberships: represents the sections and projects that a task belongs to
workspace_tasksare intermediate loadunits used to extract related data from Asana. These are designed to be synced only to S3.
Output of this slice is stored in S3 and Redshift.
Data stored in AWS S3 is partitioned by date and time
AWS Redshift: Schema - schema name will be same as a slice-name Tables produced by the slice are: