view: orch_app_ar_vendor_contract_change_history {
    sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_contract_change_history ;;

    dimension: change_id {
      primary_key: yes
      type: number
      sql: ${TABLE}.id ;;
    }

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

      dimension_group: date {
        label: "Changed"
        type: time
        sql: ${TABLE}.date_changed ;;
        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: oa_user_id{
      type: number
      hidden: yes
      sql: ${TABLE}.orchadmin_user_id ;;
    }


    dimension: change_detail {
      type: string
      sql: ${TABLE}.change_detail ;;
    }
  }