data.ml
LookML Analytics shopping

Device Manufacturers

Device Manufacturers model for analytics shopping.

source-preserved

Blocks

device_manufacturers.view.lkml · 35 lines
inferred 
view: device_manufacturers {
  sql_table_name: public.device_manufacturers ;;

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [logical_name, company_name]
  }
}
device_manufacturers.view.lookml · 27 lines
source-preserved 
- view: device_manufacturers
  sql_table_name: public.device_manufacturers
  fields:
  - dimension: company_name
    sql: ${TABLE}.company_name
  - dimension: logical_group
    sql: ${TABLE}.logical_group
  - dimension: logical_name
    sql: ${TABLE}.logical_name
  - dimension: manufacturer_id
    type: int
    sql: ${TABLE}.manufacturer_id
  - dimension: oui
    sql: ${TABLE}.oui
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created
  - measure: count
    type: count
    drill_fields:
    - logical_name
    - company_name

Contents

  • device_manufacturers.view.lkml
  • device_manufacturers.view.lookml