data.ml
LKML Ecommerce mobile used

Customer

Customer model for ecommerce mobile used.

inferred

Blocks

customer.view.lkml · 73 lines
inferred 
view: customer {
  sql_table_name: CUSTOMR ;;

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

  dimension: address {
    sql: ${TABLE}.ADDRESS ;;
  }

  dimension: city {
    sql: ${TABLE}.CITY ;;
  }

  dimension: customercode {
    sql: ${TABLE}.CUSTOMERCODE ;;
  }

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

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

  dimension: gender {
    sql: ${TABLE}.GENDER ;;
  }

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

  dimension: middlename {
    sql: ${TABLE}.MIDDLENAME ;;
  }

  dimension: phonenumber {
    sql: ${TABLE}.PHONENUMBER ;;
  }

  dimension: postal {
    sql: ${TABLE}.POSTAL ;;
  }

  dimension: race {
    sql: ${TABLE}.RACE ;;
  }

  dimension: state {
    sql: ${TABLE}.STATE ;;
  }

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

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

  measure: count {
    type: count
  }
}
customer.view.lookml · 49 lines
source-preserved 
- view: customer
  sql_table_name: CUSTOMR
  fields:
  - dimension: pfxrecnum
    type: int
    primary_key: true
    sql: ${TABLE}.PFXRECNUM
  - dimension: address
    sql: ${TABLE}.ADDRESS
  - dimension: city
    sql: ${TABLE}.CITY
  - dimension: customercode
    sql: ${TABLE}.CUSTOMERCODE
  - dimension: email
    sql: ${TABLE}.EMAIL
  - dimension: firstname
    sql: ${TABLE}.FIRSTNAME
  - dimension: gender
    sql: ${TABLE}.GENDER
  - dimension: lastname
    sql: ${TABLE}.LASTNAME
  - dimension: middlename
    sql: ${TABLE}.MIDDLENAME
  - dimension: phonenumber
    sql: ${TABLE}.PHONENUMBER
  - dimension: postal
    sql: ${TABLE}.POSTAL
  - dimension: race
    sql: ${TABLE}.RACE
  - dimension: state
    sql: ${TABLE}.STATE
  - dimension_group: birthday
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.BIRTHDAY
  - dimension_group: lasttrxdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LASTTRXDATE
  - measure: count
    type: count

Contents

  • customer.view.lkml
  • customer.view.lookml