label: "Custom Data Sets"
connection: "snowflake_via_lookerappadmin"

include: "int_dbt_prod_accounting_last_12_months_activity_date.view.lkml"
include: "int_prod_territory_grouping.view.lkml"
include: "int_dbt_prod_accounting_last_24_months_activity_date_track_level.view.lkml"
include: "int_dbt_prod_spatial_audio_delivery_history_search.view.lkml"
include: "int_dbt_prod_per_play_rate.view.lkml"
include: "int_dbt_prod_digital_bulk_template.view.lkml"
include: "tsz_custom.view.lkml"
include: "int_dbt_prod_completion_rate_track_level_monthly.view.lkml"
include: "int_dbt_prod_artist_by_territory_accounting.view.lkml"
include: "int_dbt_prod_track_level_accounting.view.lkml"
include: "facts_prod_dim_release.view.lkml"
include: "facts_prod_dim_artist.view.lkml"
include: "int_dbt_prod_full_track_metadata_report_delivery_history.view.lkml"
include: "orch_app_ar_track.view.lkml"
include: "int_dbt_prod_changes_by_country.view.lkml"
include: "int_dbt_prod_tracks_generating_1000_streams.view.lkml"
include: "int_dbt_prod_global_chart_tracking.view.lkml"
include: "int_dbt_prod_anuel_aa_toptracks_monthly.view.lkml"
include: "int_dbt_prod_top_artists_monthly.view.lkml"
include: "int_dbt_prod_top_tracks_monthly.view.lkml"
include: "int_dbt_prod_first_access_analytics_reporting.view.lkml"
include: "int_dbt_prod_youtube_spike_report.view.lkml"
include: "int_dbt_prod_changes_by_source.view.lkml"
include: "/views/top_content_daily_editorial_streams.view.lkml"
include: "orch_app_ar_releases.view.lkml"

fiscal_month_offset: -9

explore: int_dbt_prod_accounting_last_12_months_activity_date {
  hidden: yes
  case_sensitive: no

  join: int_prod_territory_grouping {
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_accounting_last_12_months_activity_date.country_name}=${int_prod_territory_grouping.country_name} ;;
    relationship: many_to_one
    fields: [int_prod_territory_grouping.territory_group]
  }
}

explore: top_content_daily_editorial_streams {
  group_label: "Custom Models"
  hidden: no
  }


explore: int_dbt_prod_accounting_last_24_months_activity_date_track_level {
  hidden: yes
  case_sensitive: no

  join: top_content_daily_editorial_streams {
    view_label: "Spotify Editorial Streams"
    sql_on:
            ${int_dbt_prod_accounting_last_24_months_activity_date_track_level.upc} = ${top_content_daily_editorial_streams.upc} and
            ${int_dbt_prod_accounting_last_24_months_activity_date_track_level.label_id} = ${top_content_daily_editorial_streams.label_id} and
            ${int_dbt_prod_accounting_last_24_months_activity_date_track_level.country_name} = ${top_content_daily_editorial_streams.country_name} and
            ${int_dbt_prod_accounting_last_24_months_activity_date_track_level.isrc} = ${top_content_daily_editorial_streams.isrc};;
    fields: [top_content_daily_editorial_streams.spotify_streams,top_content_daily_editorial_streams.spotify_editorial_playlist_streams]
    relationship: many_to_one
  }
  join: orch_app_ar_releases {
  relationship: many_to_one
  view_label: "Release"
  sql_on: ${int_dbt_prod_accounting_last_24_months_activity_date_track_level.upc} = ${orch_app_ar_releases.upc};;
  fields: [is_active]
  }
}


explore: int_dbt_prod_spatial_audio_delivery_history_search {
  hidden: yes
  case_sensitive: no
}


explore: int_dbt_prod_per_play_rate {
  hidden: yes
  case_sensitive: no
}


explore: int_dbt_prod_digital_bulk_template {
  hidden: yes
  case_sensitive: no
}

explore: tsz_custom {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_completion_rate_track_level_monthly {
  hidden: yes
  case_sensitive: no
}


explore: int_dbt_prod_artist_by_territory_accounting {
  hidden: yes
  case_sensitive: no

  join: int_prod_territory_grouping {
    view_label: "Transaction Country"
    sql_on: ${int_dbt_prod_artist_by_territory_accounting.country_name}=${int_prod_territory_grouping.country_name} ;;
    relationship: many_to_one
    fields: [int_prod_territory_grouping.territory_group]
  }
}

explore: int_dbt_prod_track_level_accounting {
  hidden: yes
  case_sensitive: no

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

  join: facts_prod_dim_artist {
    view_label: "Artist"
    sql_on: ${facts_prod_dim_artist.artist_id} = ${facts_prod_dim_release.artist_id} ;;
    relationship: many_to_one
    fields: [facts_prod_dim_artist.artist_name]
  }

}


explore: int_dbt_prod_full_track_metadata_report_delivery_history {
  hidden: yes
  case_sensitive: no
}


explore: int_dbt_prod_changes_by_country {
  hidden: yes
  case_sensitive: no
  }


explore: int_dbt_prod_tracks_generating_1000_streams {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_global_chart_tracking {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_anuel_aa_toptracks_monthly {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_top_artists_monthly {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_top_tracks_monthly {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_first_access_analytics_reporting {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_youtube_spike_report {
  hidden: yes
  case_sensitive: no
}

explore: int_dbt_prod_changes_by_source {
  hidden: yes
  case_sensitive: no
}