data.ml
LKML Fintech payments

Addresses

Addresses model for fintech payments.

inferred

Blocks

addresses.view.lkml · 73 lines
inferred 
view: addresses {
  sql_table_name: "Addresses" ;;

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

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

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

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

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

  dimension: org_location_id {
    type: int
    sql: ${TABLE}.OrgLocationId ;;
  }

  dimension: organization_id {
    type: int
    sql: ${TABLE}.OrganizationId ;;
  }

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

  dimension: zip {
    type: zipcode
    sql: ${TABLE}.zip ;;
  }

  dimension: zip_plus4 {
    sql: ${TABLE}.zipPlus4 ;;
  }

  dimension: street_address {
    sql: ${address1} || ' ' || ${address2} ;;
  }

  dimension: city_state_zip {
    sql: ${city} || ', ' || ${state} || ' ' || ${zip} ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
addresses.view.lookml · 52 lines
source-preserved 
- view: addresses
  sql_table_name: '"Addresses"'
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: address1
    sql: ${TABLE}.address1
  - dimension: address2
    sql: ${TABLE}.address2
  - dimension: city
    sql: ${TABLE}.city
  - dimension: name
    sql: ${TABLE}.name
  - dimension: org_location_id
    type: int
    sql: ${TABLE}.OrgLocationId
  - dimension: organization_id
    type: int
    sql: ${TABLE}.OrganizationId
  - dimension: state
    sql: ${TABLE}.state
  - dimension: zip
    type: zipcode
    sql: ${TABLE}.zip
  - dimension: zip_plus4
    sql: ${TABLE}.zipPlus4
  - dimension: street_address
    sql: ${address1} || ' ' || ${address2}
  - dimension: city_state_zip
    sql: ${city} || ', ' || ${state} || ' ' || ${zip}
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.createdAt
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updatedAt
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • addresses.view.lkml
  • addresses.view.lookml