data.ml
LookML Advertising technology

Location

Location model for advertising technology.

source-preserved

Blocks

location.view.lkml · 51 lines
inferred 
view: location {
  sql_table_name: public.dim_geos1 ;;

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [city_name, country_name, state_name, dma_name]
  }
}
location.view.lookml · 35 lines
source-preserved 
- view: location
  sql_table_name: public.dim_geos1
  fields:
  - dimension: city_id
    type: int
    sql: ${TABLE}.city_id
  - dimension: city_name
    sql: ${TABLE}.city_name
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: country_name
    sql: ${TABLE}.country_name
  - dimension: dma_code
    type: int
    sql: ${TABLE}.dma_code
  - dimension: dma_name
    sql: ${TABLE}.dma_name
  - dimension: geo_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.geo_id
  - dimension: state_id
    type: int
    sql: ${TABLE}.state_id
  - dimension: state_name
    sql: ${TABLE}.state_name
  - measure: count
    type: count
    drill_fields:
    - city_name
    - country_name
    - state_name
    - dma_name

Contents

  • location.view.lkml
  • location.view.lookml