data.ml
LookML Marketing digital

Returns

Returns model for marketing digital.

source-preserved

Blocks

Returns.view.lkml · 111 lines
inferred 
view: Returns {
  sql_table_name: tsn_returns ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  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: [detail*]
  }
}
Returns.view.lookml · 74 lines
source-preserved 
- view: Returns
  sql_table_name: tsn_returns
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: address
    sql: ${TABLE}.address
  - dimension: associated_order_id
    type: int
    sql: ${TABLE}.associated_order_id
  - dimension: city
    sql: ${TABLE}.city
  - dimension: dealt_with
    type: yesno
    sql: ${TABLE}.dealt_with
  - dimension: disposition
    sql: ${TABLE}.disposition
  - dimension: disposition_reason
    sql: ${TABLE}.disposition_reason
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: ignored
    type: yesno
    sql: ${TABLE}.ignored
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: notes
    sql: ${TABLE}.notes
  - dimension: quantity
    type: int
    sql: ${TABLE}.quantity
  - dimension: return_reason
    sql: ${TABLE}.return_reason
  - dimension: rma_id
    type: int
    sql: ${TABLE}.rma_id
  - dimension: sku
    sql: ${TABLE}.sku
  - dimension: state
    sql: ${TABLE}.state
  - dimension: tsn_orderid
    type: int
    sql: ${TABLE}.tsn_orderid
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: tsn_return_sheet_id
    type: int
    sql: ${TABLE}.tsn_return_sheet_id
  - dimension: zip_code
    type: number
    sql: ${TABLE}.zip_code
  - 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:
    - detail*

Contents

  • Returns.view.lkml
  • Returns.view.lookml