data.ml
LKML Fintech payments

Customers

Customers model for fintech payments.

inferred

Blocks

customers.view.lkml · 56 lines
inferred 
view: customers {
  sql_table_name: generic_looker_test.customers ;;

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

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

  dimension: default_payment_method_fk {
    type: number
    hidden: yes
    sql: ${TABLE}.default_payment_method_fk ;;
  }

  dimension: history {
    sql: ${TABLE}.pk ;;
  }

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

  dimension: name {
    sql: ${TABLE}.first_name || ' ' || ${TABLE}.last_name ;;
  }

  dimension: website {
    sql: CASE
  WHEN ${TABLE}.website SIMILAR TO '^https://example.com'
  THEN ${TABLE}.website
  WHEN ${TABLE}.website SIMILAR TO 'http://[^www]'
    THEN SUBSTRING(${TABLE}.website, 1, 7) || 'www.' ||
    SUBSTRING(${TABLE}.website, 8, CHAR_LENGTH(${TABLE}.website))
  WHEN ${TABLE}.website = ''
  THEN ${TABLE}.website
  ELSE 'https://example.com' || ${TABLE}.website
END ;;
  }

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

  measure: count {
    type: count
  }
}
customers.view.lookml · 41 lines
source-preserved 
- view: customers
  sql_table_name: generic_looker_test.customers
  fields:
  - dimension: pk
    type: int
    primary_key: true
    sql: ${TABLE}.pk
  - dimension: company
    sql: ${TABLE}.company
  - dimension: default_payment_method_fk
    type: number
    hidden: true
    sql: ${TABLE}.default_payment_method_fk
  - dimension: history
    sql: ${TABLE}.pk
  - dimension: merchant_fk
    type: int
    hidden: true
    sql: ${TABLE}.merchant_fk
  - dimension: name
    sql: ${TABLE}.first_name || ' ' || ${TABLE}.last_name
  - dimension: website
    sql: CASE
  WHEN ${TABLE}.website SIMILAR TO '^https://example.com'
  THEN ${TABLE}.website
  WHEN ${TABLE}.website SIMILAR TO 'http://[^www]'
    THEN SUBSTRING(${TABLE}.website, 1, 7) || 'www.' ||
    SUBSTRING(${TABLE}.website, 8, CHAR_LENGTH(${TABLE}.website))
  WHEN ${TABLE}.website = ''
  THEN ${TABLE}.website
  ELSE 'https://example.com' || ${TABLE}.website
END
  - dimension_group: created
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count

Contents

  • customers.view.lkml
  • customers.view.lookml