I think there is an issue with the INNER JOIN from mapped_tracks to [page_]alias_mapping. In alias_mapping, alias is the distinct anonymous_id BUT this is the inner join: inner join ${aliases_mapping.SQL_TABLE_NAME} as a2v on a2v.alias = coalesce(t.u...

Here is a Snowflake View for DAU, WAU, MAU. view: event_active_users_pdt { derived_table: { sql: WITH dau AS ( SELECT TO_DATE(CREATED_AT) as event_date, COUNT(DISTINCT USER_ID) AS dau FROM SCHEMA.EVENTS WHERE -- <.. filter criteria...> GROUP BY event...