LookML Editor

About the tool

LookML is a language for describing dimensions, aggregates, calculations, and data relationships in a SQL database. It allows you to abstract SQL queries from the business logic and make them reusable across multiple reports and dashboards.

Demo

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
}

LookML Editor

About the tool

Demo

See also