Customer Address

view: customer_address {
  sql_table_name: customer_address_entity ;;

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

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

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

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

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

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

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

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

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

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

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

  dimension: fax_number {
    sql: ${TABLE}.fax ;;
  }

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
  set: detail {
    fields: [address_id, customer_id, created_at, is_active, first_name, last_name, city, country_id, region, zipcode, phone_number, company, fax_number, region_id, street]
  }
}

- view: customer_address
  sql_table_name: customer_address_entity
  fields:
  - dimension: address_id
    type: int
    primary_key: true
    sql: ${TABLE}.entity_id
  - dimension: customer_id
    type: int
    sql: ${TABLE}.parent_id
  - dimension: is_active
    type: yesno
    sql: ${TABLE}.is_active
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: city
    sql: ${TABLE}.city
  - dimension: country_id
    sql: ${TABLE}.country_id
  - dimension: region
    sql: ${TABLE}.region
  - dimension: zipcode
    type: zipcode
    sql: ${TABLE}.zipcode
  - dimension: phone_number
    sql: ${TABLE}.phone_number
  - dimension: company
    sql: ${TABLE}.company
  - dimension: fax_number
    sql: ${TABLE}.fax
  - dimension: region_id
    type: int
    sql: ${TABLE}.region_id
  - dimension: street
    sql: ${TABLE}.street
  - dimension_group: created_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count
    drill_fields:
    - detail*