Can we automatically refresh every 5 sec a flattened table built with SET USING?
Question from The shortest path to Vertica: Best practices for data warehouse migration & ETL@marcothesane @Maurizio
You will have to run REFRESH_COLUMNS() on "SET USING" columns. This function has no "automatic refresh timeouts" but you can run it every X seconds - if really needed - using an external scheduler. It's probably a good idea to "link" REFRESH_COLUMNS() execution to ETL related events more than "fixed length timeouts".