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 --select 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

295 search results

stg_pendo__event_tmp model

columns: account_id, account_id columns: remote_ip, remote_ip columns: server_name, server_name Show 8 more
select * from {{ var('event') }}

stg_pendo__poll_event model

Table capturing individual responses to polls.

columns: account_id, account_id columns: app_id, app_id columns: country, country Show 17 more
with base as ( select * from {{ ref('stg_pendo__poll_event_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_pendo__poll_event_tmp')), staging_columns=get_poll_event_columns() ) }} from base ), final as ( select account_id, app_id, country, guide_id, guide_step_id, latitude, longitude, poll_id, poll_response, region, remote_ip, server_name, timestamp as occurred_at, type, url, user_agent, visitor_id, _fivetran_synced, _fivetran_id, {{ dbt_utils.generate_surrogate_key(['visitor_id', 'timestamp', 'account_id', 'server_name', 'poll_id', 'guide_id', 'user_agent', 'remote_ip', '_fivetran_id']) }} as poll_event_key from fields ) select * from final

stg_pendo__guide_event model

Table capturing events related to guides. Each row is a unique event around `guideAdvanced`, `guideSeen`, `guideDismissed`, `guideSnoozed`, `guideTimeout`, `guideActivity`.

columns: account_id, account_id columns: app_id, app_id columns: country, country Show 15 more
with base as ( select * from {{ ref('stg_pendo__guide_event_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_pendo__guide_event_tmp')), staging_columns=get_guide_event_columns() ) }} from base ), final as ( select account_id, app_id, country, guide_id, guide_step_id, latitude, longitude, region, remote_ip, server_name, timestamp as occurred_at, type, url, user_agent, visitor_id, _fivetran_synced, _fivetran_id, {{ dbt_utils.generate_surrogate_key(['visitor_id', 'timestamp', 'account_id', 'server_name', 'guide_id', 'user_agent', 'remote_ip', '_fivetran_id']) }} as guide_event_key from fields ) select * from final

feature_event seed

columns: account_id, account_id columns: feature_id, feature_id columns: remote_ip, remote_ip Show 9 more

event seed

columns: account_id, account_id columns: remote_ip, remote_ip columns: server_name, server_name Show 8 more

guide_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 32 more

feature_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 13 more

account_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 18 more

visitor_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 23 more

group_data seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: app_id, app_id Show 8 more

visitor_account_history seed

columns: account_id, account_id columns: visitor_id, visitor_id columns: visitor_last_updated_at, visitor_last_updated_at Show 1 more

page_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 11 more

application_history seed

columns: id, id columns: last_updated_at, last_updated_at columns: _fivetran_synced, _fivetran_synced Show 34 more

guide_event seed

columns: account_id, account_id columns: guide_id, guide_id columns: remote_ip, remote_ip Show 16 more

poll_event seed

columns: account_id, account_id columns: guide_id, guide_id columns: poll_id, poll_id Show 18 more

guide_step_history seed

columns: guide_id, guide_id columns: guide_last_updated_at, guide_last_updated_at columns: step_id, step_id Show 1 more

page_event seed

columns: account_id, account_id columns: page_id, page_id columns: remote_ip, remote_ip Show 9 more

page_rule_history seed

columns: page_id, page_id columns: page_last_updated_at, page_last_updated_at columns: rule, rule Show 3 more

user seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: deleted_at, deleted_at Show 5 more

poll seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: attribute_display, attribute_display Show 6 more
Show 275 more