connection: "snowflake_via_lookerappadmin"
label: "Streaming Fraud Indicators Models"

include: "int_dbt_prod_weekly_fraudulent_streams_flags_spotify.view.lkml"
include: "int_dbt_prod_stg_sos_fraud_spike_over_500_pct.view.lkml"
include: "facts_prod_dim_country.view.lkml"
include: "facts_prod_dim_label.view.lkml"
include: "orch_app_ar_country.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_genre.view.lkml"
include: "facts_prod_dim_release.view.lkml"
include: "orch_app_ar_subaccount.view.lkml"


explore: int_dbt_prod_weekly_fraudulent_streams_flags_spotify {
  hidden: yes
  label: "Weekly Fraudulent Streaming Flags - Spotify"

  join: facts_prod_dim_country{
    view_label: "User"
    sql_on: ${int_dbt_prod_weekly_fraudulent_streams_flags_spotify.user_country_code} = ${facts_prod_dim_country.country_code} ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_weekly_fraudulent_streams_flags_spotify.label_id} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name,
      number_of_labels
    ]
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${facts_prod_dim_label.country_id} = ${label_country.id} ;;
    fields: [name]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${int_dbt_prod_weekly_fraudulent_streams_flags_spotify.upc} = ${facts_prod_dim_release.upc} ;;
    relationship: many_to_one
    fields: []
  }

  join: orch_app_ar_subaccount {
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_release.subaccountid} = ${orch_app_ar_subaccount.subaccount_id} ;;
    relationship: many_to_one
    fields: [subaccount_name,count_subaccounts, subaccount_id]
  }
}

explore: int_dbt_prod_stg_sos_fraud_spike_over_500_pct {
  hidden: yes
  label: "Weekly Fraudulent Streaming Flags - Spotify - Spikes with 75% User Playlists Streams"

  join: orch_app_ar_vendor  {
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.labelid} ;;
    relationship: one_to_many
  }


  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.upc} ;;
    relationship: one_to_many
  }

  join: orch_app_ar_genre {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_genre_id}=${orch_app_ar_genre.genre_id} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_country{
    view_label: "User"
    sql_on: ${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.user_country_code} = ${facts_prod_dim_country.country_code} ;;
    fields: [facts_prod_dim_country.country_name]
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.labelid} = ${facts_prod_dim_label.label_id} ;;
    fields: [
      label_name,
      number_of_labels
    ]
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${facts_prod_dim_label.country_id} = ${label_country.id} ;;
    fields: [name]
  }

  join: transaction_country {
    from: orch_app_ar_country
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.user_country_code} = ${transaction_country.country_code} ;;
    relationship: many_to_one
    fields: [country_code, name, continent, us_vs_row, us_vs_uk_vs_row]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${int_dbt_prod_stg_sos_fraud_spike_over_500_pct.upc} = ${facts_prod_dim_release.upc} ;;
    relationship: many_to_one
    fields: []
  }

  join: orch_app_ar_subaccount {
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_release.subaccountid} = ${orch_app_ar_subaccount.subaccount_id} ;;
    relationship: many_to_one
    fields: [subaccount_name,count_subaccounts, subaccount_id]
  }



}