data.ml
LKML Subscription jewelry

Subscriptions

Subscriptions model for subscription jewelry.

inferred

Blocks

subscriptions.view.lkml · 78 lines
inferred 
view: subscriptions {
  sql_table_name: subscriptions ;;

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

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

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

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

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

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

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

  dimension: status_name {
  }

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

  dimension: subscription_plan_name {
  }

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

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

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

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

  measure: count {
    type: count
  }
}
subscriptions.view.lookml · 63 lines
source-preserved 
- view: subscriptions
  sql_table_name: subscriptions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: auto_renew
    type: yesno
    sql: ${TABLE}.auto_renew
  - dimension: comped
    type: yesno
    sql: ${TABLE}.comped
  - dimension: customer_id
    type: int
    hidden: true
    sql: ${TABLE}.customer_id
  - dimension: gift
    type: yesno
    sql: ${TABLE}.gift
  - dimension: payment_service_id
    sql: ${TABLE}.payment_service_id
  - dimension: status
    type: int
    sql: ${TABLE}.status
  - dimension: status_name
  - dimension: subscription_plan_id
    type: int
    sql: ${TABLE}.subscription_plan_id
  - dimension: subscription_plan_name
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: paid_through
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.paid_through_date
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_time
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • subscriptions.view.lkml
  • subscriptions.view.lookml