view: orch_app_ar_track_split {
  sql_table_name: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.TRACK_SPLIT ;;

  dimension: track_split_id{
    type: number
    sql: ${TABLE}.track_split_id ;;
    primary_key: yes
    hidden: yes
  }

  dimension: vendor_id {
    type: number
    sql: ${TABLE}.vendor_id ;;
    hidden: yes
  }

  dimension: isrc {
    type: string
    sql: ${TABLE}.isrc ;;
    hidden: yes
  }

  dimension: track_split_rate_rollback {
    type: number
    sql: ${TABLE}.track_split_rate_rollback ;;
    hidden: yes
  }

  dimension: track_unique_id {
    type: number
    sql: ${TABLE}.track_unique_id ;;
    hidden: yes
  }

  dimension: _fivetran_deleted {
    type:string
    sql: ${TABLE}._fivetran_deleted ;;
    hidden: yes
  }

  dimension: _fivetran_synced {
    type:date_time
    sql: ${TABLE}._fivetran_synced ;;
    hidden: yes
  }

  dimension: track_split {
    label: "Track Split Rate"
    type: number
    sql: ROUND(1-${TABLE}.track_split,2) ;;
    value_format: "0%"
  }

}