label: "Publishing"
connection: "looker_high_performance" #create a connection to service publishing reporting exclusively.

include: "publishing_app_change_log.view.lkml"
include: "publishing_metadata.view.lkml"
include: "unified_publishing_master_royalties.view.lkml"
include: "publishing_nav.view.lkml"
include: "int_dbt_prod_publishing_metadata_standard.view.lkml"


fiscal_month_offset: -9

explore: publishing_metadata {
  label: "Publishing Metadata"
  view_label: "Publishing Metadata"
  case_sensitive: no
  hidden: yes

  access_filter: {
    field: publishing_metadata.label_id
    user_attribute: label_id
  }

  join: publishing_app_change_log {
    relationship: many_to_many #this needs a double check
    sql_on: ${publishing_app_change_log.PubSongID} = ${publishing_metadata.pub_song_id} and ${publishing_app_change_log.changed_on} > ${publishing_metadata.delivery_date_date} ;;
  }
}

explore: publishing_nav {
  hidden: yes
}

explore: unified_publishing_master_royalties {
  label: "Unified Publishing Master Royalties"
  view_label: "Unified Publishing Master Royalties"
  case_sensitive: no
  hidden: no

  access_filter: {
    field: unified_publishing_master_royalties.label_id
    user_attribute: label_id
  }

}

explore:  int_dbt_prod_publishing_metadata_standard {
  label: "Publishing Metadata Standard"
  view_label: "Publishing Metadata"
  case_sensitive: no
  hidden: no

  access_filter: {
    field: int_dbt_prod_publishing_metadata_standard.label_id
    user_attribute: label_id
  }
}