Catalog Product Flat

view: catalog_product_flat {
  sql_table_name: catalog_product_flat_1 ;;

  dimension: product_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.entity_id ;;
  }

  dimension: image {
    sql: ${TABLE}.image ;;
  }

  dimension: giftcard_type {
    type: number
    sql: ${TABLE}.giftcard_type ;;
  }

  dimension: has_options {
    type: number
    sql: ${TABLE}.has_options ;;
  }

  dimension: jewelry_type {
    sql: COALESCE(${TABLE}.jewelry_type_value, 'Unknown') ;;
  }

  dimension: minimal_price {
    type: number
    sql: ${TABLE}.minimal_price ;;
  }

  dimension: msrp {
    type: number
    sql: ${TABLE}.msrp ;;
  }

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

  dimension: price {
    type: number
    sql: ${TABLE}.price ;;
  }

  dimension: price_type {
    type: int
    sql: ${TABLE}.price_type ;;
  }

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

  dimension: return_type_code_value {
    sql: ${TABLE}.return_type_code_value ;;
  }

  dimension: shipment_type {
    type: int
    sql: ${TABLE}.shipment_type ;;
  }

  dimension: short_description_raw {
    hidden: yes
    sql: ${TABLE}.short_description ;;
  }

  dimension: short_description {
    sql: ${short_description_raw} ;;
  }

  dimension: sku {
    sql: ${TABLE}.sku ;;
  }

  dimension: sku_type {
    type: int
    sql: ${TABLE}.sku_type ;;
  }

  dimension: small_image {
    hidden: yes
    sql: ${TABLE}.small_image ;;
  }

  dimension: special_product_type {
    sql: ${TABLE}.special_product_type_value ;;
  }

  dimension: thumbnail {
    hidden: yes
    sql: ${TABLE}.thumbnail ;;
  }

  dimension: type_id {
    sql: ${TABLE}.type_id ;;
  }

  dimension: url_path {
    hidden: yes
    sql: ${TABLE}.url_path ;;
  }

  dimension: weight {
    type: number
    sql: ${TABLE}.weight ;;
  }

  dimension: weight_type {
    type: int
    sql: ${TABLE}.weight_type ;;
  }

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

  measure: count {
    type: count
  }
}

- view: catalog_product_flat
  sql_table_name: catalog_product_flat_1
  fields:
  - dimension: product_id
    type: int
    primary_key: true
    sql: ${TABLE}.entity_id
  - dimension: image
    sql: ${TABLE}.image
  - dimension: giftcard_type
    type: number
    sql: ${TABLE}.giftcard_type
  - dimension: has_options
    type: number
    sql: ${TABLE}.has_options
  - dimension: jewelry_type
    sql: COALESCE(${TABLE}.jewelry_type_value, 'Unknown')
  - dimension: minimal_price
    type: number
    sql: ${TABLE}.minimal_price
  - dimension: msrp
    type: number
    sql: ${TABLE}.msrp
  - dimension: name
    sql: ${TABLE}.name
  - dimension: price
    type: number
    sql: ${TABLE}.price
  - dimension: price_type
    type: int
    sql: ${TABLE}.price_type
  - dimension: return_type_code
    type: int
    hidden: true
    sql: ${TABLE}.return_type_code
  - dimension: return_type_code_value
    sql: ${TABLE}.return_type_code_value
  - dimension: shipment_type
    type: int
    sql: ${TABLE}.shipment_type
  - dimension: short_description_raw
    hidden: true
    sql: ${TABLE}.short_description
  - dimension: short_description
    sql: ${short_description_raw}
  - dimension: sku
    sql: ${TABLE}.sku
  - dimension: sku_type
    type: int
    sql: ${TABLE}.sku_type
  - dimension: small_image
    hidden: true
    sql: ${TABLE}.small_image
  - dimension: special_product_type
    sql: ${TABLE}.special_product_type_value
  - dimension: thumbnail
    hidden: true
    sql: ${TABLE}.thumbnail
  - dimension: type_id
    sql: ${TABLE}.type_id
  - dimension: url_path
    hidden: true
    sql: ${TABLE}.url_path
  - dimension: weight
    type: number
    sql: ${TABLE}.weight
  - dimension: weight_type
    type: int
    sql: ${TABLE}.weight_type
  - dimension_group: created
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count