data.ml
LookML Fintech consulting

Country

Country model for fintech consulting.

source-preserved

Blocks

country.view.lkml · 72 lines
inferred 
view: country {
  sql_table_name: COUNTRY ;;

  dimension: addresstemplate {
    sql: ${TABLE}.ADDRESSTEMPLATE ;;
  }

  dimension: businessdaycalendar {
    type: int
    sql: ${TABLE}.BUSINESSDAYCALENDAR ;;
  }

  dimension: code2 {
    sql: ${TABLE}.CODE2 ;;
  }

  dimension: code3 {
    sql: ${TABLE}.CODE3 ;;
  }

  dimension: countryseedid {
    type: int
    sql: ${TABLE}.COUNTRYSEEDID ;;
  }

  dimension: dialin {
    sql: ${TABLE}.DIALIN ;;
  }

  dimension: dialinter {
    sql: ${TABLE}.DIALINTER ;;
  }

  dimension: dialout {
    sql: ${TABLE}.DIALOUT ;;
  }

  dimension: extid {
    sql: ${TABLE}.EXTID ;;
  }

  dimension: favorite {
    type: number
    sql: ${TABLE}.FAVORITE ;;
  }

  dimension: isocurrency {
    sql: ${TABLE}.ISOCURRENCY ;;
  }

  dimension: isosymbol {
    type: int
    sql: ${TABLE}.ISOSYMBOL ;;
  }

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

  dimension: phoneformat {
    sql: ${TABLE}.PHONEFORMAT ;;
  }

  dimension: zipformat {
    sql: ${TABLE}.ZIPFORMAT ;;
  }

  measure: count {
    type: count
    drill_fields: [name]
  }
}
country.view.lookml · 41 lines
source-preserved 
- view: country
  sql_table_name: COUNTRY
  fields:
  - dimension: addresstemplate
    sql: ${TABLE}.ADDRESSTEMPLATE
  - dimension: businessdaycalendar
    type: int
    sql: ${TABLE}.BUSINESSDAYCALENDAR
  - dimension: code2
    sql: ${TABLE}.CODE2
  - dimension: code3
    sql: ${TABLE}.CODE3
  - dimension: countryseedid
    type: int
    sql: ${TABLE}.COUNTRYSEEDID
  - dimension: dialin
    sql: ${TABLE}.DIALIN
  - dimension: dialinter
    sql: ${TABLE}.DIALINTER
  - dimension: dialout
    sql: ${TABLE}.DIALOUT
  - dimension: extid
    sql: ${TABLE}.EXTID
  - dimension: favorite
    type: number
    sql: ${TABLE}.FAVORITE
  - dimension: isocurrency
    sql: ${TABLE}.ISOCURRENCY
  - dimension: isosymbol
    type: int
    sql: ${TABLE}.ISOSYMBOL
  - dimension: name
    sql: ${TABLE}.NAME
  - dimension: phoneformat
    sql: ${TABLE}.PHONEFORMAT
  - dimension: zipformat
    sql: ${TABLE}.ZIPFORMAT
  - measure: count
    type: count
    drill_fields:
    - name

Contents

  • country.view.lkml
  • country.view.lookml