data.ml
LookML Analytics marketing

Product

Product model for analytics marketing.

source-preserved

Blocks

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

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

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

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

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

  dimension: product_price {
    type: number
    sql: ${TABLE}.product_price ;;
  }

  dimension: product_shelf_life {
    type: number
    sql: ${TABLE}.product_shelf_life ;;
  }

  dimension: product_value {
    type: number
    sql: ${TABLE}.product_value ;;
  }

  dimension: product_volume {
    type: number
    sql: ${TABLE}.product_volume ;;
  }

  dimension: product_weight {
    type: number
    sql: ${TABLE}.product_weight ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
product.view.lookml · 32 lines
source-preserved 
- view: product
  sql_table_name: public.product
  fields:
  - dimension: sid
    type: int
    sql: ${TABLE}.sid
  - dimension: project_id
    type: int
    sql: ${TABLE}.project_id
  - dimension: product_description
    sql: ${TABLE}.product_description
  - dimension: product_name
    sql: ${TABLE}.product_name
  - dimension: product_price
    type: number
    sql: ${TABLE}.product_price
  - dimension: product_shelf_life
    type: number
    sql: ${TABLE}.product_shelf_life
  - dimension: product_value
    type: number
    sql: ${TABLE}.product_value
  - dimension: product_volume
    type: number
    sql: ${TABLE}.product_volume
  - dimension: product_weight
    type: number
    sql: ${TABLE}.product_weight
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • product.view.lkml
  • product.view.lookml