Skus

view: skus {
  sql_table_name: PRODUCT_SKUS ;;

  dimension: class_full_name {
    sql: ${TABLE}.CLASS_FULL_NAME ;;
  }

  dimension: class_inactive {
    type: int
    sql: ${TABLE}.CLASS_INACTIVE ;;
  }

  dimension: class_name {
    sql: ${TABLE}.CLASS_NAME ;;
  }

  dimension: color {
    sql: ${TABLE}.COLOR ;;
  }

  dimension: default_lens_id {
    type: int
    sql: ${TABLE}.DEFAULT_LENS_ID ;;
  }

  dimension: displayname {
    sql: ${TABLE}.DISPLAYNAME ;;
  }

  dimension: featureddescription {
    sql: ${TABLE}.FEATUREDDESCRIPTION ;;
  }

  dimension: fittingbox_sku {
    sql: ${TABLE}.FITTINGBOX_SKU ;;
  }

  dimension: frame_style_id {
    type: int
    hidden: yes
    sql: ${TABLE}.FRAME_STYLE_ID ;;
  }

  dimension: full_name {
    sql: ${TABLE}.FULL_NAME ;;
  }

  dimension: gender {
    sql: ${TABLE}.GENDER ;;
  }

  dimension: is_discontinued {
    type: int
    sql: ${TABLE}.IS_DISCONTINUED ;;
  }

  dimension: is_inactive {
    type: int
    sql: ${TABLE}.IS_INACTIVE ;;
  }

  dimension: is_online {
    type: int
    sql: ${TABLE}.IS_ONLINE ;;
  }

  dimension: item_id {
    type: int
    sql: ${TABLE}.ITEM_ID ;;
  }

  dimension: item_sku {
    sql: ${TABLE}.ITEM_SKU ;;
  }

  dimension: item_type {
    sql: ${TABLE}.ITEM_TYPE ;;
  }

  dimension: name {
    sql: ${TABLE}.NAME ;;
  }

  dimension: old_format_sku {
    sql: ${TABLE}.OLD_FORMAT_SKU ;;
  }

  dimension: sales_price {
    sql: ${TABLE}.SALESPRICE ;;
  }

  dimension: sanitized_item_sku {
    sql: ${TABLE}.SANITIZED_ITEM_SKU ;;
  }

  dimension: store_description {
    sql: ${TABLE}.STOREDESCRIPTION ;;
  }

  dimension: store_detailed_description {
    sql: ${TABLE}.STOREDETAILEDDESCRIPTION ;;
  }

  dimension: store_display_name {
    sql: ${TABLE}.STOREDISPLAYNAME ;;
  }

  dimension: style_color {
    sql: ${TABLE}.STYLE_COLOR ;;
  }

  dimension: type_name {
    sql: ${TABLE}.TYPE_NAME ;;
  }

  dimension: upc_code {
    sql: ${TABLE}.UPC_CODE ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.CREATED ;;
  }

  measure: count {
    type: count
  }
}

- view: skus
  sql_table_name: PRODUCT_SKUS
  fields:
  - dimension: class_full_name
    sql: ${TABLE}.CLASS_FULL_NAME
  - dimension: class_inactive
    type: int
    sql: ${TABLE}.CLASS_INACTIVE
  - dimension: class_name
    sql: ${TABLE}.CLASS_NAME
  - dimension: color
    sql: ${TABLE}.COLOR
  - dimension: default_lens_id
    type: int
    sql: ${TABLE}.DEFAULT_LENS_ID
  - dimension: displayname
    sql: ${TABLE}.DISPLAYNAME
  - dimension: featureddescription
    sql: ${TABLE}.FEATUREDDESCRIPTION
  - dimension: fittingbox_sku
    sql: ${TABLE}.FITTINGBOX_SKU
  - dimension: frame_style_id
    type: int
    hidden: true
    sql: ${TABLE}.FRAME_STYLE_ID
  - dimension: full_name
    sql: ${TABLE}.FULL_NAME
  - dimension: gender
    sql: ${TABLE}.GENDER
  - dimension: is_discontinued
    type: int
    sql: ${TABLE}.IS_DISCONTINUED
  - dimension: is_inactive
    type: int
    sql: ${TABLE}.IS_INACTIVE
  - dimension: is_online
    type: int
    sql: ${TABLE}.IS_ONLINE
  - dimension: item_id
    type: int
    sql: ${TABLE}.ITEM_ID
  - dimension: item_sku
    sql: ${TABLE}.ITEM_SKU
  - dimension: item_type
    sql: ${TABLE}.ITEM_TYPE
  - dimension: name
    sql: ${TABLE}.NAME
  - dimension: old_format_sku
    sql: ${TABLE}.OLD_FORMAT_SKU
  - dimension: sales_price
    sql: ${TABLE}.SALESPRICE
  - dimension: sanitized_item_sku
    sql: ${TABLE}.SANITIZED_ITEM_SKU
  - dimension: store_description
    sql: ${TABLE}.STOREDESCRIPTION
  - dimension: store_detailed_description
    sql: ${TABLE}.STOREDETAILEDDESCRIPTION
  - dimension: store_display_name
    sql: ${TABLE}.STOREDISPLAYNAME
  - dimension: style_color
    sql: ${TABLE}.STYLE_COLOR
  - dimension: type_name
    sql: ${TABLE}.TYPE_NAME
  - dimension: upc_code
    sql: ${TABLE}.UPC_CODE
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CREATED
  - measure: count
    type: count