view: dbt_prod_spotify_top_200_predictions_weekly {
  sql_table_name: intelligence.dbt_prod.spotify_top_200_predictions_weekly ;; ##needs to be replaced with production table


  dimension: run_date {
    description: "The date on which the predictive model was run."
    type: date
    sql: ${TABLE}.run_date ;;
  }

  dimension: country_sample {
    description: "The country in which we predicted chart success/failure."
    type: string
    sql: ${TABLE}.country_sample ;;
  }

  dimension: isrc {
    description: "The ISRC for which we predicted chart success/failure."
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: release_date {
    description: "The ISRCs release date."
    type: string
    sql: ${TABLE}.release_date ;;
  }

  dimension: model_spec {
    description: "The specifications of the model used to predict chart success/failure."
    type: string
    sql: ${TABLE}.model_spec ;;
  }

  dimension: probability_of_failure {
    description: "The predicted probability that a track will not enter the chart."
    type: number
    # value_format: "##.##"
    sql: ${TABLE}.probability_of_failure ;;
  }

  dimension: probability_of_success {
    description: "The predicted probability that a track will enter the chart."
    type: number
    # value_format: "##.##"
    sql: ${TABLE}.probability_of_success ;;
  }

  dimension: prediction {
    description: "A binary predictions (1 or 0) based on the predicted probability of chart success or failure."
    type: number
    value_format: "#"
    sql: ${TABLE}.prediction ;;
  }

  dimension: first_charted_on {
    description: "The date that an ISRC first appeared on the the chart for the country sample."
    type: date
    sql: ${TABLE}.first_charted_on ;;
  }

  dimension: successfully_predicted{
    description: "The date that an ISRC first appeared on the the chart for the country sample."
    type: yesno
    sql: ${TABLE}.successfully_predicted ;;
  }

}