data.ml
LookML Social shopping

User Credits

User Credits model for social shopping.

source-preserved

Blocks

user_credits.view.lkml · 48 lines
inferred 
view: user_credits {
  sql_table_name: public.user_credits ;;

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, users.id, users.username, user_credit_transactions.count]
  }
}
user_credits.view.lookml · 48 lines
source-preserved 
- view: user_credits
  sql_table_name: public.user_credits
  fields:
  - dimension: id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: balance_cents
    type: int
    sql: ${TABLE}.balance_cents
  - dimension: balance_currency
    type: string
    sql: ${TABLE}.balance_currency
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: last_used
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_used_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - users.id
    - users.username
    - user_credit_transactions.count

Contents

  • user_credits.view.lkml
  • user_credits.view.lookml