data.ml
SQL Advertising

Data Pixel Names

Data Pixel Names model for advertising.

source-preserved

Blocks

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

select
  pixel_name || ' (' || pixel_id::varchar || ')' as pixel_full,
  partner_name || ' (' || partner_id::varchar || ')' as partner_full
from
(
select
  distinct pixel_id,
  pixel_name,
  partner_id,
  partner_name
from
  data_pixel_events
)foo

# models/schema.yml
version: 2

models:
  - name: data_pixel_names
    columns:
      - name: pixel_full
      - name: partner_full

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.
data_pixel_names.sql · 13 lines
source-preserved validation: parses 
select
  pixel_name || ' (' || pixel_id::varchar || ')' as pixel_full,
  partner_name || ' (' || partner_id::varchar || ')' as partner_full
from
(
select
  distinct pixel_id,
  pixel_name,
  partner_id,
  partner_name
from
  data_pixel_events
)foo
data_pixel_names.view.lkml · 30 lines
inferred 
view: data_pixel_names {
  derived_table: {
    sql: select
  pixel_name || ' (' || pixel_id::varchar || ')' as pixel_full,
  partner_name || ' (' || partner_id::varchar || ')' as partner_full
from
(
select
  distinct pixel_id,
  pixel_name,
  partner_id,
  partner_name
from
  data_pixel_events
)foo ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
data_pixel_names.view.lookml · 24 lines
source-preserved 
- view: data_pixel_names
  derived_table:
    sql: select
  pixel_name || ' (' || pixel_id::varchar || ')' as pixel_full,
  partner_name || ' (' || partner_id::varchar || ')' as partner_full
from
(
select
  distinct pixel_id,
  pixel_name,
  partner_id,
  partner_name
from
  data_pixel_events
)foo
  fields:
  - dimension: pixel_full
    sql: ${TABLE}.pixel_full
  - dimension: partner_full
    sql: ${TABLE}.partner_full
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • data_pixel_names.sql
  • data_pixel_names.sql
  • data_pixel_names.view.lkml
  • data_pixel_names.view.lookml