view: int_dbt_prod_spotify_editorial_playlist_update_groups {
  sql_table_name: intelligence.dbt_prod.spotify_editorial_playlist_update_groups ;;
  suggestions: yes

  dimension_group: recorded_date{
    view_label: "Playlist Update Categorisation"
    label:"Recorded Date"
    type: time
    sql:${TABLE}.recorded_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: playlist_name {
    view_label: "Playlist Update Categorisation"
    label: "Playlist Name"
    type: string
    sql: ${TABLE}.playlist_name ;;
  }

  dimension: playlist_uri {
    view_label: "Playlist Update Categorisation"
    label: "Playlist URI"
    type: string
    sql: ${TABLE}.playlisturi ;;
  }

  dimension: playlist_url {
    view_label: "Playlist Update Categorisation"
    label: "Playlist URL"
    type: string
    sql: ${TABLE}.playlisturl ;;
  }

  dimension: playlist_type {
    view_label: "Playlist Update Categorisation"
    label: "Playlist Type"
    type: string
    sql: ${TABLE}.playlist_type ;;
  }

  dimension: playlist_author {
    view_label: "Playlist Update Categorisation"
    label: "Playlist Author"
    type: string
    sql: ${TABLE}.playlist_author ;;
  }

  dimension: playlist_update_groups {
    view_label: "Playlist Update Categorisation"
    label: "Playlist Update Group"
    type: string
    sql: ${TABLE}.playlist_update_groups ;;
  }

  dimension_group: most_recent_update_date{
    view_label: "Playlist Update Categorisation"
    label:"Most Recent Update Date"
    type: time
    sql:${TABLE}.most_recent_update;;
    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]
  }

  }