customer_list.view.lookml

- view: customer_list
  fields:

  - dimension: id
    primary_key: true
    type: int
    sql: ${TABLE}.ID

  - dimension: address
    sql: ${TABLE}.address

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

  - dimension: country
    sql: ${TABLE}.country

  - dimension: name
    sql: ${TABLE}.name

  - dimension: notes
    sql: ${TABLE}.notes

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

  - dimension: sid
    type: yesno
    sql: ${TABLE}.SID

  - dimension: zip_code
    sql: ${TABLE}.`zip code`

  - measure: count
    type: count
    drill_fields: [id, name]