LKML Mobile ticketing

Event

Event model for mobile ticketing.

inferred

Blocks

LKML LookML

event.view.lkml · 95 lines

inferred

view: event {
  sql_table_name: game ;;

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

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

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

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

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

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

  dimension: ticket_system_event_id {
    hidden: yes
    sql: ${TABLE}.ticket_system_event_id ;;
  }

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

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

  dimension: estimated_capacity {
    hidden: yes
    sql: ${venue.avg_attendance} ;;
  }

  dimension: max_capacity {
    hidden: yes
    sql: ${venue.max_attendance} ;;
  }

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

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

  measure: average_estimated_capacity {
    type: avg
    sql: ${estimated_capacity} ;;
  }

  measure: average_max_capacity {
    type: avg
    sql: ${max_capacity} ;;
  }

  measure: total_estimated_capacity {
    type: sum
    sql: ${estimated_capacity} ;;
  }

  measure: total_max_capacity {
    type: sum
    sql: ${max_capacity} ;;
  }

  measure: count {
    type: count
  }
}

event.view.lookml · 67 lines

source-preserved

- view: event
  sql_table_name: game
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: active
    type: yesno
    sql: ${TABLE}.active
  - dimension: away_team
    sql: ${TABLE}.away_team
  - dimension: game_config_id
    type: int
    hidden: true
    sql: ${TABLE}.game_config_id
  - dimension: home_team_id
    type: int
    hidden: true
    sql: ${TABLE}.home_team_id
  - dimension: name
    sql: ${TABLE}.name
  - dimension: ticket_system_event_id
    hidden: true
    sql: ${TABLE}.ticket_system_event_id
  - dimension: timezone
    sql: ${TABLE}.timezone
  - dimension: venue_id
    type: int
    hidden: true
    sql: ${TABLE}.venue_id
  - dimension: estimated_capacity
    hidden: true
    sql: ${venue.avg_attendance}
  - dimension: max_capacity
    hidden: true
    sql: ${venue.max_attendance}
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_created
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.game_start_time
  - measure: average_estimated_capacity
    type: avg
    sql: ${estimated_capacity}
  - measure: average_max_capacity
    type: avg
    sql: ${max_capacity}
  - measure: total_estimated_capacity
    type: sum
    sql: ${estimated_capacity}
  - measure: total_max_capacity
    type: sum
    sql: ${max_capacity}
  - measure: count
    type: count

event.view.lkml
event.view.lookml

Event

Blocks

Contents