data.ml
LookML Marketing platform

User Children

User Children model for marketing platform.

source-preserved

Blocks

user_children.view.lkml · 39 lines
inferred 
view: user_children {
  sql_table_name: user$dependents ;;

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

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

  dimension: child {
    hidden: yes
    sql: ${TABLE}.child::json ;;
  }

  dimension: gender {
    sql: (${child} -> 'gender')::text ;;
  }

  dimension: year_of_birth {
    sql: (${child} -> 'year_of_birth')::text ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }
}
user_children.view.lookml · 24 lines
source-preserved 
- view: user_children
  sql_table_name: user$dependents
  fields:
  - dimension: id
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: _type
    sql: ${TABLE}._type
  - dimension: child
    hidden: true
    sql: ${TABLE}.child::json
  - dimension: gender
    sql: (${child} -> 'gender')::text
  - dimension: year_of_birth
    sql: (${child} -> 'year_of_birth')::text
  - dimension: embedded_in_id
    sql: ${TABLE}.embedded_in_id
  - dimension: embedded_in_table
    sql: ${TABLE}.embedded_in_table
  - measure: count
    type: count
    drill_fields:
    - id

Contents

  • user_children.view.lkml
  • user_children.view.lookml