data.ml
LookML Social network sport

Address

Address model for social network sport.

source-preserved

Blocks

address.view.lkml · 112 lines
inferred 
view: address {
  sql_table_name: Address ;;

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

  dimension: address_type {
    type: yesno
    sql: ${TABLE}.AddressType ;;
  }

  dimension: administrative_level1 {
    sql: ${TABLE}.AdministrativeLevel1 ;;
  }

  dimension: administrative_level2 {
    sql: ${TABLE}.AdministrativeLevel2 ;;
  }

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

  dimension: country {
    sql: ${TABLE}.Country ;;
  }

  dimension: formatted_address {
    sql: ${TABLE}.FormattedAddress ;;
  }

  dimension: geo_point {
    sql: ${TABLE}.GeoPoint ;;
  }

  dimension: label {
    sql: ${TABLE}.Label ;;
  }

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

  dimension: locality {
    sql: ${TABLE}.Locality ;;
  }

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

  dimension: post_box {
    sql: ${TABLE}.PostBox ;;
  }

  dimension: postal_code {
    sql: ${TABLE}.PostalCode ;;
  }

  dimension: route {
    sql: ${TABLE}.Route ;;
  }

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

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

  dimension: street_number {
    sql: ${TABLE}.StreetNumber ;;
  }

  dimension: subpremise {
    sql: ${TABLE}.Subpremise ;;
  }

  dimension: time_zone_id {
    sql: ${TABLE}.TimeZoneId ;;
  }

  dimension: unformatted_address {
    sql: ${TABLE}.UnformattedAddress ;;
  }

  dimension: zip_code {
    sql: ${TABLE}.ZipCode ;;
  }

  dimension: has_address {
    type: yesno
    sql: ${address.address_id} IS NOT NULL ;;
  }

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
address.view.lookml · 67 lines
source-preserved 
- view: address
  sql_table_name: Address
  fields:
  - dimension: address_id
    type: int
    primary_key: true
    sql: ${TABLE}.AddressId
  - dimension: address_type
    type: yesno
    sql: ${TABLE}.AddressType
  - dimension: administrative_level1
    sql: ${TABLE}.AdministrativeLevel1
  - dimension: administrative_level2
    sql: ${TABLE}.AdministrativeLevel2
  - dimension: city
    sql: ${TABLE}.City
  - dimension: country
    sql: ${TABLE}.Country
  - dimension: formatted_address
    sql: ${TABLE}.FormattedAddress
  - dimension: geo_point
    sql: ${TABLE}.GeoPoint
  - dimension: label
    sql: ${TABLE}.Label
  - dimension: latitude
    type: number
    sql: ${TABLE}.Latitude
  - dimension: locality
    sql: ${TABLE}.Locality
  - dimension: longitude
    type: number
    sql: ${TABLE}.Longitude
  - dimension: post_box
    sql: ${TABLE}.PostBox
  - dimension: postal_code
    sql: ${TABLE}.PostalCode
  - dimension: route
    sql: ${TABLE}.Route
  - dimension: state
    sql: ${TABLE}.State
  - dimension: street
    sql: ${TABLE}.Street
  - dimension: street_number
    sql: ${TABLE}.StreetNumber
  - dimension: subpremise
    sql: ${TABLE}.Subpremise
  - dimension: time_zone_id
    sql: ${TABLE}.TimeZoneId
  - dimension: unformatted_address
    sql: ${TABLE}.UnformattedAddress
  - dimension: zip_code
    sql: ${TABLE}.ZipCode
  - dimension: has_address
    type: yesno
    sql: ${address.address_id} IS NOT NULL
  - dimension_group: last_geocode_date_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastGeocodeDateUtc
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • address.view.lkml
  • address.view.lookml