label: "Analytics Models - Store Level"
connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_agg_daily_youtube_model.view.lkml"
include: "facts_prod_dim_transactiontype.view.lkml"
include: "int_prod_transaction_type_group.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"

week_start_day: friday

fiscal_month_offset: -9

explore: int_dbt_prod_agg_daily_youtube_model {
  label: "YouTube Streaming Model"
  case_sensitive: no
  hidden: no

  join: facts_prod_dim_transactiontype {
    view_label: "Transaction Type"
    sql_on: ${int_dbt_prod_agg_daily_youtube_model.transaction_type_id} = ${facts_prod_dim_transactiontype.transaction_type_id} ;;
    relationship: many_to_one
  }

  join: int_prod_transaction_type_group {
    view_label: "Transaction Type"
    relationship: one_to_one
    sql_on: ${facts_prod_dim_transactiontype.transaction_type_id} = ${int_prod_transaction_type_group.transactiontypeid} ;;
  }

  join: orch_app_ar_artist_info {
    view_label: "Artist"
    relationship: one_to_one
    sql_on: ${orch_app_ar_artist_info.vendor_id} = ${int_dbt_prod_agg_daily_youtube_model.label_id} ;;
    fields: [orch_app_ar_artist_info.artist_id]
  }
}