data.ml
LookML Manufacturing sanitary

Hospitality Guests

Hospitality Guests model for manufacturing sanitary.

source-preserved

Blocks

hospitality_guests.view.lkml · 120 lines
inferred 
view: hospitality_guests {
  sql_table_name: dwh.hospitality_guests ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [first_name, last_name, stayname]
  }
}
hospitality_guests.view.lookml · 65 lines
source-preserved 
- view: hospitality_guests
  sql_table_name: dwh.hospitality_guests
  fields:
  - dimension: address1
    sql: ${TABLE}.address1
  - dimension: address2
    sql: ${TABLE}.address2
  - dimension: arrival_date
    sql: ${TABLE}.arrival_date
  - dimension: city
    sql: ${TABLE}.city
  - dimension: company
    sql: ${TABLE}.company
  - dimension: country
    sql: ${TABLE}.country
  - dimension: departure_date
    sql: ${TABLE}.departure_date
  - dimension: email_address_
    sql: ${TABLE}.email_address_
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: golfrev
    sql: ${TABLE}.golfrev
  - dimension: guest_num
    sql: ${TABLE}.guest_num
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: leaddays
    sql: ${TABLE}.leaddays
  - dimension: mailable
    sql: ${TABLE}.mailable
  - dimension: mktseg
    sql: ${TABLE}.mktseg
  - dimension: numadults
    sql: ${TABLE}.numadults
  - dimension: numkids
    sql: ${TABLE}.numkids
  - dimension: otherrev
    sql: ${TABLE}.otherrev
  - dimension: property
    sql: ${TABLE}.property
  - dimension: rate_pkg
    sql: ${TABLE}.rate_pkg
  - dimension: rmtype
    sql: ${TABLE}.rmtype
  - dimension: roomrev
    sql: ${TABLE}.roomrev
  - dimension: sparev
    sql: ${TABLE}.sparev
  - dimension: state
    sql: ${TABLE}.state
  - dimension: stayname
    sql: ${TABLE}.stayname
  - dimension: taxgrat
    sql: ${TABLE}.taxgrat
  - dimension: totalrev
    sql: ${TABLE}.totalrev
  - dimension: zip_code
    sql: ${TABLE}.zip_code
  - measure: count
    type: count
    drill_fields:
    - first_name
    - last_name
    - stayname

Contents

  • hospitality_guests.view.lkml
  • hospitality_guests.view.lookml