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

211 search results

stg_marketo__activity_email_bounced model

columns: activity_timestamp, activity_timestamp columns: activity_type_id, activity_type_id columns: campaign_id, campaign_id Show 13 more
...with base as ( select * from {{ var('activity_email_bounced') }} ), fields ...

stg_marketo__activity_email_delivered model

columns: activity_timestamp, activity_timestamp columns: activity_type_id, activity_type_id columns: campaign_id, campaign_id Show 9 more
...with base as ( select * from {{ var('activity_email_delivered') }} ), field...

stg_marketo__activity_click_email model

columns: activity_timestamp, activity_timestamp columns: activity_type_id, activity_type_id columns: campaign_id, campaign_id Show 14 more
...with base as ( select * from {{ var('activity_click_email') }} ), fields as...

marketo__programs model

...Each record is a Marketo program....

columns: program_id, program_id columns: channel, channel columns: created_timestamp, created_timestamp Show 19 more
...with programs as ( select * from {{ var('program') }} ), email_stats as ( s...

marketo__change_data_scd model

columns: valid_to, valid_to columns: lead_id, lead_id columns: lead_status, lead_status Show 7 more
...{{ config( materialized='incremental', partition_by = {'field': 'valid_to',...

marketo__calendar_spine model

columns: date_day, date_day Show -2 more
...with spine as ( {{ dbt_utils.date_spine( "day", "'2016-01-01'", dbt_utils.d...

stg_marketo__email_template_history model

columns: created_timestamp, created_timestamp columns: description, description columns: folder_name, folder_name Show 26 more
...with base as ( select * from {{ var('email_template_history') }} ), fields ...

stg_marketo__activity_delete_lead model

...Table with deleted lead activities...

columns: activity_id, activity_id columns: _fivetran_synced, _fivetran_synced columns: activity_timestamp, activity_timestamp Show 6 more
...with base as ( select * from {{ var('activity_delete_lead') }} ), fields as...

marketo__lead_calendar_spine model

columns: date_day, date_day columns: lead_id, lead_id columns: lead_day_id, lead_day_id Show 0 more
...{{ config( materialized='incremental', partition_by = {'field': 'date_day',...

marketo__change_data_details model

columns: lead_id, lead_id columns: date_day, date_day columns: urgency, urgency Show 7 more
...{{ config( materialized='incremental', partition_by = {'field': 'date_day',...

stg_marketo__lead model

columns: lead_id, lead_id columns: created_timestamp, created_timestamp columns: updated_timestamp, updated_timestamp Show 700 more
...with leads as ( select * from {{ ref('stg_marketo__lead_base') }} ), delete...

stg_marketo__activity_send_email model

columns: activity_timestamp, activity_timestamp columns: activity_type_id, activity_type_id columns: campaign_id, campaign_id Show 9 more
...with base as ( select * from {{ var('activity_send_email') }} ), fields as ...

marketo__lead_history model

...Each record is what a Marketo lead looked like on each day....

columns: date_day, date_day columns: lead_id, lead_id columns: lead_status, lead_status Show 7 more
...{{ config( materialized='incremental', partition_by = {'field': 'date_day',...

stg_marketo__activity_open_email model

columns: activity_timestamp, activity_timestamp columns: activity_type_id, activity_type_id columns: campaign_id, campaign_id Show 13 more
...with base as ( select * from {{ var('activity_open_email') }} ), fields as ...

stg_marketo__lead_describe model

columns: data_type, data_type columns: display_name, display_name columns: lead_describe_id, lead_describe_id Show 6 more
...with base as ( select * from {{ var('lead_describe') }} ), fields as ( sele...

marketo__lead_adapter model

columns: lead_id, lead_id columns: created_timestamp, created_timestamp columns: updated_timestamp, updated_timestamp Show 698 more
...{{ config(materialized='view')}} select * from {{ var('lead') }}...

marketo__campaigns model

...Each record is Marketo campaign....

columns: is_active, is_active columns: created_timestamp, created_timestamp columns: description, description Show 15 more
...with campaigns as ( select * from {{ var('campaigns') }} ), email_stats as ...

stg_marketo__program model

columns: program_id, program_id columns: channel, channel columns: created_timestamp, created_timestamp Show 11 more
...with base as ( select * from {{ var('program') }} ), fields as ( select id ...

marketo__change_data_pivot model

columns: lead_id, lead_id columns: date_day, date_day columns: urgency, urgency Show 7 more
...{{ config( materialized='incremental', partition_by = {'field': 'date_day',...

marketo__email_templates model

...Each record is the most recent version of an email template....

columns: created_timestamp, created_timestamp columns: description, description columns: folder_name, folder_name Show 34 more
...with email_templates as ( select * from {{ var('email_tempate_history') }} ...
Show 191 more