Home › Resources & tools › LookML Editor

LookML Editor

A simple online editor for LookML code.

untitled.lkml — LookML Editor

view: customers {
  dimension: id {
    primary_key: yes
    type: number
    sql: ${TABLE}.id ;;
  }
  dimension: city {                    # field: customers.city
    sql: ${TABLE}.city ;;
  }
  dimension: state {                   # field: customers.state
    sql: ${TABLE}.state ;;
  }
  dimension: name {
    sql: CONCAT(${TABLE}.firstname, " ", ${TABLE}.lastname) ;;
  }
  measure: count {             # field: customers.count
    type: count                # creates a sql COUNT(*)
    drill_fields: [drill_set*] # fields to show when someone clicks 'CUSTOMERS Count'
  }
  set: drill_set {                     # set: customers.drill_set
    fields: [id, state, orders.count]  # list of fields to show when someone clicks 'CUSTOMERS Count'
  }
}1
view: customers {
2
  dimension: id {
3
    primary_key: yes
4
    type: number
5
    sql: ${TABLE}.id ;;
6
  }
7
  dimension: city {                    # field: customers.city
8
    sql: ${TABLE}.city ;;
9
  }
10
  dimension: state {                   # field: customers.state
11
    sql: ${TABLE}.state ;;
12
  }
13
  dimension: name {
14
    sql: CONCAT(${TABLE}.firstname, " ", ${TABLE}.lastname) ;;
15
  }
16
  measure: count {             # field: customers.count
17
    type: count                # creates a sql COUNT(*)
18
    drill_fields: [drill_set*] # fields to show when someone clicks 'CUSTOMERS Count'
19
  }
20
  set: drill_set {                     # set: customers.drill_set
21
    fields: [id, state, orders.count]  # list of fields to show when someone clicks 'CUSTOMERS Count'
22
  }
23
}

All prices listed are in United States Dollars (USD). Visual representations of products are intended for illustrative purposes. Actual products may exhibit variations in color, texture, or other characteristics inherent to the manufacturing process.