LKML Real estate marketplace

Source Agent Branch Details Nopii

Source Agent Branch Details Nopii model for real estate marketplace.

inferred

Blocks

LKML LookML

source_agent_branch_details_nopii.view.lkml · 88 lines

inferred

view: source_agent_branch_details_nopii {
  sql_table_name: public.source_agent_branch_details_nopii ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: batch_creation {
    type: time
    timeframes: [date]
    sql: ${TABLE}.batch_creation_date ;;
  }

  dimension_group: creation {
    type: time
    timeframes: [date]
    sql: ${TABLE}.creation_date ;;
  }

  dimension_group: last_seen {
    type: time
    timeframes: [date]
    sql: ${TABLE}.last_seen_date ;;
  }

  measure: count {
    type: count
    drill_fields: [branch_name]
  }
}

source_agent_branch_details_nopii.view.lookml · 54 lines

source-preserved

- view: source_agent_branch_details_nopii
  sql_table_name: public.source_agent_branch_details_nopii
  fields:
  - dimension: internal_branch_id
    type: int
    primary_key: true
    sql: ${TABLE}.internal_branch_id
  - dimension: action
    sql: ${TABLE}.action
  - dimension: address
    sql: ${TABLE}.address
  - dimension: branch_name
    sql: ${TABLE}.branch_name
  - dimension: checked_by
    sql: ${TABLE}.checked_by
  - dimension: comment
    sql: ${TABLE}.comment
  - dimension: county
    sql: ${TABLE}.county
  - dimension: email
    sql: ${TABLE}.email
  - dimension: fax
    sql: ${TABLE}.fax
  - dimension: postcode
    sql: ${TABLE}.postcode
  - dimension: source
    sql: ${TABLE}.source
  - dimension: source_branch_id
    sql: ${TABLE}.source_branch_id
  - dimension: telephone
    sql: ${TABLE}.telephone
  - dimension: town
    sql: ${TABLE}.town
  - dimension: website_url
    sql: ${TABLE}.website_url
  - dimension_group: batch_creation
    type: time
    timeframes:
    - date
    sql: ${TABLE}.batch_creation_date
  - dimension_group: creation
    type: time
    timeframes:
    - date
    sql: ${TABLE}.creation_date
  - dimension_group: last_seen
    type: time
    timeframes:
    - date
    sql: ${TABLE}.last_seen_date
  - measure: count
    type: count
    drill_fields:
    - branch_name

source_agent_branch_details_nopii.view.lkml
source_agent_branch_details_nopii.view.lookml

Source Agent Branch Details Nopii

Blocks

Contents