data.ml
dbt Design marketplace

Pj Inbound Messages

Pj Inbound Messages model for design marketplace.

inferred

Blocks

pj_inbound_messages.sql · 29 lines
inferred 
-- models/pj_inbound_messages.sql
{{ config(materialized='view') }}

SELECT
lead_id
,sent_at
,recipient_id
,sender_id
,subject
,body

FROM
messages_message

WHERE
recipient_id = 1
AND sent_at > '2014-09-25'

# models/schema.yml
version: 2

models:
  - name: pj_inbound_messages
    columns:
      - name: lead_id
      - name: recipient_id
      - name: sender_id
      - name: subject
      - name: body

Assumptions

  • materialized='view' is the default; no persist hint found.
  • schema.yml columns come from view dimensions; a primary_key dimension gets unique + not_null tests.
pj_inbound_messages.sql · 14 lines
source-preserved validation: parses 
SELECT
lead_id
,sent_at
,recipient_id
,sender_id
,subject
,body

FROM
messages_message

WHERE
recipient_id = 1
AND sent_at > '2014-09-25'
pj_inbound_messages.view.lkml · 52 lines
inferred 
view: pj_inbound_messages {
  derived_table: {
    sql: SELECT
lead_id
,sent_at
,recipient_id
,sender_id
,subject
,body

FROM
messages_message

WHERE
recipient_id = 1
AND sent_at > '2014-09-25' ;;
  }

  dimension: lead_id {
    type: number
    sql: ${TABLE}.lead_id ;;
  }

  dimension: recipient_id {
    type: number
    sql: ${TABLE}.recipient_id ;;
  }

  dimension: sender_id {
    type: number
    sql: ${TABLE}.sender_id ;;
  }

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
pj_inbound_messages.view.lookml · 42 lines
source-preserved 
- view: pj_inbound_messages
  derived_table:
    sql: SELECT
lead_id
,sent_at
,recipient_id
,sender_id
,subject
,body

FROM
messages_message

WHERE
recipient_id = 1
AND sent_at > '2014-09-25'
  fields:
  - dimension: lead_id
    type: number
    sql: ${TABLE}.lead_id
  - dimension: recipient_id
    type: number
    sql: ${TABLE}.recipient_id
  - dimension: sender_id
    type: number
    sql: ${TABLE}.sender_id
  - dimension: subject
    sql: ${TABLE}.subject
  - dimension: body
    sql: ${TABLE}.body
  - dimension_group: sent_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.sent_at
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • pj_inbound_messages.sql
  • pj_inbound_messages.sql
  • pj_inbound_messages.view.lkml
  • pj_inbound_messages.view.lookml