data.ml
LookML Advertising technology

Geos

Geos model for advertising technology.

source-preserved

Blocks

geos.view.lkml · 73 lines
inferred 
view: geos {
  sql_table_name: public.dim_geos_0 ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [isp_name]
  }
}
geos.view.lookml · 44 lines
source-preserved 
- view: geos
  sql_table_name: public.dim_geos_0
  fields:
  - dimension: area_id
    type: int
    sql: ${TABLE}.area_id
  - dimension: area_id_edge
    sql: ${TABLE}.area_id_edge
  - dimension: city_id
    type: int
    sql: ${TABLE}.city_id
  - dimension: conn_speed
    sql: ${TABLE}.conn_speed
  - dimension: continent_id
    type: int
    sql: ${TABLE}.continent_id
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: country_name_shortcut
    sql: ${TABLE}.country_name_shortcut
  - dimension: dma_code
    type: int
    sql: ${TABLE}.dma_code
  - dimension: geo_id
    type: int
    sql: ${TABLE}.geo_id
  - dimension: ip_attributes_id
    type: int
    primary_key: true
    sql: ${TABLE}.ip_attributes_id
  - dimension: isp_name
    sql: ${TABLE}.isp_name
  - dimension: state_id
    type: int
    sql: ${TABLE}.state_id
  - dimension: state_name_shortcut
    sql: ${TABLE}.state_name_shortcut
  - dimension: zip_code
    sql: ${TABLE}.zip_code
  - measure: count
    type: count
    drill_fields:
    - isp_name

Contents

  • geos.view.lkml
  • geos.view.lookml