data.ml
LookML Ecommerce florist

T Product Desc

T Product Desc model for ecommerce florist.

source-preserved

Blocks

t_product_desc.view.lkml · 51 lines
inferred 
view: t_product_desc {
  sql_table_name: T_ProductDesc ;;

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

  dimension: info1 {
    sql: ${TABLE}.Info1 ;;
  }

  dimension: info2 {
    sql: ${TABLE}.Info2 ;;
  }

  dimension: language_id {
    type: int
    sql: ${TABLE}.LanguageId ;;
  }

  dimension: meta_desc {
    sql: ${TABLE}.MetaDesc ;;
  }

  dimension: meta_key_words {
    sql: ${TABLE}.MetaKeyWords ;;
  }

  dimension: meta_title {
    sql: ${TABLE}.MetaTitle ;;
  }

  dimension: product_id {
    type: int
    sql: ${TABLE}.ProductId ;;
  }

  dimension: product_title {
    sql: ${TABLE}.ProductTitle ;;
  }

  dimension: upgrade_desc {
    sql: ${TABLE}.UpgradeDesc ;;
  }

  measure: count {
    type: count
  }
}
t_product_desc.view.lookml · 29 lines
source-preserved 
- view: t_product_desc
  sql_table_name: T_ProductDesc
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.ID
  - dimension: info1
    sql: ${TABLE}.Info1
  - dimension: info2
    sql: ${TABLE}.Info2
  - dimension: language_id
    type: int
    sql: ${TABLE}.LanguageId
  - dimension: meta_desc
    sql: ${TABLE}.MetaDesc
  - dimension: meta_key_words
    sql: ${TABLE}.MetaKeyWords
  - dimension: meta_title
    sql: ${TABLE}.MetaTitle
  - dimension: product_id
    type: int
    sql: ${TABLE}.ProductId
  - dimension: product_title
    sql: ${TABLE}.ProductTitle
  - dimension: upgrade_desc
    sql: ${TABLE}.UpgradeDesc
  - measure: count
    type: count

Contents

  • t_product_desc.view.lkml
  • t_product_desc.view.lookml