data.ml
LKML Car manufacture

User

User model for car manufacture.

inferred

Blocks

user.view.lkml · 90 lines
inferred 
view: user {
  sql_table_name: unite_db_stage.usr ;;

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

  dimension: role_id {
    type: int
    hidden: yes
    sql: ${TABLE}.role_id ;;
  }

  dimension: user_amid {
    sql: ${TABLE}.usr_amid ;;
  }

  dimension: user_apn_device_token {
    sql: ${TABLE}.usr_apn_device_token ;;
  }

  dimension: user_img_id {
    type: int
    hidden: yes
    sql: ${TABLE}.usr_img_id ;;
  }

  dimension: invoice_detail_report {
    type: yesno
    sql: ${TABLE}.usr_invoice_detail_report ;;
  }

  dimension: notes {
    sql: ${TABLE}.usr_notes ;;
  }

  dimension: parktag_allowed {
    type: yesno
    sql: ${TABLE}.usr_parktag_allowed ;;
  }

  dimension: street_cleaning_allowed {
    type: yesno
    sql: ${TABLE}.usr_street_cleaning_allowed ;;
  }

  dimension: role {
    sql: ${role.role_name} ;;
  }

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: count_distinct_user {
    type: count_distinct
    sql: ${user_id} ;;
  }

  measure: average_users_per_circle {
    type: number
    sql: cast(${count_distinct_user} as float)/NULLIF(${circle.count},0) ;;
  }

  measure: last_successful_login {
    type: string
    sql: MAX(${TABLE}.usr_last_login) ;;
  }
}
user.view.lookml · 69 lines
source-preserved 
- view: user
  sql_table_name: unite_db_stage.usr
  fields:
  - dimension: user_id
    type: int
    primary_key: true
    sql: ${TABLE}.usr_id
  - dimension: role_id
    type: int
    hidden: true
    sql: ${TABLE}.role_id
  - dimension: user_amid
    sql: ${TABLE}.usr_amid
  - dimension: user_apn_device_token
    sql: ${TABLE}.usr_apn_device_token
  - dimension: user_img_id
    type: int
    hidden: true
    sql: ${TABLE}.usr_img_id
  - dimension: invoice_detail_report
    type: yesno
    sql: ${TABLE}.usr_invoice_detail_report
  - dimension: notes
    sql: ${TABLE}.usr_notes
  - dimension: parktag_allowed
    type: yesno
    sql: ${TABLE}.usr_parktag_allowed
  - dimension: street_cleaning_allowed
    type: yesno
    sql: ${TABLE}.usr_street_cleaning_allowed
  - dimension: role
    sql: ${role.role_name}
  - dimension_group: last_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.usr_last_login
  - dimension_group: refresh_token_expiration
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.usr_refresh_token_expiration_time
  - dimension_group: token_expiration
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.usr_token_expiration_time
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: count_distinct_user
    type: count_distinct
    sql: ${user_id}
  - measure: average_users_per_circle
    type: number
    sql: cast(${count_distinct_user} as float)/NULLIF(${circle.count},0)
  - measure: last_successful_login
    type: string
    sql: MAX(${TABLE}.usr_last_login)

Contents

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