view: phonofile_bulk_upload_looker_view {
  derived_table: {
    sql:
      SELECT
       *
      FROM Phonofile.dev.Phonofile_Bulk_Upload
      ORDER BY compid asc, relid asc, volume asc, track_no asc
    ;;
  }

  dimension: release_name {
    type: string
    label: "Release Name"
    sql: ${TABLE}.Release_Name;;
  }

  dimension: release_meta_language {
    type: string
    label: "Release Meta Language"
    sql: ${TABLE}.Release_Meta_Language;;
  }

  dimension: orchard_artist {
    type: string
    label: "Orchard Artist"
    sql: ${TABLE}.Orchard_Artist;;
  }

  dimension: artist_country {
    type: string
    label: "Artist Country"
    sql: ${TABLE}.Artist_Country;;
  }

  dimension: subaccount_name {
    type: string
    label: "Subaccount Name"
    sql: ${TABLE}.Subaccount_Name;;
  }

  dimension: artist_url {
    type: string
    label: "Artist URL"
    sql: ${TABLE}.Artist_URL;;
  }

  dimension: release_artistsprimary_artists {
    type: string
    label: "Release Artist(s)-Primary Artist(s)"
    sql: ${TABLE}.Release_Artists_Primary_Artist;;
  }

  dimension: release_artistsfeaturings {
    type: string
    label: "Release Artist(s)-Featuring(s)"
    sql: ${TABLE}.Release_Artists_Featurings;;
  }

  dimension: release_artistsremixers {
    type: string
    label: "Release Artist(s)-Remixer(s)"
    sql: ${TABLE}.Release_Artists_Remixers;;
  }

  dimension: release_artistsproducers {
    type: string
    label: "Release Artist(s)-Producer(s)"
    sql: ${TABLE}.Release_Artists_Producers;;
  }

  dimension: release_artistscomposers {
    type: string
    label: "Release Artist(s)-Composer(s)"
    sql: ${TABLE}.Release_Artists_Composers;;
  }

  dimension: release_artistsorchestras {
    type: string
    label: "Release Artist(s)-Orchestra(s)"
    sql: ${TABLE}.Release_Artists_Orchestras;;
  }

  dimension: release_artistsensembles {
    type: string
    label: "Release Artist(s)-Ensemble(s)"
    sql: ${TABLE}.Release_Artists_Ensembles;;
  }

  dimension: release_artistsconductors {
    type: string
    label: "Release Artist(s)-Conductor(s)"
    sql: ${TABLE}.Release_Artists_Conductors;;
  }

  dimension: release_date {
    type: string
    label: "Release Date"
    sql: ${TABLE}.Release_Date;;
  }

  dimension: sale_start_date {
    type: string
    label: "Sale Start Date"
    sql: ${TABLE}.Sale_Start_Date;;
  }

  dimension: i_tunes_preorder {
    type: string
    label: "iTunes Pre-Order"
    sql: ${TABLE}.iTunes_PreOrder;;
  }

  dimension: i_tunes_preorder_date {
    type: string
    label: "iTunes Pre-Order Date"
    sql: ${TABLE}.iTunes_PreOrder_Date;;
  }

  dimension: preorder_preview {
    type: string
    label: "Preorder Preview"
    sql: ${TABLE}.Preorder_Preview;;
  }

  dimension: album_pricing {
    type: string
    label: "Album Pricing"
    sql: ${TABLE}.Album_Pricing;;
  }

  dimension: format_full_length_ep_single {
    type: string
    label: "Format: Full Length / EP / Single"
    sql: ${TABLE}.Format_Full_Length_EP_Single;;
  }

  dimension: imprint {
    type: string
    sql: ${TABLE}.Imprint;;
  }

  dimension: genre {
    type: string
    sql: ${TABLE}.Genre;;
  }

  dimension: subgenre {
    type: string
    label: "Sub-genre"
    sql: ${TABLE}.Sub_genre;;
  }

  dimension: c_information {
    type: string
    label: "[C] Information"
    sql: ${TABLE}.C_Information;;
  }

  dimension: digital_upc {
    type: string
    label: "Digital UPC"
    sql: ${TABLE}.Digital_UPC;;
  }

  dimension: manufacturers_upc {
    type: string
    label: "Manufacturer's UPC"
    sql: ${TABLE}.Manufacturers_UPC;;
  }

  dimension: folder_name__project_code {
    type: number
    label: "Folder Name / Project Code"
    sql: ${TABLE}.Folder_Name_Project_Code;;
    value_format_name: id
  }

  dimension: product_code {
    type: string
    label: "Product Code"
    sql: ${TABLE}.Product_Code;;
  }

  dimension: release_version {
    type: string
    label: "Release Version"
    sql: ${TABLE}.Release_Version;;
  }

  dimension: file_name {
    type: string
    label: "File Name"
    sql: ${TABLE}.File_Name;;
  }

  dimension: volume {
    type: number
    sql: ${TABLE}.Volume;;
  }

  dimension: track_no {
    type: number
    label: "Track No."
    sql: ${TABLE}.Track_No;;
    value_format_name: id
  }

  dimension: track_name {
    type: string
    label: "Track Name"
    sql: ${TABLE}.Track_Name;;
  }

  dimension: track_audio_language {
    type: string
    label: "Track Audio Language"
    sql: ${TABLE}.Track_Audio_Language;;
  }

  dimension: version {
    type: string
    sql: ${TABLE}.Version;;
  }

  dimension: track_artist {
    type: string
    label: "Track Artist"
    sql: ${TABLE}.Track_Artist;;
  }

  dimension: track_artists__featurings {
    type: string
    label: "Track Artist(s) - Featuring(s)"
    sql: ${TABLE}.Track_Artists_Featurings;;
  }

  dimension: track_artists__remixers {
    type: string
    label: "Track Artist(s) - Remixer(s)"
    sql: ${TABLE}.Track_Artists_Remixers;;
  }

  dimension: track_artists__producers {
    type: string
    label: "Track Artist(s) - Producer(s)"
    sql: ${TABLE}.Track_Artists_Producers;;
  }

  dimension: track_artists__composers {
    type: string
    label: "Track Artist(s) - Composer(s)"
    sql: ${TABLE}.Track_Artists_Composers;;
  }

  dimension: track_artists__orchestras {
    type: string
    label: "Track Artist(s) - Orchestra(s)"
    sql: ${TABLE}.Track_Artists_Orchestras
      ;;
  }

  dimension: track_artists__ensembles {
    type: string
    label: "Track Artist(s) - Ensemble(s)"
    sql: ${TABLE}.Track_Artists_Ensembles
      ;;
  }

  dimension: track_artists__conductors {
    type: string
    label: "Track Artist(s) - Conductor(s)"
    sql: ${TABLE}.Track_Artists_Conductors
      ;;
  }

  dimension: track_pricing {
    type: string
    label: "Track Pricing"
    sql: ${TABLE}.Track_Pricing
      ;;
  }

  dimension: explicit_noyesclean {
    type: string
    label: "Explicit (No/Yes/Clean)"
    sql: ${TABLE}.Explicit
      ;;
  }

  dimension: isrc {
    type: string
    label: "ISRC"
    sql: ${TABLE}.ISRC
      ;;
  }

  dimension: 3rd_party_publisher {
    type: string
    label: "3rd Party Publisher? (Yes/No)"
    sql: ${TABLE}.Third_Party_Publisher
      ;;
  }

  dimension: p_information {
    type: string
    label: "[P] Information"
    sql: ${TABLE}.P_Information
      ;;
  }

  dimension: ownership_track {
    type: string
    label: "Ownership For This Sound Recording"
    sql: ${TABLE}.Ownership_For_This_Sound_Recording
      ;;
  }

  dimension: ownership_country_of_recording {
    type: string
    label: "Country of Recording"
    sql: ${TABLE}.Country_of_Recording
      ;;
  }

  dimension: ownership_nationality_copyright {
    type: string
    label: "Nationality of Original Copyright Owner"
    sql: ${TABLE}.Nationality_of_Original_Copyright_Owner
      ;;
  }

  dimension: track_lyrics {
    type: string
    label: "Track Lyrics"
    sql: ${TABLE}.Track_Lyrics
      ;;
  }

  dimension: songwriters {
    type: string
    label: "Songwriter(s)"
    sql: ${TABLE}.Songwriters
      ;;
  }

  dimension: publishers {
    type: string
    label: "Publisher(s)"
    sql: ${TABLE}.Publishers
      ;;
  }

  dimension: performer_1_type {
    type: string
    label: "Performer 1 Type"
    sql: ${TABLE}.Performer_1_Type
      ;;
  }

  dimension: performer_1_legal_name {
    type: string
    label: "Performer 1 Legal Name"
    sql: ${TABLE}.Performer_1_Legal_Name
      ;;
  }

  dimension: performer_1_main_role {
    type: string
    label: "Performer 1 Main Role"
    sql: ${TABLE}.Performer_1_Main_Role
      ;;
  }

  dimension: performer_2_type {
    type: string
    label: "Performer 2 Type"
    sql: ${TABLE}.Performer_2_Type
      ;;
  }

  dimension: performer_2_legal_name {
    type: string
    label: "Performer 2 Legal Name"
    sql: ${TABLE}.Performer_2_Legal_Name
      ;;
  }

  dimension: performer_2_main_role {
    type: string
    label: "Performer 2 Main Role"
    sql: ${TABLE}.Performer_2_Main_Role
      ;;
  }

  dimension: performer_3_type {
    type: string
    label: "Performer 3 Type"
    sql: ${TABLE}.Performer_3_Type
      ;;
  }

  dimension: performer_3_legal_name {
    type: string
    label: "Performer 3 Legal Name"
    sql: ${TABLE}.Performer_3_Legal_Name
      ;;
  }

  dimension: performer_3_main_role {
    type: string
    label: "Performer 3 Main Role"
    sql: ${TABLE}.Performer_3_Main_Role
      ;;
  }

  dimension: performer_4_type {
    type: string
    label: "Performer 4 Type"
    sql: ${TABLE}.Performer_4_Type
      ;;
  }

  dimension: performer_4_legal_name {
    type: string
    label: "Performer 4 Legal Name"
    sql: ${TABLE}.Performer_4_Legal_Name
      ;;
  }

  dimension: performer_4_main_role {
    type: string
    label: "Performer 4 Main Role"
    sql: ${TABLE}.Performer_4_Main_Role
      ;;
  }

  dimension: performer_5_type {
    type: string
    label: "Performer 5 Type"
    sql: ${TABLE}.Performer_5_Type
      ;;
  }

  dimension: performer_5_legal_name {
    type: string
    label: "Performer 5 Legal Name"
    sql: ${TABLE}.Performer_5_Legal_Name
      ;;
  }

  dimension: performer_5_main_role {
    type: string
    label: "Performer 5 Main Role"
    sql: ${TABLE}.Performer_5_Main_Role
      ;;
  }

  dimension: only_includeonly_exclude {
    type: string
    label: "Only Include/Only Exclude?"
    sql: ${TABLE}.Only_Include_Only_Exclude
      ;;
  }

  dimension: territories_iso {
    type: string
    label: "Territories (ISO Codes)"
    sql: ${TABLE}.Territories_ISO_Codes
      ;;
  }

  dimension: catalog_ingest {
    type: string
    sql: ${TABLE}.CATALOG_INGEST
      ;;
  }

  dimension: compid {
    type: number
    sql: ${TABLE}.COMPID;;
    value_format_name: id
  }

  dimension: compnm {
    type: string
    sql: ${TABLE}.COMPNM
      ;;
  }

  dimension: compactive {
    type: string
    sql: ${TABLE}.COMPACTIVE
      ;;
  }

  dimension: orchlabelid {
    type: number
    sql: ${TABLE}.ORCHLABELID;;
    value_format_name: id
  }

  dimension: relid {
    type: number
    sql: ${TABLE}.RELID;;
    value_format_name: id
  }

  dimension: relactive {
    type: string
    sql: ${TABLE}.RELACTIVE
      ;;
  }

  dimension: trkid {
    type: number
    sql: ${TABLE}.TRKID;;
    value_format_name: id
  }

  dimension: trkactive {
    type: string
    sql: ${TABLE}.TRKACTIVE
      ;;
  }

  dimension: old_upc {
    type: string
    sql: ${TABLE}._UPC
      ;;
  }

  dimension: old_isrc {
    type: string
    sql: ${TABLE}._ISCR
      ;;
  }

  dimension: upcexists {
    type: string
    sql: ${TABLE}.UPCEXISTS
      ;;
  }

  dimension: rel_artist_cnt {
    type: string
    sql: ${TABLE}.RelArtistCnt
      ;;
  }

  dimension: rel_artist_nm {
    type: string
    sql: ${TABLE}.RelArtistNm;;
  }

  dimension: track_sequence_issue {
    type: string
    sql: ${TABLE}.Track_Sequence_Issue;;
  }

  dimension: bulk_upload_action{
    type: string
    label: "Bulk Upload Action"
    sql: ${TABLE}.BU_ACTION;;
  }

  dimension: bulk_upload_response{
    type: string
    label: "Bulk Upload Response"
    sql: ${TABLE}.BU_RESPONSE;;
  }

  dimension: bulk_upload_track_error{
    type: string
    label: "Bulk Upload Track Error"
    sql: ${TABLE}.BU_TRACK_ERROR;;
  }

  dimension: validation_metadata_error{
    type: string
    label: "Validation / Metadata Error"
    sql: ${TABLE}.VAL_MET_ERROR;;
  }

  dimension: original_value_1{
    type: string
    label: "Original Value 1"
    sql: ${TABLE}.ORIGINAL_VALUE1;;
  }

  dimension: original_value_2{
    type: string
    label: "Original Value 2"
    sql: ${TABLE}.ORIGINAL_VALUE2;;
  }

  dimension: taken_from_value{
    type: string
    label: "Taken From Value"
    sql: ${TABLE}.TAKEN_FROM_VALUE;;
  }

  dimension: suggested_value_1{
    type: string
    label: "Suggested Value 1"
    sql: ${TABLE}.SUGGESTED_VALUE1;;
  }

  dimension: suggested_value_2{
    type: string
    label: "Suggested Value 2"
    sql: ${TABLE}.SUGGESTED_VALUE2;;
  }

  dimension: validation_metadata_error_count{
    type: string
    label: "Count of Validation / Metadata Error"
    sql: ${TABLE}.VAL_MET_ERROR_COUNT;;
  }

  dimension: error_type{
    type: string
    label: "Error Type"
    sql: ${TABLE}.ERROR_TYPE;;
  }

  dimension: orchard_release_id{
    type: string
    label: "Orchard Release ID"
    sql: ${TABLE}.ORCHARD_RELEASE_ID;;
  }

}