data.ml
LookML Developer apps

User

User model for developer apps.

source-preserved

Blocks

user.view.lkml · 88 lines
inferred 
view: user {
  sql_table_name: accounts."user" ;;

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

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

  dimension: disabled_reason {
    type: int
    sql: ${TABLE}.disabled_reason ;;
  }

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

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

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

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

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

  dimension: role {
    type: int
    sql: ${TABLE}.role ;;
  }

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

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

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

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

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

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

  measure: count {
    type: count
  }

  measure: user_per_org {
    type: number
    sql: ${count}/NULLIF(${organization.count},0) ;;
  }
}
user.view.lookml · 78 lines
source-preserved 
- view: user
  sql_table_name: 'accounts."user"'
  fields:
  - dimension: psk
    type: int
    primary_key: true
    sql: ${TABLE}.psk
  - dimension: id
    sql: ${TABLE}.id
  - dimension: disabled_reason
    type: int
    sql: ${TABLE}.disabled_reason
  - dimension: email
    sql: ${TABLE}.email
  - dimension: firstname
    sql: ${TABLE}.firstname
  - dimension: lastname
    sql: ${TABLE}.lastname
  - dimension: mobilephone
    sql: ${TABLE}.mobilephone
  - dimension: password
    sql: ${TABLE}.password
  - dimension: role
    type: int
    sql: ${TABLE}.role
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.deleted
  - dimension_group: last_login_from_catalog
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_login_from_catalog
  - dimension_group: lastlogin
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.lastlogin
  - dimension_group: modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.modified
  - dimension_group: until
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.until
  - measure: count
    type: count
  - measure: user_per_org
    type: number
    sql: ${count}/NULLIF(${organization.count},0)

Contents

  • user.view.lkml
  • user.view.lookml