view: int_dbt_prod_first_access_analytics_reporting {
  sql_table_name: INTELLIGENCE.DBT_PROD.FIRST_ACCESS_7_DAYS_28_DAYS_ALL_TIME ;;

  dimension: primary_key {
    primary_key: yes
    hidden: yes
    description: "Primary Key"
    sql: concat(${TABLE}.artist_name, ${TABLE}.download_activity_date,
          ${TABLE}.label_name, ${TABLE}.labelid, ${TABLE}.track_name,
          ${TABLE}.transaction_group, ${TABLE}.units, ${TABLE}.spotify_vs_apple_vs_other__sort_,
          ${TABLE}.spotify_vs_apple_vs_youtube_vs_other, ${TABLE}.us_vs_uk_vs_row, ${TABLE}.us_vs_uk_vs_row__sort_) ;;
  }

  dimension_group: download_activity_date {
    view_label: "Date"
    label: "Activity"
    type: time
    sql: ${TABLE}.download_activity_date ;;
    description: "The date when activity occured"
    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: artist_name {
    type: string
    view_label: "Artist"
    label: "Artist Name"
    sql: ${TABLE}.artist_name ;;
  }

  dimension: labelid {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.labelid ;;
  }

  dimension: spotify_vs_apple_vs_youtube_vs_other {
    type: string
    view_label: "Store"
    label: "Spotify Vs Apple Vs YouTube Vs Other"
    sql: ${TABLE}.spotify_vs_apple_vs_youtube_vs_other;;
  }

  dimension: us_vs_uk_vs_row {
    type: string
    view_label: "Transaction Country"
    label: "US vs UK vs RoW"
    sql: ${TABLE}.us_vs_uk_vs_row;;
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    sql: ${TABLE}.label_name;;
  }

  dimension: track_name {
    type: string
    view_label: "Track"
    label: "Track Name"
    sql: ${TABLE}.track_name;;
  }

  dimension: transaction_group {
    type: string
    view_label: "Transaction Type"
    label: "Transaction Group"
    sql: ${TABLE}.transaction_group ;;
  }

  measure: units {
    type: sum
    view_label: "Metrics"
    label: "Units"
    sql: ${TABLE}.units ;;
  }

  }