data.ml
LKML Car manufacture

Box Data

Box Data model for car manufacture.

inferred

Blocks

box_data.view.lkml · 67 lines
inferred 
view: box_data {
  sql_table_name: unite_db_stage.box_data ;;

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

  dimension: fuel_level {
    type: number
    sql: ${TABLE}.box_data_fuel_level ;;
  }

  dimension: ignition_on {
    type: yesno
    sql: ${TABLE}.box_data_ignition_on ;;
  }

  dimension: in_home_zone {
    type: yesno
    sql: ${TABLE}.box_data_in_home_zone ;;
  }

  dimension: latitude {
    type: number
    sql: ${TABLE}.box_data_lat ;;
  }

  dimension: longitude {
    type: number
    sql: ${TABLE}.box_data_long ;;
  }

  dimension: mileage {
    type: number
    sql: ${TABLE}.box_data_mileage ;;
  }

  dimension: pos_accuracy {
    type: int
    sql: ${TABLE}.box_data_pos_accuracy ;;
  }

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

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

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

  measure: count {
    type: count
    drill_fields: [box_data_id, car.car_id, box_data_has_usr.count, box_data_report.count]
  }
}
box_data.view.lookml · 55 lines
source-preserved 
- view: box_data
  sql_table_name: unite_db_stage.box_data
  fields:
  - dimension: box_data_id
    type: int
    primary_key: true
    sql: ${TABLE}.box_data_id
  - dimension: fuel_level
    type: number
    sql: ${TABLE}.box_data_fuel_level
  - dimension: ignition_on
    type: yesno
    sql: ${TABLE}.box_data_ignition_on
  - dimension: in_home_zone
    type: yesno
    sql: ${TABLE}.box_data_in_home_zone
  - dimension: latitude
    type: number
    sql: ${TABLE}.box_data_lat
  - dimension: longitude
    type: number
    sql: ${TABLE}.box_data_long
  - dimension: mileage
    type: number
    sql: ${TABLE}.box_data_mileage
  - dimension: pos_accuracy
    type: int
    sql: ${TABLE}.box_data_pos_accuracy
  - dimension: car_id
    type: int
    hidden: true
    sql: ${TABLE}.car_id
  - dimension_group: reception
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.box_data_reception_time
  - dimension_group: box_data
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.box_data_time
  - measure: count
    type: count
    drill_fields:
    - box_data_id
    - car.car_id
    - box_data_has_usr.count
    - box_data_report.count

Contents

  • box_data.view.lkml
  • box_data.view.lookml