Table and Materialized Views not refreshing per schedule

Issue Summary

I am trying to have tables and materialized views automatically refresh using the refresh schedule built in. But the queries are not refreshing at all. I have posted an example code below, any ideas to remedy this? I have also confirmed query is working when I refresh manually.

INSERT INTO test_historical
(ID, refresh_date)
SELECT ‘next val placeholder’, now()

Technical details:

  • Redash Version: 5.0.2+b5485
  • Browser/OS: Chrome, MacOS
  • How did you install Redash: Connected to AWS hosted Postgres server