view: int_dbt_prod_pmcp_shazam_activity {
      sql_table_name:"INTELLIGENCE"."DBT_PROD"."SHAZAM_ACITIVITY";;


    dimension: Label_name{
      label:"Label_name"
      type: string
      sql:${TABLE}.Label_name;;
    }
    dimension: Vendor_id{
      label:"Vendor_id"
      type: number
      sql:${TABLE}.Vendor_id;;
    }
    dimension: Artist{
      label:"Artist"
      type: string
      sql:${TABLE}.Artist;;
    }
    dimension: Title{
      label:"Title"
      type: string
      sql:${TABLE}.Title;;
    }
    dimension: Owner_name{
      label:"Owner_name"
      type: string
      sql:${TABLE}.Owner_name;;
    }
    dimension: Product_manager{
      label:"Product_manager"
      type: string
      sql:${TABLE}.Product_manager;;
    }
    measure: Shazams{
      label:"Shazams"
      type: sum
      sql:${TABLE}.Shazams;;
    }
  dimension_group: Activity_date{
    label:"Activity_date"
    type: time
    sql:${TABLE}.DOWNLOAD_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]

}
}