data.ml
LKML Ecommerce eyewear

Customers

Customers model for ecommerce eyewear.

inferred

Blocks

customers.view.lkml · 95 lines
inferred 
view: customers {
  sql_table_name: CUSTOMERS ;;

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

  dimension: is_inactive {
    type: yesno
    sql: ${TABLE}.IS_INACTIVE = 1 ;;
  }

  dimension: is_person {
    type: yesno
    sql: ${TABLE}.IS_PERSON = 1 ;;
  }

  dimension: magento_id {
    type: int
    sql: ${TABLE}.EXTERNAL_ID ;;
  }

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

  dimension: sales_channel_id {
    type: int
    sql: ${TABLE}.SALES_CHANNEL_ID ;;
  }

  dimension: unbilled_orders {
    type: number
    sql: ${TABLE}.UNBILLED_ORDERS ;;
  }

  dimension: purchase_history {
    sql: ${customer_id} ;;
  }

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

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

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

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

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

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

  dimension_group: first_hto_shipped {
    label: "First HTO Shipped"
    type: time
    timeframes: [date, month]
    sql: ${TABLE}.FIRST_HTO_SHIPPED ;;
  }

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

  measure: count {
    type: count
  }
}
customers.view.lookml · 79 lines
source-preserved 
- view: customers
  sql_table_name: CUSTOMERS
  fields:
  - dimension: customer_id
    type: int
    primary_key: true
    sql: ${TABLE}.CUSTOMER_ID
  - dimension: is_inactive
    type: yesno
    sql: ${TABLE}.IS_INACTIVE = 1
  - dimension: is_person
    type: yesno
    sql: ${TABLE}.IS_PERSON = 1
  - dimension: magento_id
    type: int
    sql: ${TABLE}.EXTERNAL_ID
  - dimension: name
    sql: ${TABLE}.NAME
  - dimension: sales_channel_id
    type: int
    sql: ${TABLE}.SALES_CHANNEL_ID
  - dimension: unbilled_orders
    type: number
    sql: ${TABLE}.UNBILLED_ORDERS
  - dimension: purchase_history
    sql: ${customer_id}
  - dimension_group: created
    type: time
    timeframes:
    - date
    - week
    - month
    - month_num
    - year
    sql: ${TABLE}.CREATE_DATE
  - dimension_group: closed
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.DATE_CLOSED
  - dimension_group: first_order
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.DATE_FIRST_ORDER
  - dimension_group: first_sale
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.DATE_FIRST_SALE
  - dimension_group: last_order
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.DATE_LAST_ORDER
  - dimension_group: last_sale
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.DATE_LAST_SALE
  - dimension_group: first_hto_shipped
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.FIRST_HTO_SHIPPED
  - dimension_group: last_standard_order_placed
    type: time
    timeframes:
    - date
    - month
    sql: ${TABLE}.LAST_STANDARD_ORDER_PLACED
  - measure: count
    type: count

Contents

  • customers.view.lkml
  • customers.view.lookml