v.22.6Experimental Feature
Enables POPULATE for WINDOW VIEW
Why it matters
This feature allows users to pre-populate window views with existing data at the time of creation, ensuring that the view contains data immediately rather than waiting for incremental updates. It improves usability by simplifying data initialization for window views.How to use it
When creating aWINDOW VIEW, add the POPULATE keyword to the CREATE WINDOW VIEW statement to populate the view with existing data immediately. For example:CREATE WINDOW VIEW view_name POPULATE AS <your_window_query>