view: publishing_metadata {
  sql_table_name: intelligence.dbt_prod.publishing_metadata ;;

  dimension: label_id {
    type: string
    sql: ${TABLE}.label_id ;;
    value_format: "0"
  }

  dimension: label_name {
    type: string
    sql: ${TABLE}.label_name ;;
  }

  dimension: territory_restrictions {
    label: "Territory Restrictions"
    type: string
    sql: ${TABLE}.territory_restrictions ;;
  }

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

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

  dimension: primary_artists {
    type: string
    sql: ${TABLE}.primary_artists;;
  }

  dimension: upc {
    label: "UPC"
    type: number
    sql: ${TABLE}.upc;;
    value_format: "0"
  }

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

  dimension: tuid {
    label: "TUID"
    type: string
    sql: ${TABLE}.tuid;;
  }

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

  dimension: track_minutes {
    type: string
    sql: ${TABLE}.length_minute;;
  }

  dimension: track_seconds {
    type: string
    sql: ${TABLE}.length_seconds;;
  }

  dimension: title {
    type: string
    sql: ${TABLE}.song_title;;
  }

  dimension: alternate_titles {
    type: string
    sql: ${TABLE}.alternate_titles;;
  }

  dimension: contains_sample {
    type: string
    sql: ${TABLE}.contains_sample;;
  }

  dimension: contains_elements_of_public_domain {
    type: string
    sql: ${TABLE}.contains_elements_of_public_domain;;
  }

  dimension: pub_song_id {
    type: number
    sql: ${TABLE}.pub_song_id;;
    value_format: "0"
    link: {
      label: "Open Publishing Revenue Dashboard"
      url: "https://theorchardoem.looker.com/dashboards/147?Pub Song ID={{ value }}"
    }
  }

  dimension: created_at {
    label: "Created At"
    type: date
    sql: ${TABLE}.created_at ;;
  }

  dimension: submitted_At {
    label: "Submitted At"
    type: date
    sql: ${TABLE}.submitted_at ;;
  }

  dimension: work_id {
    label: "Work ID"
    type: string
    sql: ${TABLE}.work_id;;
  }

  dimension: iswc {
    label: "ISWC"
    type: string
    sql: ${TABLE}.iswc;;
  }

  dimension: composer_1_name {
    type: string
    sql: ${TABLE}.composer_1_name;;
  }

  dimension: composer_1_sample {
    type: string
    sql: ${TABLE}.composer_1_sample;;
  }

  dimension: composer_1_public_domain {
    type: string
    sql: ${TABLE}.composer_1_public_domain;;
  }

  dimension: composer_1_id {
    type: number
    sql: ${TABLE}.composer_1_writer_id;;
  }

  dimension: composer_1_pro {
    type: string
    sql: ${TABLE}.composer_1_pro;;
  }

  dimension: composer_1_ipi {
    type: number
    sql: ${TABLE}.composer_1_ipi;;
    value_format: "0"
  }

  dimension: composer_1_capacity {
    type: string
    sql: ${TABLE}.composer_1_capacity;;
  }

  dimension: publisher_1_name {
    type: string
    sql: ${TABLE}.publisher_1_name;;
  }

  dimension: publisher_1_pub_id {
    type: string
    sql: ${TABLE}.publisher_1_pub_id;;
  }

  dimension: publisher_1_pro {
    type: string
    sql: ${TABLE}.publisher_1_pro;;
  }

  dimension: publisher_1_ipi {
    type: string
    sql: ${TABLE}.publisher_1_ipi;;
  }

  dimension: composer_1_split {
    type: number
    sql: ${TABLE}.composer_1_split;;
  }

  dimension: composer_controlled_1 {
    type: string
    sql: ${TABLE}.composer_1_controlled;;
  }

##

  dimension: composer_2_name {
    type: string
    sql: ${TABLE}.composer_2_name;;
  }

  dimension: composer_2_sample {
    type: string
    sql: ${TABLE}.composer_2_sample;;
  }

  dimension: composer_2_public_domain {
    type: string
    sql: ${TABLE}.composer_2_public_domain;;
  }

  dimension: composer_2_id {
    type: number
    sql: ${TABLE}.composer_2_writer_id;;
  }

  dimension: composer_2_pro {
    type: string
    sql: ${TABLE}.composer_2_pro;;
  }

  dimension: composer_2_ipi {
    type: number
    sql: ${TABLE}.composer_2_ipi;;
    value_format: "0"
  }

  dimension: composer_2_capacity {
    type: string
    sql: ${TABLE}.composer_2_capacity;;
  }

  dimension: publisher_2_name {
    type: string
    sql: ${TABLE}.publisher_2_name;;
  }

  dimension: publisher_2_pub_id {
    type: string
    sql: ${TABLE}.publisher_2_pub_id;;
  }

  dimension: publisher_2_pro {
    type: string
    sql: ${TABLE}.publisher_2_pro;;
  }

  dimension: publisher_2_ipi {
    type: string
    sql: ${TABLE}.publisher_2_ipi;;
  }

  dimension: composer_2_split {
    type: number
    sql: ${TABLE}.composer_2_split;;
  }

  dimension: composer_controlled_2 {
    type: string
    sql: ${TABLE}.composer_2_controlled;;
  }

  dimension: composer_3_name {
    type: string
    sql: ${TABLE}.composer_3_name;;
  }

  dimension: composer_3_sample {
    type: string
    sql: ${TABLE}.composer_3_sample;;
  }

  dimension: composer_3_public_domain {
    type: string
    sql: ${TABLE}.composer_3_public_domain;;
  }

  dimension: composer_3_id {
    type: number
    sql: ${TABLE}.composer_3_writer_id;;
  }

  dimension: composer_3_pro {
    type: string
    sql: ${TABLE}.composer_3_pro;;
  }

  dimension: composer_3_ipi {
    type: number
    sql: ${TABLE}.composer_3_ipi;;
    value_format: "0"
  }

  dimension: composer_3_capacity {
    type: string
    sql: ${TABLE}.composer_3_capacity;;
  }

  dimension: publisher_3_name {
    type: string
    sql: ${TABLE}.publisher_3_name;;
  }

  dimension: publisher_3_pub_id {
    type: string
    sql: ${TABLE}.publisher_3_pub_id;;
  }

  dimension: publisher_3_pro {
    type: string
    sql: ${TABLE}.publisher_3_pro;;
  }

  dimension: publisher_3_ipi {
    type: string
    sql: ${TABLE}.publisher_3_ipi;;
  }

  dimension: composer_3_split {
    type: number
    sql: ${TABLE}.composer_3_split;;
  }

  dimension: composer_controlled_3 {
    type: string
    sql: ${TABLE}.composer_3_controlled;;
  }

  dimension: composer_4_name {
    type: string
    sql: ${TABLE}.composer_4_name;;
  }

  dimension: composer_4_sample {
    type: string
    sql: ${TABLE}.composer_4_sample;;
  }

  dimension: composer_4_public_domain {
    type: string
    sql: ${TABLE}.composer_4_public_domain;;
  }

  dimension: composer_4_id {
    type: number
    sql: ${TABLE}.composer_4_writer_id;;
  }

  dimension: composer_4_pro {
    type: string
    sql: ${TABLE}.composer_4_pro;;
  }

  dimension: composer_4_ipi {
    type: number
    sql: ${TABLE}.composer_4_ipi;;
    value_format: "0"
  }

  dimension: composer_4_capacity {
    type: string
    sql: ${TABLE}.composer_4_capacity;;
  }

  dimension: publisher_4_name {
    type: string
    sql: ${TABLE}.publisher_4_name;;
  }

  dimension: publisher_4_pub_id {
    type: string
    sql: ${TABLE}.publisher_4_pub_id;;
  }

  dimension: publisher_4_pro {
    type: string
    sql: ${TABLE}.publisher_4_pro;;
  }

  dimension: publisher_4_ipi {
    type: string
    sql: ${TABLE}.publisher_4_ipi;;
  }

  dimension: composer_4_split {
    type: number
    sql: ${TABLE}.composer_4_split;;
  }

  dimension: composer_controlled_4 {
    type: string
    sql: ${TABLE}.composer_4_controlled;;
  }

  dimension: composer_5_name {
    type: string
    sql: ${TABLE}.composer_5_name;;
  }

  dimension: composer_5_sample {
    type: string
    sql: ${TABLE}.composer_5_sample;;
  }

  dimension: composer_5_public_domain {
    type: string
    sql: ${TABLE}.composer_5_public_domain;;
  }

  dimension: composer_5_id {
    type: number
    sql: ${TABLE}.composer_5_writer_id;;
  }

  dimension: composer_5_pro {
    type: string
    sql: ${TABLE}.composer_5_pro;;
  }

  dimension: composer_5_ipi {
    type: number
    sql: ${TABLE}.composer_5_ipi;;
    value_format: "0"
  }

  dimension: composer_5_capacity {
    type: string
    sql: ${TABLE}.composer_5_capacity;;
  }

  dimension: publisher_5_name {
    type: string
    sql: ${TABLE}.publisher_5_name;;
  }

  dimension: publisher_5_pub_id {
    type: string
    sql: ${TABLE}.publisher_5_pub_id;;
  }

  dimension: publisher_5_pro {
    type: string
    sql: ${TABLE}.publisher_5_pro;;
  }

  dimension: publisher_5_ipi {
    type: string
    sql: ${TABLE}.publisher_5_ipi;;
  }

  dimension: composer_5_split {
    type: number
    sql: ${TABLE}.composer_5_split;;
  }

  dimension: composer_controlled_5 {
    type: string
    sql: ${TABLE}.composer_5_controlled;;
  }

  dimension: composer_6_name {
    type: string
    sql: ${TABLE}.composer_6_name;;
  }

  dimension: composer_6_sample {
    type: string
    sql: ${TABLE}.composer_6_sample;;
  }

  dimension: composer_6_public_domain {
    type: string
    sql: ${TABLE}.composer_6_public_domain;;
  }

  dimension: composer_6_id {
    type: number
    sql: ${TABLE}.composer_6_writer_id;;
  }

  dimension: composer_6_pro {
    type: string
    sql: ${TABLE}.composer_6_pro;;
  }

  dimension: composer_6_ipi {
    type: number
    sql: ${TABLE}.composer_6_ipi;;
    value_format: "0"
  }

  dimension: composer_6_capacity {
    type: string
    sql: ${TABLE}.composer_6_capacity;;
  }

  dimension: publisher_6_name {
    type: string
    sql: ${TABLE}.publisher_6_name;;
  }

  dimension: publisher_6_pub_id {
    type: string
    sql: ${TABLE}.publisher_6_pub_id;;
  }

  dimension: publisher_6_pro {
    type: string
    sql: ${TABLE}.publisher_6_pro;;
  }

  dimension: publisher_6_ipi {
    type: string
    sql: ${TABLE}.publisher_6_ipi;;
  }

  dimension: composer_6_split {
    type: number
    sql: ${TABLE}.composer_6_split;;
  }

  dimension: composer_controlled_6 {
    type: string
    sql: ${TABLE}.composer_6_controlled;;
  }

  dimension: composer_7_name {
    type: string
    sql: ${TABLE}.composer_7_name;;
  }

  dimension: composer_7_sample {
    type: string
    sql: ${TABLE}.composer_7_sample;;
  }

  dimension: composer_7_public_domain {
    type: string
    sql: ${TABLE}.composer_7_public_domain;;
  }

  dimension: composer_7_id {
    type: number
    sql: ${TABLE}.composer_7_writer_id;;
  }

  dimension: composer_7_pro {
    type: string
    sql: ${TABLE}.composer_7_pro;;
  }

  dimension: composer_7_ipi {
    type: number
    sql: ${TABLE}.composer_7_ipi;;
    value_format: "0"
  }

  dimension: composer_7_capacity {
    type: string
    sql: ${TABLE}.composer_7_capacity;;
  }

  dimension: publisher_7_name {
    type: string
    sql: ${TABLE}.publisher_7_name;;
  }

  dimension: publisher_7_pub_id {
    type: string
    sql: ${TABLE}.publisher_7_pub_id;;
  }

  dimension: publisher_7_pro {
    type: string
    sql: ${TABLE}.publisher_7_pro;;
  }

  dimension: publisher_7_ipi {
    type: string
    sql: ${TABLE}.publisher_7_ipi;;
  }

  dimension: composer_7_split {
    type: number
    sql: ${TABLE}.composer_7_split;;
  }

  dimension: composer_controlled_7 {
    type: string
    sql: ${TABLE}.composer_7_controlled;;
  }

  dimension: composer_8_name {
    type: string
    sql: ${TABLE}.composer_8_name;;
  }

  dimension: composer_8_sample {
    type: string
    sql: ${TABLE}.composer_8_sample;;
  }

  dimension: composer_8_public_domain {
    type: string
    sql: ${TABLE}.composer_8_public_domain;;
  }

  dimension: composer_8_id {
    type: number
    sql: ${TABLE}.composer_8_writer_id;;
  }

  dimension: composer_8_pro {
    type: string
    sql: ${TABLE}.composer_8_pro;;
  }

  dimension: composer_8_ipi {
    type: number
    sql: ${TABLE}.composer_8_ipi;;
    value_format: "0"
  }

  dimension: composer_8_capacity {
    type: string
    sql: ${TABLE}.composer_8_capacity;;
  }

  dimension: publisher_8_name {
    type: string
    sql: ${TABLE}.publisher_8_name;;
  }

  dimension: publisher_8_pub_id {
    type: string
    sql: ${TABLE}.publisher_8_pub_id;;
  }

  dimension: publisher_8_pro {
    type: string
    sql: ${TABLE}.publisher_8_pro;;
  }

  dimension: publisher_8_ipi {
    type: string
    sql: ${TABLE}.publisher_8_ipi;;
  }

  dimension: composer_8_split {
    type: number
    sql: ${TABLE}.composer_8_split;;
  }

  dimension: composer_controlled_8 {
    type: string
    sql: ${TABLE}.composer_8_controlled;;
  }

  dimension: composer_9_name {
    type: string
    sql: ${TABLE}.composer_9_name;;
  }

  dimension: composer_9_sample {
    type: string
    sql: ${TABLE}.composer_9_sample;;
  }

  dimension: composer_9_public_domain {
    type: string
    sql: ${TABLE}.composer_9_public_domain;;
  }

  dimension: composer_9_id {
    type: number
    sql: ${TABLE}.composer_9_writer_id;;
  }

  dimension: composer_9_pro {
    type: string
    sql: ${TABLE}.composer_9_pro;;
  }

  dimension: composer_9_ipi {
    type: number
    sql: ${TABLE}.composer_9_ipi;;
    value_format: "0"
  }

  dimension: composer_9_capacity {
    type: string
    sql: ${TABLE}.composer_9_capacity;;
  }

  dimension: publisher_9_name {
    type: string
    sql: ${TABLE}.publisher_9_name;;
  }

  dimension: publisher_9_pub_id {
    type: string
    sql: ${TABLE}.publisher_9_pub_id;;
  }

  dimension: publisher_9_pro {
    type: string
    sql: ${TABLE}.publisher_9_pro;;
  }

  dimension: publisher_9_ipi {
    type: string
    sql: ${TABLE}.publisher_9_ipi;;
  }

  dimension: composer_9_split {
    type: number
    sql: ${TABLE}.composer_9_split;;
  }

  dimension: composer_controlled_9 {
    type: string
    sql: ${TABLE}.composer_9_controlled;;
  }

  dimension: composer_10_name {
    type: string
    sql: ${TABLE}.composer_10_name;;
  }

  dimension: composer_10_sample {
    type: string
    sql: ${TABLE}.composer_10_sample;;
  }

  dimension: composer_10_public_domain {
    type: string
    sql: ${TABLE}.composer_10_public_domain;;
  }

  dimension: composer_10_id {
    type: number
    sql: ${TABLE}.composer_10_writer_id;;
  }

  dimension: composer_10_pro {
    type: string
    sql: ${TABLE}.composer_10_pro;;
  }

  dimension: composer_10_ipi {
    type: number
    sql: ${TABLE}.composer_10_ipi;;
    value_format: "0"
  }

  dimension: composer_10_capacity {
    type: string
    sql: ${TABLE}.composer_10_capacity;;
  }

  dimension: publisher_10_name {
    type: string
    sql: ${TABLE}.publisher_10_name;;
  }

  dimension: publisher_10_pub_id {
    type: string
    sql: ${TABLE}.publisher_10_pub_id;;
  }

  dimension: publisher_10_pro {
    type: string
    sql: ${TABLE}.publisher_10_pro;;
  }

  dimension: publisher_10_ipi {
    type: string
    sql: ${TABLE}.publisher_10_ipi;;
  }

  dimension: composer_10_split {
    type: number
    sql: ${TABLE}.composer_10_split;;
  }

  dimension: composer_controlled_10 {
    type: string
    sql: ${TABLE}.composer_10_controlled;;
  }

  dimension: composer_11_name {
    type: string
    sql: ${TABLE}.composer_11_name;;
  }

  dimension: composer_11_sample {
    type: string
    sql: ${TABLE}.composer_11_sample;;
  }

  dimension: composer_11_public_domain {
    type: string
    sql: ${TABLE}.composer_11_public_domain;;
  }

  dimension: composer_11_id {
    type: number
    sql: ${TABLE}.composer_11_writer_id;;
  }

  dimension: composer_11_pro {
    type: string
    sql: ${TABLE}.composer_11_pro;;
  }

  dimension: composer_11_ipi {
    type: number
    sql: ${TABLE}.composer_11_ipi;;
    value_format: "0"
  }

  dimension: composer_11_capacity {
    type: string
    sql: ${TABLE}.composer_11_capacity;;
  }

  dimension: publisher_11_name {
    type: string
    sql: ${TABLE}.publisher_11_name;;
  }

  dimension: publisher_11_pub_id {
    type: string
    sql: ${TABLE}.publisher_11_pub_id;;
  }

  dimension: publisher_11_pro {
    type: string
    sql: ${TABLE}.publisher_11_pro;;
  }

  dimension: publisher_11_ipi {
    type: string
    sql: ${TABLE}.publisher_11_ipi;;
  }

  dimension: composer_11_split {
    type: number
    sql: ${TABLE}.composer_11_split;;
  }

  dimension: composer_controlled_11 {
    type: string
    sql: ${TABLE}.composer_11_controlled;;
  }

  dimension: composer_12_name {
    type: string
    sql: ${TABLE}.composer_12_name;;
  }

  dimension: composer_12_sample {
    type: string
    sql: ${TABLE}.composer_12_sample;;
  }

  dimension: composer_12_public_domain {
    type: string
    sql: ${TABLE}.composer_12_public_domain;;
  }

  dimension: composer_12_id {
    type: number
    sql: ${TABLE}.composer_12_writer_id;;
  }

  dimension: composer_12_pro {
    type: string
    sql: ${TABLE}.composer_12_pro;;
  }

  dimension: composer_12_ipi {
    type: number
    sql: ${TABLE}.composer_12_ipi;;
    value_format: "0"
  }

  dimension: composer_12_capacity {
    type: string
    sql: ${TABLE}.composer_12_capacity;;
  }

  dimension: publisher_12_name {
    type: string
    sql: ${TABLE}.publisher_12_name;;
  }

  dimension: publisher_12_pub_id {
    type: string
    sql: ${TABLE}.publisher_12_pub_id;;
  }

  dimension: publisher_12_pro {
    type: string
    sql: ${TABLE}.publisher_12_pro;;
  }

  dimension: publisher_12_ipi {
    type: string
    sql: ${TABLE}.publisher_12_ipi;;
  }

  dimension: composer_12_split {
    type: number
    sql: ${TABLE}.composer_12_split;;
  }

  dimension: composer_controlled_12 {
    type: string
    sql: ${TABLE}.composer_12_controlled;;
  }

  dimension: composer_13_name {
    type: string
    sql: ${TABLE}.composer_13_name;;
  }

  dimension: composer_13_sample {
    type: string
    sql: ${TABLE}.composer_13_sample;;
  }

  dimension: composer_13_public_domain {
    type: string
    sql: ${TABLE}.composer_13_public_domain;;
  }

  dimension: composer_13_id {
    type: number
    sql: ${TABLE}.composer_13_writer_id;;
  }

  dimension: composer_13_pro {
    type: string
    sql: ${TABLE}.composer_13_pro;;
  }

  dimension: composer_13_ipi {
    type: number
    sql: ${TABLE}.composer_13_ipi;;
    value_format: "0"
  }

  dimension: composer_13_capacity {
    type: string
    sql: ${TABLE}.composer_13_capacity;;
  }

  dimension: publisher_13_name {
    type: string
    sql: ${TABLE}.publisher_13_name;;
  }

  dimension: publisher_13_pub_id {
    type: string
    sql: ${TABLE}.publisher_13_pub_id;;
  }

  dimension: publisher_13_pro {
    type: string
    sql: ${TABLE}.publisher_13_pro;;
  }

  dimension: publisher_13_ipi {
    type: string
    sql: ${TABLE}.publisher_13_ipi;;
  }

  dimension: composer_13_split {
    type: number
    sql: ${TABLE}.composer_13_split;;
  }

  dimension: composer_controlled_13 {
    type: string
    sql: ${TABLE}.composer_13_controlled;;
  }

  dimension: composer_14_name {
    type: string
    sql: ${TABLE}.composer_14_name;;
  }

  dimension: composer_14_sample {
    type: string
    sql: ${TABLE}.composer_14_sample;;
  }

  dimension: composer_14_public_domain {
    type: string
    sql: ${TABLE}.composer_14_public_domain;;
  }

  dimension: composer_14_id {
    type: number
    sql: ${TABLE}.composer_14_writer_id;;
  }

  dimension: composer_14_pro {
    type: string
    sql: ${TABLE}.composer_14_pro;;
  }

  dimension: composer_14_ipi {
    type: number
    sql: ${TABLE}.composer_14_ipi;;
    value_format: "0"
  }

  dimension: composer_14_capacity {
    type: string
    sql: ${TABLE}.composer_14_capacity;;
  }

  dimension: publisher_14_name {
    type: string
    sql: ${TABLE}.publisher_14_name;;
  }

  dimension: publisher_14_pub_id {
    type: string
    sql: ${TABLE}.publisher_14_pub_id;;
  }

  dimension: publisher_14_pro {
    type: string
    sql: ${TABLE}.publisher_14_pro;;
  }

  dimension: publisher_14_ipi {
    type: string
    sql: ${TABLE}.publisher_14_ipi;;
  }

  dimension: composer_14_split {
    type: number
    sql: ${TABLE}.composer_14_split;;
  }

  dimension: composer_controlled_14 {
    type: string
    sql: ${TABLE}.composer_14_controlled;;
  }

  dimension: composer_15_name {
    type: string
    sql: ${TABLE}.composer_15_name;;
  }

  dimension: composer_15_sample {
    type: string
    sql: ${TABLE}.composer_15_sample;;
  }

  dimension: composer_15_public_domain {
    type: string
    sql: ${TABLE}.composer_15_public_domain;;
  }

  dimension: composer_15_id {
    type: number
    sql: ${TABLE}.composer_15_writer_id;;
  }

  dimension: composer_15_pro {
    type: string
    sql: ${TABLE}.composer_15_pro;;
  }

  dimension: composer_15_ipi {
    type: number
    sql: ${TABLE}.composer_15_ipi;;
    value_format: "0"
  }

  dimension: composer_15_capacity {
    type: string
    sql: ${TABLE}.composer_15_capacity;;
  }

  dimension: publisher_15_name {
    type: string
    sql: ${TABLE}.publisher_15_name;;
  }

  dimension: publisher_15_pub_id {
    type: string
    sql: ${TABLE}.publisher_15_pub_id;;
  }

  dimension: publisher_15_pro {
    type: string
    sql: ${TABLE}.publisher_15_pro;;
  }

  dimension: publisher_15_ipi {
    type: string
    sql: ${TABLE}.publisher_15_ipi;;
  }

  dimension: composer_15_split {
    type: number
    sql: ${TABLE}.composer_15_split;;
  }

  dimension: composer_controlled_15 {
    type: string
    sql: ${TABLE}.composer_15_controlled;;
  }

  dimension: composer_16_name {
    type: string
    sql: ${TABLE}.composer_16_name;;
  }

  dimension: composer_16_sample {
    type: string
    sql: ${TABLE}.composer_16_sample;;
  }

  dimension: composer_16_public_domain {
    type: string
    sql: ${TABLE}.composer_16_public_domain;;
  }

  dimension: composer_16_id {
    type: number
    sql: ${TABLE}.composer_16_writer_id;;
  }

  dimension: composer_16_pro {
    type: string
    sql: ${TABLE}.composer_16_pro;;
  }

  dimension: composer_16_ipi {
    type: number
    sql: ${TABLE}.composer_16_ipi;;
    value_format: "0"
  }

  dimension: composer_16_capacity {
    type: string
    sql: ${TABLE}.composer_16_capacity;;
  }

  dimension: publisher_16_name {
    type: string
    sql: ${TABLE}.publisher_16_name;;
  }

  dimension: publisher_16_pub_id {
    type: string
    sql: ${TABLE}.publisher_16_pub_id;;
  }

  dimension: publisher_16_pro {
    type: string
    sql: ${TABLE}.publisher_16_pro;;
  }

  dimension: publisher_16_ipi {
    type: string
    sql: ${TABLE}.publisher_16_ipi;;
  }

  dimension: composer_16_split {
    type: number
    sql: ${TABLE}.composer_16_split;;
  }

  dimension: composer_controlled_16 {
    type: string
    sql: ${TABLE}.composer_16_controlled;;
  }

  dimension: composer_17_name {
    type: string
    sql: ${TABLE}.composer_17_name;;
  }

  dimension: composer_17_sample {
    type: string
    sql: ${TABLE}.composer_17_sample;;
  }

  dimension: composer_17_public_domain {
    type: string
    sql: ${TABLE}.composer_17_public_domain;;
  }

  dimension: composer_17_id {
    type: number
    sql: ${TABLE}.composer_17_writer_id;;
  }

  dimension: composer_17_pro {
    type: string
    sql: ${TABLE}.composer_17_pro;;
  }

  dimension: composer_17_ipi {
    type: number
    sql: ${TABLE}.composer_17_ipi;;
    value_format: "0"
  }

  dimension: composer_17_capacity {
    type: string
    sql: ${TABLE}.composer_17_capacity;;
  }

  dimension: publisher_17_name {
    type: string
    sql: ${TABLE}.publisher_17_name;;
  }

  dimension: publisher_17_pub_id {
    type: string
    sql: ${TABLE}.publisher_17_pub_id;;
  }

  dimension: publisher_17_pro {
    type: string
    sql: ${TABLE}.publisher_17_pro;;
  }

  dimension: publisher_17_ipi {
    type: string
    sql: ${TABLE}.publisher_17_ipi;;
  }

  dimension: composer_17_split {
    type: number
    sql: ${TABLE}.composer_17_split;;
  }

  dimension: composer_controlled_17 {
    type: string
    sql: ${TABLE}.composer_17_controlled;;
  }

  dimension: composer_18_name {
    type: string
    sql: ${TABLE}.composer_18_name;;
  }

  dimension: composer_18_sample {
    type: string
    sql: ${TABLE}.composer_18_sample;;
  }

  dimension: composer_18_public_domain {
    type: string
    sql: ${TABLE}.composer_18_public_domain;;
  }

  dimension: composer_18_id {
    type: number
    sql: ${TABLE}.composer_18_writer_id;;
  }

  dimension: composer_18_pro {
    type: string
    sql: ${TABLE}.composer_18_pro;;
  }

  dimension: composer_18_ipi {
    type: number
    sql: ${TABLE}.composer_18_ipi;;
    value_format: "0"
  }

  dimension: composer_18_capacity {
    type: string
    sql: ${TABLE}.composer_18_capacity;;
  }

  dimension: publisher_18_name {
    type: string
    sql: ${TABLE}.publisher_18_name;;
  }

  dimension: publisher_18_pub_id {
    type: string
    sql: ${TABLE}.publisher_18_pub_id;;
  }

  dimension: publisher_18_pro {
    type: string
    sql: ${TABLE}.publisher_18_pro;;
  }

  dimension: publisher_18_ipi {
    type: string
    sql: ${TABLE}.publisher_18_ipi;;
  }

  dimension: composer_18_split {
    type: number
    sql: ${TABLE}.composer_18_split;;
  }

  dimension: composer_controlled_18 {
    type: string
    sql: ${TABLE}.composer_18_controlled;;
  }

  dimension: composer_19_name {
    type: string
    sql: ${TABLE}.composer_19_name;;
  }

  dimension: composer_19_sample {
    type: string
    sql: ${TABLE}.composer_19_sample;;
  }

  dimension: composer_19_public_domain {
    type: string
    sql: ${TABLE}.composer_19_public_domain;;
  }

  dimension: composer_19_id {
    type: number
    sql: ${TABLE}.composer_19_writer_id;;
  }

  dimension: composer_19_pro {
    type: string
    sql: ${TABLE}.composer_19_pro;;
  }

  dimension: composer_19_ipi {
    type: number
    sql: ${TABLE}.composer_19_ipi;;
    value_format: "0"
  }

  dimension: composer_19_capacity {
    type: string
    sql: ${TABLE}.composer_19_capacity;;
  }

  dimension: publisher_19_name {
    type: string
    sql: ${TABLE}.publisher_19_name;;
  }

  dimension: publisher_19_pub_id {
    type: string
    sql: ${TABLE}.publisher_19_pub_id;;
  }

  dimension: publisher_19_pro {
    type: string
    sql: ${TABLE}.publisher_19_pro;;
  }

  dimension: publisher_19_ipi {
    type: string
    sql: ${TABLE}.publisher_19_ipi;;
  }

  dimension: composer_19_split {
    type: number
    sql: ${TABLE}.composer_19_split;;
  }

  dimension: composer_controlled_19 {
    type: string
    sql: ${TABLE}.composer_19_controlled;;
  }

  dimension: composer_20_name {
    type: string
    sql: ${TABLE}.composer_20_name;;
  }

  dimension: composer_20_sample {
    type: string
    sql: ${TABLE}.composer_20_sample;;
  }

  dimension: composer_20_public_domain {
    type: string
    sql: ${TABLE}.composer_20_public_domain;;
  }

  dimension: composer_20_id {
    type: number
    sql: ${TABLE}.composer_20_writer_id;;
  }

  dimension: composer_20_pro {
    type: string
    sql: ${TABLE}.composer_20_pro;;
  }

  dimension: composer_20_ipi {
    type: number
    sql: ${TABLE}.composer_20_ipi;;
    value_format: "0"
  }

  dimension: composer_20_capacity {
    type: string
    sql: ${TABLE}.composer_20_capacity;;
  }

  dimension: publisher_20_name {
    type: string
    sql: ${TABLE}.publisher_20_name;;
  }

  dimension: publisher_20_pub_id {
    type: string
    sql: ${TABLE}.publisher_20_pub_id;;
  }

  dimension: publisher_20_pro {
    type: string
    sql: ${TABLE}.publisher_20_pro;;
  }

  dimension: publisher_20_ipi {
    type: string
    sql: ${TABLE}.publisher_20_ipi;;
  }

  dimension: composer_20_split {
    type: number
    sql: ${TABLE}.composer_20_split;;
  }

  dimension: composer_controlled_20 {
    type: string
    sql: ${TABLE}.composer_20_controlled;;
  }

  dimension: delivered {
    type: string
    sql: ${TABLE}.delivered ;;
  }

  dimension_group: delivery_date {
    type: time
    sql: ${TABLE}.delivery_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]
  }
}