How to immediately refresh/force refresh a materialized view!

Our Materialized Views will automatically refresh on 1-3 hour intervals, depending on the query runtime. Sometimes, you don't want to wait an hour, and need the materialized view to refresh immediately (perhaps you've just uploaded a new version of your CSV, or a table has just cached but is not yet reflected in the view).

In order to force materialization, any change plus running and saving will result in a refresh.  Our general recommendation is to add whitespace somewhere within a line (by pressing return, or via the tab key or spacebar) to your query, hit "run" and then hit save! You do not need to wait for the query to complete execution - you just need to hit run and can immediately save. 

Note: the space should come in the body of the query and not the start/end as those get parsed out!

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 11 mths agoLast active
  • 481Views
  • 1 Following