Welcome!
Welcome to the auto-generated documentation for your dbt project!
Navigation
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
- What is dbt?
- Read the dbt viewpoint
- Installation
- Join the dbt Community for questions and discussion
274 search results
stg_apple_store__app_store_installation_and_deletion_daily model
Contains standard daily metrics on app installations and deletions, providing insights into user acquisition and retention.
columns:
source_relation,
source_relation
columns:
_fivetran_id,
_fivetran_id
columns:
date_day,
date_day
Show 12 more
with base as (
select *
from {{ ref('stg_apple_store__app_store_installation_and_deletion_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_store_installation_and_deletion_tmp')),
staging_columns=get_app_store_installation_and_deletion_daily_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(_fivetran_id as {{ dbt.type_string() }}) as _fivetran_id,
cast(date as date) as date_day,
cast(app_id as {{ dbt.type_bigint() }}) as app_id,
cast(event as {{ dbt.type_string() }}) as event,
cast(download_type as {{ dbt.type_string() }}) as download_type,
cast(app_version as {{ dbt.type_string() }}) as app_version,
cast(device as {{ dbt.type_string() }}) as device,
cast(platform_version as {{ dbt.type_string() }}) as platform_version,
cast(source_type as {{ dbt.type_string() }}) as source_type,
cast(page_type as {{ dbt.type_string() }}) as page_type,
cast(app_download_date as date) as app_download_date,
cast(territory as {{ dbt.type_string() }}) as territory,
cast(counts as {{ dbt.type_bigint() }}) as counts,
cast(unique_devices as {{ dbt.type_bigint() }}) as unique_devices
from fields
)
select *
from final
stg_apple_store__app_store_download_tmp model
{{
fivetran_utils.union_data(
table_identifier='app_store_download_standard_daily',
database_variable='apple_store_database',
schema_variable='apple_store_schema',
default_database=target.database,
default_schema='apple_store',
default_variable='app_store_download_standard_daily',
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases'
)
}}
stg_apple_store__app_store_download_daily model
Contains standard daily metrics on app downloads, including download types and sources.
columns:
source_relation,
source_relation
columns:
_fivetran_id,
_fivetran_id
columns:
date_day,
date_day
Show 10 more
with base as (
select *
from {{ ref('stg_apple_store__app_store_download_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_store_download_tmp')),
staging_columns=get_app_store_download_daily_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(_fivetran_id as {{ dbt.type_string() }}) as _fivetran_id,
cast(date as date) as date_day,
cast(app_id as {{ dbt.type_bigint() }}) as app_id,
cast(download_type as {{ dbt.type_string() }}) as download_type,
cast(app_version as {{ dbt.type_string() }}) as app_version,
cast(device as {{ dbt.type_string() }}) as device,
cast(platform_version as {{ dbt.type_string() }}) as platform_version,
cast(source_type as {{ dbt.type_string() }}) as source_type,
cast(page_type as {{ dbt.type_string() }}) as page_type,
cast(pre_order as {{ dbt.type_string() }}) as pre_order,
cast(territory as {{ dbt.type_string() }}) as territory,
cast(counts as {{ dbt.type_bigint() }}) as counts
from fields
)
select *
from final
stg_apple_store__app_store_discovery_and_engagement_tmp model
{{
fivetran_utils.union_data(
table_identifier='app_store_discovery_and_engagement_standard_daily',
database_variable='apple_store_database',
schema_variable='apple_store_schema',
default_database=target.database,
default_schema='apple_store',
default_variable='app_store_discovery_and_engagement_standard_daily',
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases'
)
}}
stg_apple_store__app_store_discovery_and_engagement_daily model
Contains daily metrics on how users discover and engage with your app on the App Store.
columns:
source_relation,
source_relation
columns:
_fivetran_id,
_fivetran_id
columns:
date_day,
date_day
Show 10 more
with base as (
select *
from {{ ref('stg_apple_store__app_store_discovery_and_engagement_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_store_discovery_and_engagement_tmp')),
staging_columns=get_app_store_discovery_and_engagement_daily_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(_fivetran_id as {{ dbt.type_string() }}) as _fivetran_id,
cast(date as date) as date_day,
cast(app_id as {{ dbt.type_bigint() }}) as app_id,
cast(event as {{ dbt.type_string() }}) as event,
cast(page_type as {{ dbt.type_string() }}) as page_type,
cast(source_type as {{ dbt.type_string() }}) as source_type,
cast(engagement_type as {{ dbt.type_string() }}) as engagement_type,
cast(device as {{ dbt.type_string() }}) as device,
cast(platform_version as {{ dbt.type_string() }}) as platform_version,
cast(territory as {{ dbt.type_string() }}) as territory,
cast(counts as {{ dbt.type_bigint() }}) as counts,
cast(unique_counts as {{ dbt.type_bigint() }}) as unique_counts
from fields
)
select *
from final
stg_apple_store__app_store_app_tmp model
{{
fivetran_utils.union_data(
table_identifier='app_store_app',
database_variable='apple_store_database',
schema_variable='apple_store_schema',
default_database=target.database,
default_schema='apple_store',
default_variable='app_store_app',
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases'
)
}}
stg_apple_store__app_store_app model
Table containing data about your application(s)
columns:
source_relation,
source_relation
columns:
app_id,
app_id
columns:
app_name,
app_name
Show 0 more
with base as (
select *
from {{ ref('stg_apple_store__app_store_app_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_store_app_tmp')),
staging_columns=get_app_store_app_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(id as {{ dbt.type_bigint() }}) as app_id,
cast(name as {{ dbt.type_string() }}) as app_name
from fields
)
select *
from final
stg_apple_store__app_session_tmp model
{{
fivetran_utils.union_data(
table_identifier='app_session_standard_daily',
database_variable='apple_store_database',
schema_variable='apple_store_schema',
default_database=target.database,
default_schema='apple_store',
default_variable='app_session_standard_daily',
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases'
)
}}
stg_apple_store__app_session_daily model
Provides standard daily metrics on user sessions within your app, including session duration and device information.
columns:
source_relation,
source_relation
columns:
_fivetran_id,
_fivetran_id
columns:
date_day,
date_day
Show 11 more
with base as (
select *
from {{ ref('stg_apple_store__app_session_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_session_tmp')),
staging_columns=get_app_session_daily_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(_fivetran_id as {{ dbt.type_string() }}) as _fivetran_id,
cast(date as date) as date_day,
cast(app_id as {{ dbt.type_bigint() }}) as app_id,
cast(app_version as {{ dbt.type_string() }}) as app_version,
cast(device as {{ dbt.type_string() }}) as device,
cast(platform_version as {{ dbt.type_string() }}) as platform_version,
cast(source_type as {{ dbt.type_string() }}) as source_type,
cast(page_type as {{ dbt.type_string() }}) as page_type,
cast(app_download_date as date) as app_download_date,
cast(territory as {{ dbt.type_string() }}) as territory,
cast(sessions as {{ dbt.type_bigint() }}) as sessions,
cast(total_session_duration as {{ dbt.type_bigint() }}) as total_session_duration,
cast(unique_devices as {{ dbt.type_bigint() }}) as unique_devices
from fields
)
select *
from final
stg_apple_store__app_crash_tmp model
{{
fivetran_utils.union_data(
table_identifier='app_crash_daily',
database_variable='apple_store_database',
schema_variable='apple_store_schema',
default_database=target.database,
default_schema='apple_store',
default_variable='app_crash_daily',
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases'
)
}}
stg_apple_store__app_crash_daily model
Provides daily data on app crashes, helping you understand app stability across different versions and devices.
columns:
source_relation,
source_relation
columns:
_fivetran_id,
_fivetran_id
columns:
date_day,
date_day
Show 7 more
with base as (
select *
from {{ ref('stg_apple_store__app_crash_tmp') }}
),
fields as (
select
{{
fivetran_utils.fill_staging_columns(
source_columns=adapter.get_columns_in_relation(ref('stg_apple_store__app_crash_tmp')),
staging_columns=get_app_crash_daily_columns()
)
}}
{{ fivetran_utils.source_relation(
union_schema_variable='apple_store_union_schemas',
union_database_variable='apple_store_union_databases')
}}
from base
),
final as (
select
cast(source_relation as {{ dbt.type_string() }}) as source_relation,
cast(_fivetran_id as {{ dbt.type_string() }}) as _fivetran_id,
cast(date as date) as date_day,
cast(app_id as {{ dbt.type_bigint() }}) as app_id,
cast(app_version as {{ dbt.type_string() }}) as app_version,
cast(device as {{ dbt.type_string() }}) as device,
cast('' as {{ dbt.type_string() }}) as source_type, -- adding source_type in order to join with other models downstream
cast(platform_version as {{ dbt.type_string() }}) as platform_version,
cast(crashes as {{ dbt.type_bigint() }}) as crashes,
cast(unique_devices as {{ dbt.type_bigint() }}) as unique_devices
from fields
)
select *
from final
apple_store_country_codes seed
ISO-3166 country mapping table
columns:
country_name,
country_name
columns:
alternative_country_name,
alternative_country_name
columns:
country_code_numeric,
country_code_numeric
Show 6 more
sales_subscription_summary seed
columns:
_fivetran_id,
_fivetran_id
columns:
vendor_number,
vendor_number
columns:
app_name,
app_name
Show 33 more
sales_subscription_event_summary seed
columns:
_fivetran_id,
_fivetran_id
columns:
vendor_number,
vendor_number
columns:
event_date,
event_date
Show 29 more