view: int_dbt_prod_apple_excluded_streams {
    sql_table_name:INTELLIGENCE.DBT_PROD.APPLE_EXCLUDED_STREAMS;;


    dimension: Apple_id{
      label:"Apple Id"
      view_label: "Track"
      description: "Apple ID for a track"
      type: number
      sql:${TABLE}.Apple_id;;
    }
    dimension: Subscription_type{
      label:"Subscription Type"
      view_label: "Subscription"
      description: "Exact name of the subscription plan held by the user"
      type: string
      sql:${TABLE}.Subscription_type;;
    }
    dimension: Country_code{
      label:"Country Code"
      view_label: "Transaction Country"
      description: "ISO Code for transaction country"
      type: string
      sql:${TABLE}.Country_code;;
    }
    dimension: Track_name{
      label:"Track Name"
      view_label: "Track"
      description: "Name of track reported by store"
      type: string
      sql:${TABLE}.Track_name;;
    }
    dimension: Artists{
      label:"Artists"
      view_label: "Artist"
      description: "Artist names reported by store"
      type: string
      sql:${TABLE}.Artists;;
    }
    dimension: Media_type{
      label:"Media_type"
      hidden: yes
      type: string
      sql:${TABLE}.Media_type;;
    }
    dimension: Isrc{
      label:"Isrc"
      view_label: "Track"
      description: "ISRC of track"
      type: string
      sql:${TABLE}.Isrc;;
    }
    dimension_group: Start_date{
      label:"Start"
      view_label: "Date"
      description: "First date for the month of report"
      type: time
      sql:${TABLE}.Start_date;;
      timeframes: [year,
        quarter,
        month,
        date
        ]
    }
    dimension_group: End_date{
      label:"End"
      view_label: "Date"
      description: "Last date for the month of report"
      type: time
      sql:${TABLE}.End_date;;
      timeframes: [year,
        quarter,
        month,
        date]
    }
    dimension_group: Report_date{
      label:"Report"
      view_label: "Date"
      description: "Month of the report"
      type: time
      sql:${TABLE}.Report_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: Upc{
      label:"Upc"
      view_label: "Release"
      description: "UPC of the release"
      type: string
      sql:${TABLE}.Upc;;
    }
    dimension: Label_id{
      label:"Label ID"
      view_label: "Label"
      description: "Label associated with the release"
      type: number
      sql:${TABLE}.Label_id;;
    }
    measure: Excluded_streams{
      label:"Excluded Streams"
      view_label: "Metrics"
      description: "Number of streams excluded from royalty for a given month"
      type: sum
      sql:${TABLE}.Excluded_streams;;
    }

  }