icons
Lineage Graph

Welcome!

Welcome to the auto-generated documentation for your dbt project!

You can use the Project and Database navigation tabs on the left side of the window to explore the models in your project.

Project Tab

The Project tab mirrors the directory structure of your dbt project. In this tab, you can see all of the models defined in your dbt project, as well as models imported from dbt packages.

Database Tab

The Database tab also exposes your models, but in a format that looks more like a database explorer. This view shows relations (tables and views) grouped into database schemas. Note that ephemeral models are not shown in this interface, as they do not exist in the database.

Graph Exploration

You can click the blue icon on the bottom-right corner of the page to view the lineage graph of your models.

On model pages, you'll see the immediate parents and children of the model you're exploring. By clicking the Expand button at the top-right of this lineage pane, you'll be able to see all of the models that are used to build, or are built from, the model you're exploring.

Once expanded, you'll be able to use the --models and --exclude model selection syntax to filter the models in the graph. For more information on model selection, check out the dbt docs.

Note that you can also right-click on models to interactively filter and explore the graph.


More information

183 search results

asana.project source

...Table containing all projects...

columns: ID, ID columns: NAME, NAME columns: NOTES, NOTES Show 12 more

asana.project_task source

...Table of tasks and the project(s) they each belong to. If a project doesn't...

columns: TASK_ID, TASK_ID columns: PROJECT_ID, PROJECT_ID columns: _FIVETRAN_SYNCED, _FIVETRAN_SYNCED Show 0 more

asana.section source

...Table of all sections within projects. If tasks in a project are not in an ...

columns: ID, ID columns: NAME, NAME columns: PROJECT_ID, PROJECT_ID Show 2 more

stg_asana_project model

...Table containing all projects...

columns: PROJECT_ID, PROJECT_ID columns: IS_ARCHIVED, IS_ARCHIVED columns: CREATED_AT, CREATED_AT Show 9 more
...with project as ( select * from {{ var('project') }} ), fields as ( select ...

stg_asana_project_task model

...Table of tasks and the project(s) they each belong to. If a project doesn't...

columns: PROJECT_ID, PROJECT_ID columns: TASK_ID, TASK_ID Show -1 more
...with project_task as ( select * from {{ var('project_task') }} ), fields as...

stg_asana_story model

...Table containing all stories -- stories are actions taken on tasks...

columns: STORY_ID, STORY_ID columns: CREATED_AT, CREATED_AT columns: CREATED_BY_USER_ID, CREATED_BY_USER_ID Show 3 more
...with story as ( select * from {{ var('story') }} ), fields as ( select id a...

stg_asana_tag model

...Table of the custom tags made in the organization...

columns: TAG_ID, TAG_ID columns: TAG_NAME, TAG_NAME columns: CREATED_AT, CREATED_AT Show 0 more
...with asana_tag as ( select * from {{ var('tag') }} ), fields as ( select id...

stg_asana_task_follower model

...Table of tasks with the users that are following them. Tasks without users ...

columns: TASK_ID, TASK_ID columns: USER_ID, USER_ID Show -1 more
...with task_follower as ( select * from {{ var('task_follower') }} ), fields ...

stg_asana_task_section model

...Table of tasks and the section that they live under. Section-less tasks wit...

columns: SECTION_ID, SECTION_ID columns: TASK_ID, TASK_ID Show -1 more
...with task_section as ( select * from {{ var('task_section') }} ), fields as...

stg_asana_task_tag model

...Table of tasks with the tags attached to them. Tasks without tags (and vice...

columns: TAG_ID, TAG_ID columns: TASK_ID, TASK_ID Show -1 more
...with task_tag as ( select * from {{ var('task_tag') }} ), fields as ( selec...

stg_asana_task model

...Table containing all created tasks...

columns: TASK_ID, TASK_ID columns: ASSIGNEE_USER_ID, ASSIGNEE_USER_ID columns: ASSIGNEE_STATUS, ASSIGNEE_STATUS Show 11 more
...with task as ( select * from {{ var('task') }} ), fields as ( select id as ...

asana_daily_metrics model

...Table of task metrics per each day...

columns: DATE_DAY, DATE_DAY columns: NUMBER_OF_TASKS_OPEN, NUMBER_OF_TASKS_OPEN columns: NUMBER_OF_TASKS_OPEN_ASSIGNED, NUMBER_OF_TASKS_OPEN_ASSIGNED Show 4 more
...with task as ( select * from {{ ref('asana_task') }} ), spine as ( {% if ex...

asana_project model

...Table of projects' basic info enriched with metrics regarding tasks and com...

columns: PROJECT_ID, PROJECT_ID columns: PROJECT_NAME, PROJECT_NAME columns: NUMBER_OF_OPEN_TASKS, NUMBER_OF_OPEN_TASKS Show 18 more
...with project_task_metrics as ( select * from {{ ref('asana_project_task_met...

asana_task model

...An enriched task table consisting of base task info + aggregated metrics an...

columns: TASK_ID, TASK_ID columns: ASSIGNEE_USER_ID, ASSIGNEE_USER_ID columns: ASSIGNEE_STATUS, ASSIGNEE_STATUS Show 36 more
...with task as ( select * from {{ var('task') }} ), task_comments as ( select...

asana_user model

...Enriched user table consisting of base user info + metrics around tasks and...

columns: USER_ID, USER_ID columns: EMAIL, EMAIL columns: USER_NAME, USER_NAME Show 6 more
...with user_task_metrics as ( select * from {{ ref('asana_user_task_metrics')...

asana_team model

...Enriched team table consisting of basic team info + task/completion metrics...

columns: TEAM_ID, TEAM_ID columns: TEAM_NAME, TEAM_NAME columns: NUMBER_OF_OPEN_TASKS, NUMBER_OF_OPEN_TASKS Show 7 more
...with team as ( select * from {{ var('team') }} ), project as ( select * fro...

asana_tag model

...Table of tag basic info enriched with some task metrics....

columns: TAG_ID, TAG_ID columns: TAG_NAME, TAG_NAME columns: CREATED_AT, CREATED_AT Show 5 more
...with asana_tag as ( select * from {{ var('tag') }} ), task_tag as ( select ...

stg_asana_user model

...Table of all accounts in the organization...

columns: USER_ID, USER_ID columns: EMAIL, EMAIL columns: USER_NAME, USER_NAME Show 0 more
...with asana_user as ( select * from {{ var('user') }} ), fields as ( select ...

stg_asana_section model

...Table of all sections within projects. If tasks in a project are not in an ...

columns: SECTION_ID, SECTION_ID columns: CREATED_AT, CREATED_AT columns: SECTION_NAME, SECTION_NAME Show 1 more
...with section as ( select * from {{ var('section') }} ), fields as ( select ...

stg_asana_team model

...Table of the teams within the organization...

columns: TEAM_ID, TEAM_ID columns: TEAM_NAME, TEAM_NAME Show -1 more
...with team as ( select * from {{ var('team') }} ), fields as ( select id as ...
Show 163 more