LookML Ecommerce fashion

Customers

Customers model for ecommerce fashion.

inferred

Blocks

LKML LookML

customers.view.lkml · 105 lines

source-preserved

view: customers {
  sql_table_name: customer_entity ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: cumulative_order_total {
    type: number
    sql: ${TABLE}.cumulative_order_total ;;
  }

  dimension: last_rewarded_total {
    type: number
    sql: ${TABLE}.last_rewarded_total ;;
  }

  dimension: age {
    type: int
    sql: DATEDIFF(CURDATE(), ${TABLE}.birth)/ 365 ;;
  }

  dimension: age_tier {
    type: tier
    sql: ${age} ;;
  }

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

  dimension_group: birth {
    type: time
    timeframes: [date]
    sql: ${TABLE}.birth ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
  set: detail {
    fields: [customer_id, website_id, email, group_id, store_id, created_at, is_active, created_in, first_name, last_name, billing_address_id, shipping_address_id, reward_points_notifications, gender, cumulative_order_total, last_rewarded_total, birth]
  }
}

customers.view.lookml · 68 lines

inferred

- view: customers
  sql_table_name: customer_entity
  fields:
  - dimension: customer_id
    type: int
    primary_key: true
    sql: ${TABLE}.entity_id
  - dimension: website_id
    type: int
    sql: ${TABLE}.website_id
  - dimension: email
    sql: ${TABLE}.email
  - dimension: group_id
    type: int
    sql: ${TABLE}.group_id
  - dimension: store_id
    type: int
    sql: ${TABLE}.store_id
  - dimension: is_active
    type: yesno
    sql: ${TABLE}.is_active
  - dimension: created_in
    sql: ${TABLE}.created_in
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: billing_address_id
    type: int
    hidden: true
    sql: ${TABLE}.billing_address_id
  - dimension: shipping_address_id
    type: int
    hidden: true
    sql: ${TABLE}.shipping_address_id
  - dimension: reward_points_notifications
    sql: ${TABLE}.reward_points_notifications
  - dimension: gender
    sql: ${TABLE}.gender
  - dimension: cumulative_order_total
    type: number
    sql: ${TABLE}.cumulative_order_total
  - dimension: last_rewarded_total
    type: number
    sql: ${TABLE}.last_rewarded_total
  - dimension: age
    type: int
    sql: DATEDIFF(CURDATE(), ${TABLE}.birth)/ 365
  - dimension: age_tier
    type: tier
    sql: ${age}
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: birth
    type: time
    timeframes:
    - date
    sql: ${TABLE}.birth
  - measure: count
    type: count
    drill_fields:
    - detail*

customers.view.lkml
customers.view.lookml

Customers

Blocks

Contents