view: focus_track {
  sql_table_name: ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.FOCUS_TRACK ;;

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

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

  dimension: is_focus_track {
    type: yesno
    sql: ${focus_track.unique_track_id} IS NOT NULL ;;
    description: "Indicates whether this track is a focus track"
  }

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

  dimension: start_date {
    type: date
    sql: ${TABLE}.start_date ;;
    hidden: yes
  }

  dimension: end_date {
    type: date
    sql: ${TABLE}.end_date ;;
    hidden: yes
  }

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

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

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

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

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

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

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

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