data.ml
LookML Social shopping

Stores

Stores model for social shopping.

source-preserved

Blocks

stores.view.lkml · 103 lines
inferred 
view: stores {
  sql_table_name: public.stores ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: count_distinct {
    type: count_distinct
    sql: ${TABLE}.id ;;
  }
}
stores.view.lookml · 70 lines
source-preserved 
- view: stores
  sql_table_name: public.stores
  fields:
  - dimension: parent_store_id
    type: int
    sql: ${TABLE}.parent_store_id
  - dimension: active_products_count
    type: int
    sql: ${TABLE}.active_products_count
  - dimension: avatar
    sql: ${TABLE}.avatar
  - dimension: category_id
    type: int
    sql: ${TABLE}.category_id
  - dimension: checkout_type
    sql: ${TABLE}.checkout_type
  - dimension: display_name
    sql: ${TABLE}.display_name
  - dimension: domain
    sql: ${TABLE}.domain
  - dimension: followers_count
    type: int
    sql: ${TABLE}.followers_count
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: managers_count
    type: int
    sql: ${TABLE}.managers_count
  - dimension: name
    sql: ${TABLE}.name
  - dimension: price_category
    sql: ${TABLE}.price_category
  - dimension: product_auto_expiration_days
    type: int
    sql: ${TABLE}.product_auto_expiration_days
  - dimension: products_count
    type: int
    sql: ${TABLE}.products_count
  - dimension: slug
    sql: ${TABLE}.slug
  - dimension: state
    sql: ${TABLE}.state
  - dimension: stories_count
    type: int
    sql: ${TABLE}.stories_count
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: count_distinct
    type: count_distinct
    sql: ${TABLE}.id

Contents

  • stores.view.lkml
  • stores.view.lookml