data.ml
LookML Ecommerce luxury consign

Addresses

Addresses model for ecommerce luxury consign.

source-preserved

Blocks

addresses.view.lkml · 44 lines
inferred 
view: addresses {
  sql_table_name: spree_addresses ;;

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

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

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

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

  dimension: name {
    sql: concat(${TABLE}.firstname, ' ', ${TABLE}.lastname) ;;
  }

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

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

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

  measure: count {
    type: count
  }
}
addresses.view.lookml · 26 lines
source-preserved 
- view: addresses
  sql_table_name: spree_addresses
  fields:
  - dimension: id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: address1
    sql: ${TABLE}.address1
  - dimension: address2
    sql: ${TABLE}.address2
  - dimension: city
    sql: ${TABLE}.city
  - dimension: name
    sql: concat(${TABLE}.firstname, ' ', ${TABLE}.lastname)
  - dimension: phone
    sql: ${TABLE}.phone
  - dimension: state_id
    type: int
    hidden: true
    sql: ${TABLE}.state_id
  - dimension: zipcode
    sql: ${TABLE}.zipcode
  - measure: count
    type: count

Contents

  • addresses.view.lkml
  • addresses.view.lookml