Submit a Query and View Results
After building your query, click Submit Query, review the run settings, and select Confirm & Run Query.
zinzu runs the query inside your Snowflake account. You can continue working while it processes.
Check Query Status
Open My Queries and locate your query. Its status shows its progress:
- Pending: The query is waiting to run.
- Processing: The query is running.
- Ready: Processing is complete and results are available.
Refresh the list to see the latest status.
Open the Results
When the status is Ready, click Results to explore the matches. Click Query to review the query definition or Stats to inspect execution statistics.
How zinzu Works Internally
- Combine:Read records from the selected sources and convert them into a common internal schema. Source columns do not need to be renamed or reshaped.
- Build timelines:Group records by event_owner and order each group by timestamp.
- Find sequences:Walk through each owner’s timeline from beginning to end, looking for the defined pattern.
- Identify sequences:Assign a Sequence ID to each captured sequence so its records can be viewed together.