view: int_dbt_prod_sub_genres {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."SUB_GENRES" ;;


  dimension: SUBGENRE {
    label: "Subgenre"
    type: string
    sql: ${TABLE}.SUB_GENRES ;;
  }
  dimension_group: DOWNLOAD_ACTIVITY_DATE {
    label: "Activity Date"
    description: "Activity date"
    type: time
    sql: ${TABLE}.DOWNLOAD_ACTIVITY_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: CORE_MARKETS {
    label: "CORE MARKETS"
    description: "Core Markets"
    type: string
    sql: ${TABLE}.CORE_MARKETS ;;
  }
  measure: STREAMS {
    label: "Streams"
    description: "Streams"
    type: sum
    sql: ${TABLE}.STREAMS ;;
  }

}