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

177 search results

dbt_utils.bigquery__except macro

dbt_utils.default__except macro

dbt_utils.except macro

salesforce.user_role source

...Represents a user role in your organization....

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: _fivetran_deleted, _fivetran_deleted Show 10 more

salesforce.user source

...Represents a user in your organization....

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: _fivetran_deleted, _fivetran_deleted Show 62 more

salesforce.opportunity source

...Represents an opportunity, which is a sale or pending deal....

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id Show 33 more

salesforce.account source

...Represents an individual account, which is an organization or person involv...

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: account_number, account_number Show 46 more

stg_salesforce__user_role_tmp model

...select * from {{ var('user_role') }}...

stg_salesforce__account_tmp model

...select * from {{ var('account') }}...

stg_salesforce__opportunity_tmp model

...select * from {{ var('opportunity') }}...

stg_salesforce__user_tmp model

...select * from {{ var('user') }}...

stg_salesforce__user model

...Represents a user in your organization....

columns: user_id, user_id columns: _fivetran_synced, _fivetran_synced columns: _fivetran_deleted, _fivetran_deleted Show 62 more
...with source as ( select * from {{ ref('stg_salesforce__user_tmp') }} ), mac...

stg_salesforce__account model

...Represents an individual account, which is an organization or person involv...

columns: account_id, account_id columns: _fivetran_synced, _fivetran_synced columns: account_number, account_number Show 46 more
...with source as ( select * from {{ ref('stg_salesforce__account_tmp') }} ), ...

stg_salesforce__user_role model

...Represents a user role in your organization....

columns: user_role_id, user_role_id columns: _fivetran_synced, _fivetran_synced columns: _fivetran_deleted, _fivetran_deleted Show 10 more
...with source as ( select * from {{ ref('stg_salesforce__user_role_tmp') }} )...

stg_salesforce__opportunity model

...Represents an opportunity, which is a sale or pending deal....

columns: opportunity_id, opportunity_id columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id Show 39 more
...with source as ( select * from {{ ref('stg_salesforce__opportunity_tmp') }}...

salesforce__opportunity_aggregation_by_owner model

...with salesforce_opportunity_enhanced as ( select * from {{ ref('salesforce_...

salesforce__manager_performance model

...Each record represents a manager, enriched with data about their team's pip...

columns: manager_id, manager_id columns: bookings_amount_closed_this_month, bookings_amount_closed_this_month columns: bookings_amount_closed_this_quarter, bookings_amount_closed_this_quarter Show 29 more
...with opportunity_aggregation_by_owner as ( select * from {{ ref('salesforce...

salesforce__sales_snapshot model

...This snapshot provides monthly and quarterly metrics that help you understa...

columns: avg_bookings_amount, avg_bookings_amount columns: avg_days_open, avg_days_open columns: avg_days_to_close, avg_days_to_close Show 27 more
...with salesforce_opportunity_enhanced as ( select * from {{ ref('salesforce_...

salesforce__owner_performance model

...Each record represents an individual member of the sales team, enriched wit...

columns: owner_id, owner_id columns: avg_bookings_amount, avg_bookings_amount columns: avg_days_open, avg_days_open Show 38 more
...with opportunity_aggregation_by_owner as ( select * from {{ ref('salesforce...

salesforce__opportunity_enhanced model

...This table both cleans and enhances your opportunities source table with in...

columns: opportunity_id, opportunity_id columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id Show 57 more
...with opportunity as ( select * from {{ var('opportunity') }} ), salesforce_...
Show 157 more