SleekView for Snowplow WP: schema and self-describing event tables
Snowplow WP stores schema-to-event mapping in wp_options and writes self-describing event metadata into wp_postmeta. SleekView surfaces both as grids so schema audits stop requiring Iglu lookups.
♾️ Lifetime License available
Audit Snowplow schema configuration inside WP Admin
Snowplow is one of the few CDPs where schema is a first-class citizen. Every event is self-describing against an Iglu schema, every entity context is versioned, and the Snowplow WP integration stores its schema-to-event mapping in wp_options under snowplow_schema_map. WooCommerce orders, form submissions, and content interactions each get an _snowplow_event_id and _snowplow_schema row in wp_postmeta after relay.
The integration's settings page lists each schema mapping one at a time. To audit which schemas are pinned to which version, which events fired against a deprecated schema, or which orders never got a Snowplow event, operators end up running SQL against the Snowplow enriched events table.
SleekView reads the wp_options schema mapping and the per-row wp_postmeta as two coordinated grids. Mapping rows expose source hook, Iglu schema URI, version, and last-fired timestamp. Event rows expose the parent post or order, Snowplow event ID, schema, and version. Inline edits route through the Snowplow WP settings API so version pins stay validated.
Workflow
From wp_options schemas to a working schema audit
Register the Snowplow sources
snowplow_schema_map from wp_options and per-post _snowplow_event_id plus _snowplow_schema from wp_postmeta.
Compose audit columns
Save audit views
Edit inline
Sample columns
A typical Snowplow WP schema-mapping view
wp_options (snowplow_schema_map) + wp_postmeta (_snowplow_event_id, _snowplow_schema)
| Source hook | Schema | Version | Events 30d | Last fired | Status |
|---|---|---|---|---|---|
| woocommerce_order_status_completed | iglu:com.acme/order_completed | 1-0-3 | 12,481 | 8s ago | Active |
| user_register | iglu:com.acme/signup | 1-0-1 | 3,210 | 3m ago | Active |
| wpforms_process_complete | iglu:com.acme/form_submit | 1-0-0 | 84 | 1d ago | Stale |
| comment_post | iglu:com.acme/comment_posted | 0-9-1 | 0 | — | Deprecated |
Comparison
Default Snowplow WP admin vs SleekView
Default Snowplow WP admin
- Settings page lists schema mappings one at a time
- Iglu schema versions require manual lookup to verify
- Cross-source audits (events vs orders) need SQL against the enriched events table
-
Deprecated schemas surface as
debug.logwarnings, not a queryable list - Cannot share a curated schema view with a non-admin role
SleekView
-
Every schema mapping from
wp_optionsin one grid -
Self-describing event metadata from
wp_postmetaalongside - Filter Deprecated schemas or Stale mappings in one query
- Inline edits route through the Snowplow WP settings API
- Per-role scoped views so data engineering and product analysts share an audit surface
Features
What SleekView gives you for Snowplow WP
Schema mapping grid
Each row is a WordPress hook plus its Iglu schema URI, version, last-fired timestamp, and events sent in the last 30 days. Deprecated and stale mappings surface immediately.
Self-describing event audit
Filter wp_postmeta for _snowplow_event_id rows missing on parent shop_order posts. The audit becomes a saved view instead of a JOIN against the enriched events table.
Version pin enforcement
Edit schema version pins inline. Writes go through the Snowplow WP settings API so validation against the configured Iglu registry continues to apply.
Audience
Who uses SleekView for Snowplow WP
Data engineering
Audit every schema mapping and version pin in one grid. Deprecated schemas, broken Iglu references, and stale mappings surface as filterable rows.
Product analysts
Confirm the schemas powering a Snowplow data product are still active. Filter to a specific Iglu prefix and verify last-fired timestamps against expectations.
Compliance leads
Verify that self-describing events meet schema contract obligations. The per-event audit confirms each WooCommerce order produced a valid schema-pinned event.
The bigger picture
Why schema-first CDPs need a local schema audit
Snowplow's defining feature is that schema is enforced at collection time: every event carries a self-describing Iglu URI, every entity context is versioned, and downstream consumers can trust the shape of the data they receive. That contract is only as strong as the schema configuration on the WordPress side, which lives in wp_options as a mapping between hooks and Iglu schema URIs plus version pins. Right now that configuration is opaque to anyone who is not a data engineer.
The settings page lists schemas one at a time, deprecated versions surface as debug.log warnings, and a per-order audit requires SQL against the Snowplow enriched events table. SleekView treats the wp_options schema mapping and the wp_postmeta event metadata as coordinated, queryable grids inside WP Admin. The schema audit, deprecated, stale, missing events, becomes a saved view.
Version pins stay validated by the plugin's own Iglu helper. The schema contract becomes legible to product analysts and compliance leads, not just to the engineer who deployed it.
Questions
Common questions about SleekView for Snowplow WP
No. Snowplow remains the collector, enrichment, and warehouse pipeline. SleekView covers the WordPress-side schema audit: mapping in wp_options and event metadata in wp_postmeta.
When Snowplow WP exposes a validation helper, yes. Inline edits trigger the plugin's own Iglu validation, so version pins are checked against the configured registry before save.
 Yes. The schema mapping grid surfaces deprecated and active statuses, and a saved view of Deprecated schemas highlights mappings that need an upgrade plan.
 
No. Queries paginate against existing indexes on wp_options and wp_postmeta. There is no background sync.
Yes. WooCommerce hooks appear as first-class source hooks. The schema mapping grid lists each Woo event with its Iglu URI and version pin.
 
Yes. The event grid joins wp_postmeta rows to wp_posts (post_type=shop_order) or HPOS wp_wc_orders. Orders missing a Snowplow event surface as filterable rows.
Yes. Both grids export with active filters and visible columns. Data engineers use the export to file schema deprecation tickets and version upgrade plans.
 
Yes. Event IDs and schema URIs stored in wp_postmeta stay on your server. WordPress's privacy erase tools clear those rows alongside the parent post.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Woocommerce Gift Cards Pro
- Woocommerce Advanced Bulk Edit
- Bigcommerce
- Berocket Product Filter
- Woocommerce Advanced Flat Rate Shipping
- Woocommerce Quotes Orders
- Woocommerce Google Analytics Pro
- Woocommerce Shipping Per Product
- Woocommerce Product Filter
- Yith Woocommerce Stripe
- Edd Stripe Pro
- Payu Money Woocommerce
- Woocommerce Splitit
- Yith Woocommerce Product Image Gallery Slider
- Woocommerce Order Status Control
- Click Funnels Wp
- Membership By Supsystic
- Private Content Restricted Content
- Memberium For Activecampaign
- Lifterlms Pro Membership
- Wp Community
- Ultimatemember MyCRED
- Paywall Membership
- Memberium Keap
- Ultimatemember Social
- Accessally
- Memberpress Bundle
- Subscriptio
- Wp Courseware Members
- Memberium Active Campaign