data.ml
LookML Ecommerce

Spree Countries

Spree Countries model for ecommerce.

source-preserved

Blocks

spree_countries.view.lkml · 55 lines
inferred 
view: spree_countries {
  sql_table_name: storefront.spree_countries ;;

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, iso_name, name]
  }
}
spree_countries.view.lookml · 42 lines
source-preserved 
- view: spree_countries
  sql_table_name: storefront.spree_countries
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: currency_abbr
    type: string
    sql: ${TABLE}.currency_abbr
  - dimension: iso
    type: string
    sql: ${TABLE}.iso
  - dimension: iso3
    type: string
    sql: ${TABLE}.iso3
  - dimension: iso_name
    type: string
    sql: ${TABLE}.iso_name
  - dimension: name
    type: string
    sql: ${TABLE}.name
  - dimension: numcode
    type: int
    sql: ${TABLE}.numcode
  - dimension: states_required
    type: yesno
    sql: ${TABLE}.states_required
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - iso_name
    - name

Contents

  • spree_countries.view.lkml
  • spree_countries.view.lookml