view: int_dbt_prod_lmcp_shazam_activity {
  sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_SHAZAM_ACTIVITY";;


  dimension_group: Download_activity_week{
    label:"Activity"
    type: time
    sql:${TABLE}.Download_activity_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: Quarterback_label_manager{
    label:"Quarterback Label Manager"
    type: string
    sql:${TABLE}.Quarterback_label_manager;;
  }
  dimension: Owner_name{
    label:"Owner Name"
    type: string
    sql:${TABLE}.Owner_name;;
  }
  dimension: Label_id{
    label:"Label ID"
    type: number
    sql:${TABLE}.Label_id;;
  }
  dimension: Label_name{
    label:"Label Name"
    type: string
    sql:${TABLE}.Label_name;;
  }
  dimension: Artist_name{
    label:"Artist Name"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension: Track_title{
    label:"Track Title"
    type: string
    sql:${TABLE}.Track_title;;
  }
  measure: Shazams{
    label:"Shazams"
    type: sum
    sql:${TABLE}.Shazams;;
  }

}