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

289 search results

stg_reddit_ads__ad_conversions_report model

Provides a summary of conversion events at the individual ad level, aggregating key metrics by event and day such as view-through and click-through conversions.

columns: source_relation, source_relation columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id Show 7 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} with base as ( select * from {{ ref('stg_reddit_ads__ad_conversions_report_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__ad_conversions_report_tmp')), staging_columns=get_ad_conversions_report_columns() ) }} {{ fivetran_utils.source_relation( union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases') }} from base ), final as ( select source_relation, _fivetran_synced, account_id, ad_id, date as date_day, lower(event_name) as event_name, coalesce(total_items,0) as total_items, coalesce(total_value,0) as total_value, coalesce(click_through_conversion_attribution_window_month,0) as conversions, coalesce(view_through_conversion_attribution_window_month,0) as view_through_conversions {{ fivetran_utils.fill_pass_through_columns('reddit_ads__ad_conversions_passthrough_metrics') }} from fields ) select * from final

stg_reddit_ads__ad model

Each record represents information about each ad.

columns: source_relation, source_relation columns: account_id, account_id columns: ad_group_id, ad_group_id Show 10 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} with base as ( select * from {{ ref('stg_reddit_ads__ad_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__ad_tmp')), staging_columns=get_ad_columns() ) }} {{ fivetran_utils.source_relation( union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases') }} from base ), final as ( select source_relation, account_id, ad_group_id, campaign_id, click_url, configured_status, effective_status, id as ad_id, is_processing, name as ad_name, post_id, post_url, rejection_reason from fields ) select * from final

stg_reddit_ads__account_tmp model

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: attribution_type, attribution_type Show 6 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} {{ fivetran_utils.union_data( table_identifier='account', database_variable='reddit_ads_database', schema_variable='reddit_ads_schema', default_database=target.database, default_schema='reddit_ads', default_variable='account', union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases' ) }}

stg_reddit_ads__account_report_tmp model

columns: account_id, account_id columns: date, date columns: _fivetran_synced, _fivetran_synced Show 47 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} {{ fivetran_utils.union_data( table_identifier='account_report', database_variable='reddit_ads_database', schema_variable='reddit_ads_schema', default_database=target.database, default_schema='reddit_ads', default_variable='account_report', union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases' ) }}

stg_reddit_ads__account_report model

Each record represents a summary of events for each given date and account.

columns: source_relation, source_relation columns: account_id, account_id columns: clicks, clicks Show 4 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} with base as ( select * from {{ ref('stg_reddit_ads__account_report_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_report_tmp')), staging_columns=get_account_report_columns() ) }} {{ fivetran_utils.source_relation( union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases') }} from base ), final as ( select source_relation, account_id, coalesce(clicks,0) as clicks, date as date_day, coalesce(impressions,0) as impressions, region, coalesce((spend/1000000),0) as spend {{ fivetran_utils.fill_pass_through_columns('reddit_ads__account_passthrough_metrics') }} from fields ) select * from final

stg_reddit_ads__account_conversions_report_tmp model

columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id columns: avg_value, avg_value Show 10 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} {{ fivetran_utils.union_data( table_identifier='account_conversions_report', database_variable='reddit_ads_database', schema_variable='reddit_ads_schema', default_database=target.database, default_schema='reddit_ads', default_variable='account_conversions_report', union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases' ) }}

stg_reddit_ads__account_conversions_report model

Provides a summary of conversion events at the account level, aggregating key metrics by event and day such as view-through and click-through conversions.

columns: source_relation, source_relation columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id Show 6 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} with base as ( select * from {{ ref('stg_reddit_ads__account_conversions_report_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_conversions_report_tmp')), staging_columns=get_account_conversions_report_columns() ) }} {{ fivetran_utils.source_relation( union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases') }} from base ), final as ( select source_relation, _fivetran_synced, account_id, date as date_day, lower(event_name) as event_name, coalesce(total_items,0) as total_items, coalesce(total_value,0) as total_value, coalesce(click_through_conversion_attribution_window_month,0) as conversions, coalesce(view_through_conversion_attribution_window_month,0) as view_through_conversions {{ fivetran_utils.fill_pass_through_columns('reddit_ads__account_conversions_passthrough_metrics') }} from fields ) select * from final

stg_reddit_ads__account model

Each record in this table represents information about an account.

columns: source_relation, source_relation columns: attribution_type, attribution_type columns: click_attribution_window, click_attribution_window Show 6 more
{{ config(enabled=var('ad_reporting__reddit_ads_enabled', True)) }} with base as ( select * from {{ ref('stg_reddit_ads__account_tmp') }} ), fields as ( select {{ fivetran_utils.fill_staging_columns( source_columns=adapter.get_columns_in_relation(ref('stg_reddit_ads__account_tmp')), staging_columns=get_account_columns() ) }} {{ fivetran_utils.source_relation( union_schema_variable='reddit_ads_union_schemas', union_database_variable='reddit_ads_union_databases') }} from base ), final as ( select source_relation, attribution_type, click_attribution_window, cast(created_at as {{ dbt.type_timestamp() }}) as created_at, currency, id as account_id, status, time_zone_id, view_attribution_window from fields ) select * from final

reddit_ads_campaign_report_data seed

columns: account_id, account_id columns: campaign_id, campaign_id columns: date, date Show 48 more

reddit_ads_campaign_data seed

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

reddit_ads_campaign_conversions seed

columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id columns: avg_value, avg_value Show 11 more

reddit_ads_ad_report_data seed

columns: account_id, account_id columns: ad_id, ad_id columns: date, date Show 48 more

reddit_ads_ad_group_report_data seed

columns: account_id, account_id columns: ad_group_id, ad_group_id columns: date, date Show 48 more

reddit_ads_ad_group_data seed

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

reddit_ads_ad_group_conversions seed

columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id columns: ad_group_id, ad_group_id Show 11 more

reddit_ads_ad_data seed

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

reddit_ads_ad_conversions seed

columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id columns: ad_id, ad_id Show 11 more

reddit_ads_account_report_data seed

columns: account_id, account_id columns: date, date columns: _fivetran_synced, _fivetran_synced Show 47 more

reddit_ads_account_data seed

columns: id, id columns: _fivetran_synced, _fivetran_synced columns: attribution_type, attribution_type Show 6 more

reddit_ads_account_conversions seed

columns: _fivetran_synced, _fivetran_synced columns: account_id, account_id columns: avg_value, avg_value Show 10 more
Show 269 more