view: orch_app_ar_artist_info {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ;;

  dimension: artist_id {
    type: number
    sql: ${TABLE}.artist_id ;;
    primary_key: yes
  }

  dimension: name {
    label: "Artist Name"
    type: string
    case_sensitive: yes
    sql: ${TABLE}.name ;;
    link: {
      label: "Artist View"
      url:
      "

      {% if _explore._name == 'facts_prod_fact_analytics_v2' and orch_app_ar_artist_info.name._in_query and facts_prod_fact_analytics_v2.labelid._in_query %}
      https://theorchard.looker.com/dashboards-next/1743?Artist%20Name={{ orch_app_ar_artist_info.name._value }}&Label%20ID={{ facts_prod_fact_analytics_v2.labelid._value }}


      {% else %}

      {% endif %}
      "
    }
  }

  dimension: orchard_country {
    type: number
    sql: ${TABLE}.orchard_country ;;
    hidden: yes
  }

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  measure: count_artists {
    label: "Number of Artists"
    hidden: yes
    type: count_distinct
    sql: ${artist_id} ;;
  }

  # artist_key is specific to the artist_similarity model
  dimension: artist_key {
    type: string
    sql: TRIM(LOWER(${name})) ;;
    hidden: yes
  }

  dimension: active {
    type: yesno
    sql: IFF(${TABLE}.active = 'Y', TRUE, FALSE) ;;
  }

  dimension: myspace_url {
    type: string
    sql: ${TABLE}.myspace_url ;;
    hidden: yes
  }
  }