data.ml
LookML Ecommerce mattresses

Customer Documents

Customer Documents model for ecommerce mattresses.

source-preserved

Blocks

customer_documents.view.lkml · 35 lines
inferred 
view: customer_documents {
  sql_table_name: Customer_Documents ;;

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

  dimension: action {
    sql: ${TABLE}.Action ;;
  }

  dimension: customer_id {
    type: int
    sql: ${TABLE}.Customer_Id ;;
  }

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

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

  dimension: type {
    sql: ${TABLE}.Type ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
customer_documents.view.lookml · 22 lines
source-preserved 
- view: customer_documents
  sql_table_name: Customer_Documents
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: action
    sql: ${TABLE}.Action
  - dimension: customer_id
    type: int
    sql: ${TABLE}.Customer_Id
  - dimension: email
    sql: ${TABLE}.Email
  - dimension: name
    sql: ${TABLE}.Name
  - dimension: type
    sql: ${TABLE}.Type
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • customer_documents.view.lkml
  • customer_documents.view.lookml