data.ml
LKML Ecommerce fashion

Inventory Units

Inventory Units model for ecommerce fashion.

inferred

Blocks

inventory_units.view.lkml · 55 lines
inferred 
view: inventory_units {
  sql_table_name: store_inventory_units ;;

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

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

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

  dimension: pending {
    type: yesno
    sql: ${TABLE}.pending ;;
  }

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }
}
inventory_units.view.lookml · 46 lines
source-preserved 
- view: inventory_units
  sql_table_name: store_inventory_units
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: line_item_id
    type: int
    sql: ${TABLE}.line_item_id
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: pending
    type: yesno
    sql: ${TABLE}.pending
  - dimension: shipment_id
    type: int
    sql: ${TABLE}.shipment_id
  - dimension: state
    sql: ${TABLE}.state
  - dimension: variant_id
    type: int
    sql: ${TABLE}.variant_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id

Contents

  • inventory_units.view.lkml
  • inventory_units.view.lookml