data.ml
LookML Analytics marketing

Facility

Facility model for analytics marketing.

source-preserved

Blocks

facility.view.lkml · 58 lines
inferred 
view: facility {
  sql_table_name: public.facility ;;

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

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

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

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

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

  dimension: facility_latitude {
    type: number
    hidden: yes
    sql: ${TABLE}.facility_latitude ;;
  }

  dimension: facility_longitude {
    type: number
    hidden: yes
    sql: ${TABLE}.facility_longitude ;;
  }

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

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

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

  dimension: facility_location {
    type: location
  }

  measure: count {
    type: count
    drill_fields: [facility_name, project.project_id, project.project_name]
  }
}
facility.view.lookml · 37 lines
source-preserved 
- view: facility
  sql_table_name: public.facility
  fields:
  - dimension: project_id
    type: int
    sql: ${TABLE}.project_id
  - dimension: sid
    type: int
    sql: ${TABLE}.sid
  - dimension: facility_address
    sql: ${TABLE}.facility_address
  - dimension: facility_city
    sql: ${TABLE}.facility_city
  - dimension: facility_country
    sql: ${TABLE}.facility_country
  - dimension: facility_latitude
    type: number
    hidden: true
    sql: ${TABLE}.facility_latitude
  - dimension: facility_longitude
    type: number
    hidden: true
    sql: ${TABLE}.facility_longitude
  - dimension: facility_name
    sql: ${TABLE}.facility_name
  - dimension: facility_postal
    sql: ${TABLE}.facility_postal
  - dimension: facility_state
    sql: ${TABLE}.facility_state
  - dimension: facility_location
    type: location
  - measure: count
    type: count
    drill_fields:
    - facility_name
    - project.project_id
    - project.project_name

Contents

  • facility.view.lkml
  • facility.view.lookml