data.ml
LKML Subscription jewelry

Product Change Histories

Product Change Histories model for subscription jewelry.

inferred

Blocks

product_change_histories.view.lkml · 43 lines
inferred 
view: product_change_histories {
  sql_table_name: ${TABLE}.change_histories ;;

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
product_change_histories.view.lookml · 35 lines
source-preserved 
- view: product_change_histories
  sql_table_name: ${TABLE}.change_histories
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: item_id
    type: int
    sql: ${TABLE}.item_id
  - dimension: status
    type: number
    sql: ${TABLE}.status
  - dimension: admin_id
    sql: ${TABLE}.admin_id
  - dimension: reason
    sql: ${TABLE}.reason
  - dimension_group: created_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • product_change_histories.view.lkml
  • product_change_histories.view.lookml