Skip to main content
Question

Set refresh rate for flattened table?

  • April 2, 2020
  • 1 reply
  • 9 views
Min_Yun_Chan

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

    1 reply

    Maurizio
    Forum|alt.badge.img
    • Maurizio
    • Participating Frequently
    • April 2, 2020

    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".

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement