Scheduled queries not updating results in Redash with DataTank

[shinngohamatani]

I'm experiencing an issue with Redash where scheduled queries are not updating the results when connected to a DataTank database. However, the same queries connected to Treasure Data (TD) are updating successfully.

I've investigated the issue and found the following:

1. The query results are not being saved in the query_results table for DataTank connections, while they are saved correctly for TD connections.
2. The background worker processes seem to be running, and the logs don't show any apparent errors.
3. Manual execution of the queries in Redash works fine for both DataTank and TD connections.

I suspect the problem might be related to one of the following:

I would appreciate any advice or suggestions on how to further troubleshoot and resolve this problem. If you need more information, please let me know.

Thank you in advance for your help!