connection: "snowflake_via_lookerappadmin"
label: "Fraudulent Streaming"

include: "int_dbt_prod_tiktok_fraud_model.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_track.view.lkml"
include: "orch_app_ar_genre.view.lkml"
include: "orch_app_ar_orchadmin_users.view"
include: "int_dbt_prod_product_manager_mapping_union.view"
include: "int_dbt_prod_awal_tier_groups.view.lkml"

explore: int_dbt_prod_tiktok_fraud_model {
    label: "TikTok Fraudulent Content"
    case_sensitive: no
    hidden: yes
    sql_always_where: ${int_dbt_prod_tiktok_fraud_model.labelid} != 32551 ;;


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

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${facts_prod_dim_label.label_id} ;;
    fields:  []
  }

  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: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_dbt_prod_tiktok_fraud_model.upc} ;;
    relationship: one_to_many
    fields: [
      format,
      is_active,
      imprint_name,
      project_id,
      release_name,
      release_date,release_week,release_month,release_year,
      sale_start_date,sale_start_week,sale_start_month,sale_start_year,
      preorder_date,preorder_week,preorder_month,preorder_year,
      vendor_catalog_number,
      version,
      number_of_releases
    ]
  }

  join: orch_app_ar_track {
    view_label: "Track"
    sql_on: ${orch_app_ar_track.upc}=${int_dbt_prod_tiktok_fraud_model.upc} and ${orch_app_ar_track.isrc}=${int_dbt_prod_tiktok_fraud_model.isrc} ;;
    relationship: one_to_many
    fields: [
      tuid, orch_app_ar_track.track_version, track_type
    ]
  }

  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: "Transaction Country"
    sql_on: ${int_dbt_prod_tiktok_fraud_model.country_code} = ${facts_prod_dim_country.country_code} ;;
    relationship: many_to_one
    fields: [facts_prod_dim_country.country_name]
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_tiktok_fraud_model.labelid}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }

}