data.ml
LookML Agriculture wine

Stock Units

Stock Units model for agriculture wine.

source-preserved

Blocks

stock_units.view.lkml · 62 lines
inferred 
view: stock_units {
  sql_table_name: stock_units_table ;;

  dimension: convert {
    type: number
    sql: ${TABLE}.convert_ ;;
  }

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
stock_units.view.lookml · 36 lines
source-preserved 
- view: stock_units
  sql_table_name: stock_units_table
  fields:
  - dimension: convert
    type: number
    sql: ${TABLE}.convert_
  - dimension: frghtrate
    type: number
    sql: ${TABLE}.frghtrate
  - dimension: frghttype
    sql: ${TABLE}.frghttype
  - dimension: litres
    type: number
    sql: ${TABLE}.litres
  - dimension: mass
    type: number
    sql: ${TABLE}.mass
  - dimension: name
    sql: ${TABLE}.name
  - dimension: nonstock
    sql: ${TABLE}.nonstock
  - dimension: rec_id
    type: int
    sql: ${TABLE}.rec_id
  - dimension: recnbr
    type: number
    sql: ${TABLE}.recnbr
  - dimension: storerate
    type: number
    sql: ${TABLE}.storerate
  - dimension: unit
    sql: ${TABLE}.unit
  - dimension: unittype
    sql: ${TABLE}.unittype
  - measure: count
    type: count

Contents

  • stock_units.view.lkml
  • stock_units.view.lookml