data.ml
LKML Ecommerce furniture

Variants

Variants model for ecommerce furniture.

inferred

Blocks

variants.view.lkml · 85 lines
inferred 
view: variants {
  sql_table_name: bi_tables.variants ;;

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

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

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

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

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

  dimension: is_available {
    type: yesno
    sql: ${TABLE}.is_available = 1 ;;
  }

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
variants.view.lookml · 57 lines
source-preserved 
- view: variants
  sql_table_name: bi_tables.variants
  fields:
  - dimension: sku
    primary_key: true
    sql: ${TABLE}.sku
  - dimension: master_sku
    sql: ${TABLE}.master_sku
  - dimension: category
    sql: ${TABLE}.category
  - dimension: color
    sql: ${TABLE}.color
  - dimension: image_file
    sql: ${TABLE}.image_file
  - dimension: is_available
    type: yesno
    sql: ${TABLE}.is_available = 1
  - dimension: msrp
    type: number
    sql: ${TABLE}.msrp
  - dimension: name
    sql: ${TABLE}.name
  - dimension: num_available
    type: number
    sql: ${TABLE}.num_available
  - dimension: personality
    sql: ${TABLE}.personality
  - dimension: style
    sql: ${TABLE}.style
  - dimension: theme
    sql: ${TABLE}.theme
  - dimension: unit_cost
    type: number
    sql: ${TABLE}.unit_cost
  - dimension: unit_price
    type: number
    sql: ${TABLE}.unit_price
  - dimension: url
    sql: ${TABLE}.url
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • variants.view.lkml
  • variants.view.lookml