1

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
2

Did you ever figure this out? I’m a little concerned by the example query since Redash really isn’t intended for running INSERT statements to the database. This could be part of what caused the issue for you. Can you provide a bit more information about your use case to help the community troubleshoot?