data.ml
LookML Car manufacture

Booking

Booking model for car manufacture.

source-preserved

Blocks

booking.view.lkml · 57 lines
inferred 
view: booking {
  sql_table_name: unite_db_stage.booking ;;

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

  dimension: booking_creator_user_id {
    type: int
    sql: ${TABLE}.booking_creator_usr_id ;;
  }

  dimension: deleted {
    type: yesno
    sql: ${TABLE}.booking_deleted ;;
  }

  dimension: notes {
    sql: ${TABLE}.booking_notes ;;
  }

  dimension: pick_up {
    type: yesno
    sql: ${TABLE}.booking_pick_up ;;
  }

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

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

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

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

  measure: count {
    type: count
    drill_fields: [booking_id, car.car_id, booking_has_agent_booking_type.count, booking_has_user.count, customer_booking_drive_notification.count]
  }
}
booking.view.lookml · 54 lines
source-preserved 
- view: booking
  sql_table_name: unite_db_stage.booking
  fields:
  - dimension: booking_id
    type: int
    primary_key: true
    sql: ${TABLE}.booking_id
  - dimension: booking_creator_user_id
    type: int
    sql: ${TABLE}.booking_creator_usr_id
  - dimension: deleted
    type: yesno
    sql: ${TABLE}.booking_deleted
  - dimension: notes
    sql: ${TABLE}.booking_notes
  - dimension: pick_up
    type: yesno
    sql: ${TABLE}.booking_pick_up
  - dimension: car_id
    type: int
    hidden: true
    sql: ${TABLE}.car_id
  - dimension_group: booking_end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.booking_end_time
  - dimension_group: booking_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.booking_start_time
  - dimension_group: booking_update
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.booking_update_time
  - measure: count
    type: count
    drill_fields:
    - booking_id
    - car.car_id
    - booking_has_agent_booking_type.count
    - booking_has_user.count
    - customer_booking_drive_notification.count

Contents

  • booking.view.lkml
  • booking.view.lookml