view: int_dbt_prod_lmcp_tiktok_top_tracks {
  sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TIKTOK_TOP_TRACKS";;


  dimension_group: Download_date_week{
    label:"Activity"
    type: time
    sql:${TABLE}.Download_date_week;;
    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: Label_manager{
    label:"Label Manager"
    type: string
    sql:${TABLE}.Label_manager;;
  }
  dimension: Label_name{
    label:"Label Name"
    type: string
    sql:${TABLE}.Label_name;;
  }
  dimension: Label_id{
    label:"Label ID"
    type: number
    sql:${TABLE}.Label_id;;
  }
  dimension: Subaccount_id{
    label:"Subaccount ID"
    type: number
    sql:${TABLE}.Subaccount_id;;
  }
  dimension: Artist_name{
    label:"Artist Name"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension: Track_name{
    label:"Track Name"
    type: string
    sql:${TABLE}.Track_name;;
  }
  dimension: Isrc{
    label:"ISRC"
    type: string
    sql:${TABLE}.Isrc;;
  }
  dimension: Territory{
    label:"Territory"
    type: string
    sql:${TABLE}.Territory;;
  }
  measure: Creations{
    label:"Creations"
    type: sum
    sql:${TABLE}.Creations;;
  }
  measure: Video_views{
    label:"Video views"
    type: sum
    sql:${TABLE}.Video_views;;
  }

}