demolook/inventory.view.lkml at master · lderezinski/demolook · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
view: inventory {
  sql_table_name: capacity.inventory ;;

  dimension: az {
    description: "Name of the avalibility zone"
    type: string
    sql: ${TABLE}."AZ" ;;
  }

  dimension: build {
    description: "Build number"
    type: string
    sql: ${TABLE}."Build" ;;
  }

  dimension: region {
    description: "Name of the region"
    type: string
    sql: ${TABLE}."Region" ;;
  }

  dimension: sku {
    description: "Sku of the computer"
    type: string
    sql: ${TABLE}."Sku" ;;
  }

  dimension: total_nodes {
    description: "number of nodes"
    type: number
    sql: ${TABLE}."TotalNodes" ;;
  }

  measure: count {
    description: "Number of distinct objects returned in query"
    type: count
    drill_fields: []
  }
  measure: sum_nodes {
    description: "sum of total nodes"
    type: sum
    sql: ${total_nodes} ;;
  }
}