D2 Stores

view: d2_stores {
  sql_table_name: dashboard.d2_stores ;;

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

  dimension: active {
    type: number
    sql: ${TABLE}.active ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: lat_long_computed {
    type: number
    sql: ${TABLE}.lat_long_computed ;;
  }

  dimension: latitude {
    type: number
    sql: ${TABLE}.latitude ;;
  }

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

  dimension: longitude {
    type: number
    sql: ${TABLE}.longitude ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, brand_name, partner_name, client_name, name]
  }
}

- view: d2_stores
  sql_table_name: dashboard.d2_stores
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: active
    type: number
    sql: ${TABLE}.active
  - dimension: address
    sql: ${TABLE}.address
  - dimension: address2
    sql: ${TABLE}.address2
  - dimension: attribute_1_value
    sql: ${TABLE}.attribute_1_value
  - dimension: attribute_2_value
    sql: ${TABLE}.attribute_2_value
  - dimension: attribute_3_value
    sql: ${TABLE}.attribute_3_value
  - dimension: attribute_4_value
    sql: ${TABLE}.attribute_4_value
  - dimension: attribute_5_value
    sql: ${TABLE}.attribute_5_value
  - dimension: attribute_6_value
    sql: ${TABLE}.attribute_6_value
  - dimension: attribute_7_value
    sql: ${TABLE}.attribute_7_value
  - dimension: attribute_8_value
    sql: ${TABLE}.attribute_8_value
  - dimension: brand_description
    sql: ${TABLE}.brand_description
  - dimension: brand_name
    sql: ${TABLE}.brand_name
  - dimension: city
    sql: ${TABLE}.city
  - dimension: client_name
    sql: ${TABLE}.client_name
  - dimension: client_supplied_id
    sql: ${TABLE}.client_supplied_id
  - dimension: contact_1_email
    sql: ${TABLE}.contact_1_email
  - dimension: contact_2_email
    sql: ${TABLE}.contact_2_email
  - dimension: contact_3_email
    sql: ${TABLE}.contact_3_email
  - dimension: country_code
    sql: ${TABLE}.country_code
  - dimension: description
    sql: ${TABLE}.description
  - dimension: fax
    sql: ${TABLE}.fax
  - dimension: hierarchy_1
    sql: ${TABLE}.hierarchy_1
  - dimension: hierarchy_2
    sql: ${TABLE}.hierarchy_2
  - dimension: hierarchy_3
    sql: ${TABLE}.hierarchy_3
  - dimension: hierarchy_4
    sql: ${TABLE}.hierarchy_4
  - dimension: hierarchy_5
    sql: ${TABLE}.hierarchy_5
  - dimension: hierarchy_6
    sql: ${TABLE}.hierarchy_6
  - dimension: hierarchy_7
    sql: ${TABLE}.hierarchy_7
  - dimension: hierarchy_8
    sql: ${TABLE}.hierarchy_8
  - dimension: immutable_key
    type: int
    sql: ${TABLE}.immutable_key
  - dimension: last_updated_by
    sql: ${TABLE}.last_updated_by
  - dimension: lat_long_computed
    type: number
    sql: ${TABLE}.lat_long_computed
  - dimension: latitude
    type: number
    sql: ${TABLE}.latitude
  - dimension: location_type
    sql: ${TABLE}.location_type
  - dimension: longitude
    type: number
    sql: ${TABLE}.longitude
  - dimension: metric_key
    sql: ${TABLE}.metric_key
  - dimension: msa
    sql: ${TABLE}.msa
  - dimension: name
    sql: ${TABLE}.name
  - dimension: partner_name
    sql: ${TABLE}.partner_name
  - dimension: phone
    sql: ${TABLE}.phone
  - dimension: state
    sql: ${TABLE}.state
  - dimension: store_code
    sql: ${TABLE}.store_code
  - dimension: store_type
    sql: ${TABLE}.store_type
  - dimension: time_zone
    sql: ${TABLE}.time_zone
  - dimension: zipcode
    sql: ${TABLE}.zipcode
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - brand_name
    - partner_name
    - client_name
    - name