view: int_dbt_prod_full_track_metadata_report_delivery_history {
  sql_table_name: INTELLIGENCE.DBT_PROD.FULL_TRACK_METADATA_REPORT_DELIVERY_HISTORY ;;


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

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

  dimension: artist_name{
    view_label: "Artist"
    label: "Artist Name"
    type: string
    sql: ${TABLE}.artist_name ;;
  }

  dimension: country_name{
    view_label: "Artist"
    label: "Artist Country"
    type: string
    sql: ${TABLE}.artist_country_name ;;
  }

  dimension: vendor_id {
    view_label: "Label"
    label: "Label ID"
    type: number
    sql: ${TABLE}.vendor_id ;;
    value_format: "0"
  }

  dimension: vendor_name {
    view_label: "Label"
    label: "Label Name"
    type: number
    sql: ${TABLE}.vendor_name ;;
  }

  dimension: subaccount_id {
    view_label: "Subaccount"
    label: "Subaccount ID"
    type: number
    sql: ${TABLE}.subaccount_id ;;
  }

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

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

  dimension: release_artist_name_performer{
    view_label: "Release"
    label: "Release Artist Name Performer"
    type: string
    sql: ${TABLE}.release_artist_name_performer ;;
  }

  dimension: release_artist_name_featuring{
    view_label: "Release"
    label: "Release Artist Name Featuring"
    type: string
    sql: ${TABLE}.release_artist_name_featuring ;;
  }

  dimension: release_artist_name_remixer{
    view_label: "Release"
    label: "Release Artist Name Remixer"
    type: string
    sql: ${TABLE}.release_artist_name_remixer ;;
  }


  dimension: release_artist_name_composer{
    view_label: "Release"
    label: "Release Artist Name Composer"
    type: string
    sql: ${TABLE}.release_artist_name_composer ;;
  }

  dimension: release_artist_name_orchestra{
    view_label: "Release"
    label: "Release Artist Name Orchestra"
    type: string
    sql: ${TABLE}.release_artist_name_orchestra ;;
  }


  dimension: release_artist_name_ensemble{
    view_label: "Release"
    label: "Release Artist Name Ensemble"
    type: string
    sql: ${TABLE}.release_artist_name_ensemble ;;
  }

  dimension: release_artist_name_conductor{
    view_label: "Release"
    label: "Release Artist Name Conductor"
    type: string
    sql: ${TABLE}.release_artist_name_conductor ;;
  }

  dimension_group: release_date {
    view_label: "Release"
    label: "Release"
    type: time
    sql: ${TABLE}.release_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension_group: sale_start_date {
    view_label: "Release"
    label: "Sale Start"
    type: time
    sql: ${TABLE}.sale_start_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }


  dimension: dummy_field_1{
    view_label: "Dummy Fields"
    label: "Dummy Field 1"
    type: string
    sql: ${TABLE}.dummy_field_1 ;;
  }

  dimension: dummy_field_2{
    view_label: "Dummy Fields"
    label: "Dummy Field 2"
    type: string
    sql: ${TABLE}.dummy_field_2 ;;
  }

  dimension: release_itunes_previewable{
    view_label: "Release"
    label: "iTunes Previewable"
    type: string
    sql: ${TABLE}.releases_itunes_previewable ;;
  }


  dimension: dummy_field_4{
    view_label: "Dummy Fields"
    label: "Dummy Field 4"
    type: string
    sql: ${TABLE}.dummy_field_4 ;;
  }

  dimension: dummy_field_5{
    view_label: "Dummy Fields"
    label: "Dummy Field 5"
    type: string
    sql: ${TABLE}.dummy_field_5 ;;
  }


  dimension: release_format{
    view_label: "Release"
    label: "Format"
    type: string
    sql: ${TABLE}.releases_format ;;
  }

  dimension: label{
    view_label: "Imprint"
    label: "Imprint Name"
    type: string
    sql: ${TABLE}.release_label ;;
  }


  dimension: genre{
    view_label: "Release"
    label: "Genre"
    type: string
    sql: ${TABLE}.genre ;;
  }

  dimension: sub_genre{
    view_label: "Release"
    label: "Subgenre"
    type: string
    sql: ${TABLE}.subgenre ;;
  }

  dimension: release_c_line{
    view_label: "Release"
    label: "Release C Line"
    type: string
    sql: ${TABLE}.releases_c_line ;;
  }

  dimension: display_upc{
    view_label: "Release"
    label: "Display UPC"
    type: string
    sql: ${TABLE}.display_upc ;;
  }


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

  dimension: upc{
    view_label: "Release"
    label: "UPC"
    type: string
    sql: ${TABLE}.upc ;;
  }

  dimension: manufacturer_upc{
    view_label: "Release"
    label: "Manufacturer UPC"
    type: string
    sql: ${TABLE}.manufacturer_upc ;;
  }

  dimension: release_vendor_catalog_number {
    view_label: "Release"
    label: "Vendor Catalog Number"
    type: string
    sql: ${TABLE}.releases_vendor_catalog_number ;;
  }

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


  dimension: product_physical_display_configuration {
    view_label: "Release"
    label: "Physical Product Display Configuration"
    type: string
    sql: ${TABLE}.product_physical_display_configuration ;;
  }

  dimension: releases_not_for_distribution {
    view_label: "Release"
    label: "Not For Distribution"
    type: string
    sql: ${TABLE}.releases_not_for_distribution  ;;
  }

  dimension: release_status {
    view_label: "Release"
    label: "Status"
    type: string
    sql: ${TABLE}.release_status  ;;
  }


  dimension: releases_deletions {
    view_label: "Release"
    label: "Deletions"
    type: string
    sql: ${TABLE}.releases_deletions  ;;
  }

  dimension: track_video_id {
    view_label: "Track"
    label: "Track Video ID"
    type: string
    sql: ${TABLE}.track_video_id  ;;
  }

  dimension_group: delivery_history_date_delivered_date {
    view_label: "Release"
    label: "Delivered Date"
    type: time
    sql: ${TABLE}.delivery_history_date_delivered_date ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension: delivery_history_customer_name {
    view_label: "Release"
    label: "Delivery History Customer Name"
    type: string
    sql: ${TABLE}.delivery_history_customer_name  ;;
  }


  }