data.ml
LKML Saas experience management

Groups

Groups model for saas experience management.

inferred

Blocks

groups.view.lkml · 39 lines
inferred 
view: groups {
  sql_table_name: external_system._groups ;;

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, name, group_memberships.count, organizations.count, tickets.count]
  }
}
groups.view.lookml · 38 lines
source-preserved 
- view: groups
  sql_table_name: external_system._groups
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: deleted
    type: yesno
    sql: ${TABLE}.deleted
  - dimension: name
    sql: ${TABLE}.name
  - dimension: url
    sql: ${TABLE}.url
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - name
    - group_memberships.count
    - organizations.count
    - tickets.count

Contents

  • groups.view.lkml
  • groups.view.lookml