LKML Fintech lending

Dim Account

Dim Account model for fintech lending.

inferred

Blocks

LKML LookML

dim_account.view.lkml · 73 lines

inferred

view: dim_account {
  sql_table_name: reporting.dim_account ;;

  dimension: amb_account_id {
    label: "AMB ACCOUNT Id"
    type: int
    primary_key: yes
    sql: ${TABLE}.dim_account_id ;;
  }

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

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

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

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

  dimension: pl_account_description_sort_order {
    type: int
    hidden: yes
    sql: ${TABLE}.pl_account_description_sort_order ;;
  }

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

  dimension: pl_main_account_sort_order {
    type: int
    hidden: yes
    sql: ${TABLE}.pl_main_account_sort_order ;;
  }

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

  dimension: pl_rollup_sort_order {
    type: int
    hidden: yes
    sql: ${TABLE}.pl_rollup_sort_order ;;
  }

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

  dimension: pl_sub_rollup_sort_order {
    type: int
    hidden: yes
    sql: ${TABLE}.pl_sub_rollup_sort_order ;;
  }

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

  measure: count {
    type: count
  }
}

dim_account.view.lookml · 49 lines

source-preserved

- view: dim_account
  sql_table_name: reporting.dim_account
  fields:
  - dimension: amb_account_id
    type: int
    primary_key: true
    label: AMB ACCOUNT Id
    sql: ${TABLE}.dim_account_id
  - dimension: account_description
    sql: ${TABLE}.account_description
  - dimension: account_number
    sql: ${TABLE}.account_number
  - dimension: active
    type: yesno
    sql: ${TABLE}.active
  - dimension: co_type_code
    sql: ${TABLE}.co_type_code
  - dimension: pl_account_description_sort_order
    type: int
    hidden: true
    sql: ${TABLE}.pl_account_description_sort_order
  - dimension: pl_main_account
    sql: ${TABLE}.pl_main_account
  - dimension: pl_main_account_sort_order
    type: int
    hidden: true
    sql: ${TABLE}.pl_main_account_sort_order
  - dimension: pl_rollup
    sql: ${TABLE}.pl_rollup
  - dimension: pl_rollup_sort_order
    type: int
    hidden: true
    sql: ${TABLE}.pl_rollup_sort_order
  - dimension: pl_sub_rollup
    sql: ${TABLE}.pl_sub_rollup
  - dimension: pl_sub_rollup_sort_order
    type: int
    hidden: true
    sql: ${TABLE}.pl_sub_rollup_sort_order
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_date
  - measure: count
    type: count

dim_account.view.lkml
dim_account.view.lookml

Dim Account

Blocks

Contents