data.ml
LookML Ecommerce luxury consign

Taxons

Taxons model for ecommerce luxury consign.

source-preserved

Blocks

taxons.view.lkml · 104 lines
inferred 
view: taxons {
  sql_table_name: store_production.spree_taxons ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
taxons.view.lookml · 74 lines
source-preserved 
- view: taxons
  sql_table_name: store_production.spree_taxons
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: avalara_tax_code
    sql: ${TABLE}.avalara_tax_code
  - dimension: description
    sql: ${TABLE}.description
  - dimension: icon_content_type
    sql: ${TABLE}.icon_content_type
  - dimension: icon_file_name
    sql: ${TABLE}.icon_file_name
  - dimension: icon_file_size
    type: int
    sql: ${TABLE}.icon_file_size
  - dimension: legacy_code
    sql: ${TABLE}.legacy_code
  - dimension: lft
    type: int
    sql: ${TABLE}.lft
  - dimension: name
    sql: ${TABLE}.name
  - dimension: no_rma
    type: yesno
    sql: ${TABLE}.no_rma
  - dimension: option_type_id
    type: int
    sql: ${TABLE}.option_type_id
  - dimension: parent_id
    type: int
    sql: ${TABLE}.parent_id
  - dimension: permalink
    sql: ${TABLE}.permalink
  - dimension: position
    type: int
    sql: ${TABLE}.position
  - dimension: rgt
    type: int
    sql: ${TABLE}.rgt
  - dimension: taxonomy_id
    type: int
    sql: ${TABLE}.taxonomy_id
  - dimension: visible
    type: yesno
    sql: ${TABLE}.visible
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: icon_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.icon_updated_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • taxons.view.lkml
  • taxons.view.lookml