view: int_dbt_prod_weekly_no_of_new_releases {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."WEEKLY_NO_OF_NEW_RELEASES" ;;

  dimension: SERVICE_TIER_NAME {
    label: "Service Tier"
    description: "Service Tier Name"
    type: string
    sql: ${TABLE}.SERVICE_TIER_NAME ;;
  }
  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: COUNT_ISRC {
    label: "ISRC"
    description: "Number of ISRC"
    type: sum
    sql: ${TABLE}.COUNT_ISRC ;;
  }
}