Known issue - SQL queries fail intermittently
You can run SQL queries against a data warehouse. If you have a long running session (typically more than one hour), the query intermittently fails.
Status: Fixed: November 11, 2024
Product Experience: Data Warehouse
Symptoms
Your SQL query intermittently fails with an error message similar to: The query failed because the access is denied on table. When you retry the same query, it succeeds.
Solutions and workarounds
As a workaround, retry the query.