data.ml
LKML Saas usability testing

Credit Cards

Credit Cards model for saas usability testing.

inferred

Blocks

credit_cards.view.lkml · 70 lines
inferred 
view: credit_cards {
  sql_table_name: company_orders_production.credit_cards ;;

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

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

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

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

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

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

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

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

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

  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: expires {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.expires_on ;;
  }

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
credit_cards.view.lookml · 55 lines
source-preserved 
- view: credit_cards
  sql_table_name: company_orders_production.credit_cards
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: account_id
    type: int
    sql: ${TABLE}.account_id
  - dimension: lookup_hash
    sql: ${TABLE}.lookup_hash
  - dimension: name
    sql: ${TABLE}.name
  - dimension: number
    sql: ${TABLE}.number
  - dimension: paypal_transaction_id
    sql: ${TABLE}.paypal_transaction_id
  - dimension: phone
    sql: ${TABLE}.phone
  - dimension: postal_code
    sql: ${TABLE}.postal_code
  - dimension: provider
    sql: ${TABLE}.provider
  - 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: expires
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.expires_on
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • credit_cards.view.lkml
  • credit_cards.view.lookml