data.ml
LookML Travel app

Company Purchase

Company Purchase model for travel app.

source-preserved

Blocks

company_purchase.view.lkml · 54 lines
inferred 
view: company_purchase {
  sql_table_name: purchases ;;

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

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

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

  dimension: pack_id {
    hidden: yes
    sql: ${TABLE}.pack_id ;;
  }

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

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

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

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

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

  measure: count {
    type: count
  }
}
company_purchase.view.lookml · 50 lines
source-preserved 
- view: company_purchase
  sql_table_name: purchases
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.id
  - dimension: credits
    type: int
    sql: ${TABLE}.credits
  - dimension: owner_id
    sql: ${TABLE}.owner_id
  - dimension: pack_id
    hidden: true
    sql: ${TABLE}.pack_id
  - dimension: stripe_ref
    sql: ${TABLE}.stripe_ref
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: expired
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.expired_at
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • company_purchase.view.lkml
  • company_purchase.view.lookml