Snowflake building step funnel

Asked Dec 15 '21 at 15:16

Active Dec 15 '21 at 17:18

Viewed 76 times

I have a table with 3 columns

USER_ID
EVENT_ID
EVENT_DATETIME

I am trying to figure out how can I write MATCH_RECOGNIZE so I can answer to following questions: How many distinct users interacted with event_id = 234, then during 10 minutes interacted with event = 444 then in 15 minutes interacted with event = 987. One note here is that between events 234 and 444 user could have interacted with 50 different events that are not important here.

asked Dec 15 '21 at 15:16

datahack

Please add some sample data with the desired results – Felipe Hoffa Dec 16 '21 at 01:04
Is there a specific reason why you want to use MATCH_RECOGNIZE ? It would be much easier to just join 33 instances of the table – NickW Dec 16 '21 at 03:34

Snowflake building step funnel

0 Answers0