data.ml
LookML Ecommerce

Spree Products

Spree Products model for ecommerce.

source-preserved

Blocks

spree_products.view.lkml · 98 lines
inferred 
view: spree_products {
  sql_table_name: storefront.spree_products ;;

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

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

  dimension: description {
    type: string
    sql: ${TABLE}.description ;;
  }

  dimension: meta_description {
    type: string
    sql: ${TABLE}.meta_description ;;
  }

  dimension: meta_keywords {
    type: string
    sql: ${TABLE}.meta_keywords ;;
  }

  dimension: meta_title {
    type: string
    sql: ${TABLE}.meta_title ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: promotionable {
    type: yesno
    sql: ${TABLE}.promotionable ;;
  }

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

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

  dimension: slug {
    type: string
    sql: ${TABLE}.slug ;;
  }

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

  dimension: user_visible {
    type: yesno
    sql: ${TABLE}.user_visible ;;
  }

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, name]
  }
}
spree_products.view.lookml · 80 lines
source-preserved 
- view: spree_products
  sql_table_name: storefront.spree_products
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: avg_rating
    type: number
    sql: ${TABLE}.avg_rating
  - dimension: description
    type: string
    sql: ${TABLE}.description
  - dimension: meta_description
    type: string
    sql: ${TABLE}.meta_description
  - dimension: meta_keywords
    type: string
    sql: ${TABLE}.meta_keywords
  - dimension: meta_title
    type: string
    sql: ${TABLE}.meta_title
  - dimension: name
    type: string
    sql: ${TABLE}.name
  - dimension: promotionable
    type: yesno
    sql: ${TABLE}.promotionable
  - dimension: reviews_count
    type: int
    sql: ${TABLE}.reviews_count
  - dimension: shipping_category_id
    type: int
    sql: ${TABLE}.shipping_category_id
  - dimension: slug
    type: string
    sql: ${TABLE}.slug
  - dimension: tax_category_id
    type: int
    sql: ${TABLE}.tax_category_id
  - dimension: user_visible
    type: yesno
    sql: ${TABLE}.user_visible
  - dimension_group: available
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.available_on
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.deleted_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - name

Contents

  • spree_products.view.lkml
  • spree_products.view.lookml