data.ml
LookML Loyalty enterprise

Rewards

Rewards model for loyalty enterprise.

source-preserved

Blocks

rewards.view.lkml · 84 lines
inferred 
view: rewards {
  sql_table_name: public.rewards ;;

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

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

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

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

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

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

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

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

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

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

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

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

  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, chains.name, chains.id, purchases.count]
  }
}
rewards.view.lookml · 68 lines
source-preserved 
- view: rewards
  sql_table_name: public.rewards
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: business_id
    type: int
    sql: ${TABLE}.business_id
  - dimension: chain_id
    type: int
    sql: ${TABLE}.chain_id
  - dimension: description
    sql: ${TABLE}.description
  - dimension: hidden
    type: yesno
    sql: ${TABLE}.hidden
  - dimension: monetary_value
    type: number
    sql: ${TABLE}.monetary_value
  - dimension: pending_deletion
    type: yesno
    sql: ${TABLE}.pending_deletion
  - dimension: points
    type: int
    sql: ${TABLE}.points
  - dimension: purchases_count
    type: int
    sql: ${TABLE}.purchases_count
  - dimension: repeat_reward_settings
    sql: ${TABLE}.repeat_reward_settings
  - dimension: reward_category_id
    type: int
    sql: ${TABLE}.reward_category_id
  - dimension: sub_description
    sql: ${TABLE}.sub_description
  - 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
    - chains.name
    - chains.id
    - purchases.count

Contents

  • rewards.view.lkml
  • rewards.view.lookml