Snowflake as a cloud data warehouse runs and costs money only when queries are send.
And queries have a “cool-down” phase of at least 1 minute (default config in my case was 30mins).
But now Redash is sending the following query, every 30 minutes, keeping Snowflake busy and expensive. My scheduled queries only run once a day.
SELECT col.table_schema, col.table_name, col.column_name FROM mydatabasename.information_schema.columns col WHERE col.table_schema <> 'INFORMATION_SCHEMA'
I am not sure what this “ping” is doing, but I am confident you can disable it without losing features in future versions.
And if you have an easy work-around to disable this ping in the current version, I would be happy to try it.
- Redash Version: 7.0.0+b18042 (4a978bad)
- Browser/OS: Chrome
- How did you install Redash: self-hosted