view: int_dbt_prod_awal_tier_groups {
  sql_table_name: INTELLIGENCE.DBT_PROD.AWAL_TIER_GROUPS ;;

  dimension: parent_company {
    type: string
    sql: ${TABLE}.parent_company ;;
    description: "Parent Company of the Brand that the label belongs to. (SME or Orchard)"
  }

  dimension: brand_name {
    type: string
    sql: ${TABLE}.brand_name ;;
    description: "Name of the company to which the label belongs. Can be awal, orchard, sme"
  }

  dimension: service_tier_name {
    type: string
    sql: ${TABLE}.service_tier_name ;;
    description: "Client tier the label falls into as per the awal tiers. (Values are null for Orchard brands)"
  }

  dimension: label_id {
    type: number
    sql: ${TABLE}.labelid ;;
    description: "Label ID"
    primary_key: yes
  }

  dimension: label_name {
    type: string
    sql: ${TABLE}.labelname ;;
    description: "Label/Client Name"
  }

  dimension: priority {
    type: string
    sql: ${TABLE}.priority ;;
    description: "Label/Client priority indicator by number"
  }

  dimension: country_id {
    type: number
    sql: ${TABLE}.countryid ;;
    hidden: yes
    description: "Label Country ID"
  }

  dimension: owner {
    type: string
    sql: ${TABLE}.owner ;;
    description: "Client/Label Owner"
  }

  dimension: last_updated {
    type: date
    sql: ${TABLE}.last_updated ;;
    description: "Last Updated Date"
  }

  dimension: date_created {
    type: date
    sql: ${TABLE}.date_created ;;
    description: "Created Date"
  }

  dimension: is_distributor {
    type: string
    sql: ${TABLE}.isdistributor ;;
    description: "Y/N indicator of whether Label/Client is a distributor (D3)"
  }

  dimension: ownerid {
    type: number
    sql: ${TABLE}.ownerid ;;
    description: "Owner ID"
    hidden: yes
  }

  dimension: brandid {
    type: string
    sql: ${TABLE}.brandid ;;
    description: "Brand ID"
    hidden: yes
  }

  dimension: service_tier_id {
    type: string
    sql: ${TABLE}.servicetierid ;;
    description: "Service Tier ID"
    hidden: yes
  }

  dimension: is_deleted {
    type: string
    sql: ${TABLE}.is_deleted ;;
    description: "Y/N indicator if Label/Client is deleted"
  }

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