Viewing the Output Data

The output data can now be reviewed, focusing on the views, sessions, and users tables. These tables contain detailed records of key metrics and interactions.

select * from dbt_ryan_derived.snowplow_unified_views;

This query retrieves one row per view, detailing when each view started and ended, along with extensive information on where the event occurred.

select * from dbt_ryan_derived.snowplow_unified_sessions;

The sessions table includes the engagement time in seconds, calculated using pings in comparison to absolute time. It also contains additional data, such as counts of page views and events.

select * from dbt_ryan_derived.snowplow_unified_users;

The users table provides one row per user identifier, offering detailed information about each user.