data.ml
LKML Ecommerce

Spree Return Items

Spree Return Items model for ecommerce.

inferred

Blocks

spree_return_items.view.lkml · 106 lines
inferred 
view: spree_return_items {
  sql_table_name: storefront.spree_return_items ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }
}
spree_return_items.view.lookml · 75 lines
source-preserved 
- view: spree_return_items
  sql_table_name: storefront.spree_return_items
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: acceptance_status
    type: string
    sql: ${TABLE}.acceptance_status
  - dimension: acceptance_status_errors
    type: string
    sql: ${TABLE}.acceptance_status_errors
  - dimension: additional_tax_total
    type: number
    sql: ${TABLE}.additional_tax_total
  - dimension: customer_return_id
    type: int
    sql: ${TABLE}.customer_return_id
  - dimension: exchange_inventory_unit_id
    type: int
    sql: ${TABLE}.exchange_inventory_unit_id
  - dimension: exchange_variant_id
    type: int
    sql: ${TABLE}.exchange_variant_id
  - dimension: included_tax_total
    type: number
    sql: ${TABLE}.included_tax_total
  - dimension: inventory_unit_id
    type: int
    sql: ${TABLE}.inventory_unit_id
  - dimension: notes
    type: string
    sql: ${TABLE}.notes
  - dimension: override_reimbursement_type_id
    type: int
    sql: ${TABLE}.override_reimbursement_type_id
  - dimension: pre_tax_amount
    type: number
    sql: ${TABLE}.pre_tax_amount
  - dimension: preferred_reimbursement_type_id
    type: int
    sql: ${TABLE}.preferred_reimbursement_type_id
  - dimension: reception_status
    type: string
    sql: ${TABLE}.reception_status
  - dimension: reimbursement_id
    type: int
    sql: ${TABLE}.reimbursement_id
  - dimension: return_authorization_id
    type: int
    sql: ${TABLE}.return_authorization_id
  - dimension: return_authorization_reason_id
    type: int
    sql: ${TABLE}.return_authorization_reason_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id

Contents

  • spree_return_items.view.lkml
  • spree_return_items.view.lookml