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
SELECT ‘next val placeholder’, now()
- Redash Version: 5.0.2+b5485
- Browser/OS: Chrome, MacOS
- How did you install Redash: Connected to AWS hosted Postgres server