view: dt_track_lyrics {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_TRACK_LYRICS ;;
#   derived_table: {
#     sql:
# SELECT info_for_id AS tuid, description AS track_lyrics
# FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info
# WHERE info_for = 'track' AND LENGTH(description) != 0 ;;
#   }

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

  dimension: track_lyrics {
    type: string
    sql: ${TABLE}.track_lyrics ;;
    view_label: "Track"
    label: "Track Lyrics"
#     html:
#     {% assign lyrics = value %}
#     {% unless {{lyrics.size}} == 0 %}
#     <details>
#     <summary>Expand</summary>
#     {{lyrics}}
#     </details>
#     {% endunless %}
#     ;;
  }
}