view: int_dbt_prod_changes_by_source {
    sql_table_name: INTELLIGENCE.DBT_PROD.CHANGES_BY_SOURCE ;;

    dimension_group: activity_month {
      view_label: "Date"
      label: "Activity"
      type: time
      sql: ${TABLE}.activity_month ;;
      timeframes: [year,
        date,
        quarter,
        month,
        month_name,
        month_num,
        fiscal_month_num,
        fiscal_quarter,
        fiscal_quarter_of_year,
        fiscal_year]
    }

    dimension: store {
      view_label: "Store"
      label: "Store Name"
      type: string
      sql: ${TABLE}.store ;;
    }

    dimension: country_name {
      view_label: "Transaction Country"
      label: "Country Name"
      type: string
      sql: ${TABLE}.country_name ;;
    }

  dimension: artistname {
    view_label: "Artist"
    label: "Artist Name"
    type: string
    sql: ${TABLE}.artistname ;;
  }

    dimension: brand_name {
      view_label: "Orchard/AWAL Toggle"
      label: "Brand Name"
      type: string
      sql: ${TABLE}.brand_name ;;
    }

    dimension: service_tier_name {
      view_label: "Orchard/AWAL Toggle"
      label: "Service Tier Name"
      type: string
      sql: ${TABLE}.service_tier_name ;;
    }

    dimension: isrc {
      view_label: "Track"
      label: "ISRC"
      type: string
      sql: ${TABLE}.isrc ;;
    }

  dimension: source_of_stream {
    view_label: "Source"
    label: "Source of Stream"
    type: string
    sql: ${TABLE}.source_of_stream_normalized ;;
  }

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

    measure: streams {
      view_label: "Streams"
      label: "Streams"
      type: sum
      sql: ${TABLE}.streams ;;
    }


  }