Scenario
You may have stepped away from your work, and are now digging into things again. However when you try to run a model or execute a query you get an informational message like the one below, and the query doesn't return.
Resuming engine my_engine
Reasoning
When engines become inactive for at least auto_suspend_mins amount of time, they automatically go into a suspended state to save on resource costs. When the model is initiated or a query is executed, it resumes the engine. Note that transactions do not automatically resume the engine.
How to Fix
This will resolve on its own. The engine will take a few minutes to resume and then become available. You can check on its status with a SQL query like the below:
SELECT * FROM relationalai.api.engines;
+---------------------------+--------------+---------------+-----------+---------------------------------+-------------------------------+-------------------------------+-----------------------------+----------------------+-------------------+-------------+----------------------+
| NAME | ID | SIZE | STATUS | CREATED_BY | CREATED_ON | UPDATED_ON | COMPUTE_POOL | VERSION | AUTO_SUSPEND_MINS | SUSPENDS_AT | AWAIT_STORAGE_VACUUM |
|---------------------------+--------------+---------------+-----------+---------------------------------+-------------------------------+-------------------------------+-----------------------------+----------------------+-------------------+-------------+----------------------|
| CDC_MANAGED_ENGINE | 3531d5254f89 | HIGHMEM_X64_S | SUSPENDED | SYSTEM | 1969-12-31 16:00:00.000 -0800 | 2024-12-12 14:16:47.957 -0800 | | | 30 | NULL | False |
| my_engine | d9ba84d30b0a | HIGHMEM_X64_S | PENDING | gen@relational.ai | 2024-12-13 08:50:22.391 -0800 | 2024-12-13 17:03:06.368 -0800 | RELATIONAL_AI_HIGHMEM_X64_S | 2024.12.8-1ddd4a93-2 | 60 | NULL | False |
+---------------------------+--------------+---------------+-----------+---------------------------------+-------------------------------+-------------------------------+-----------------------------+----------------------+-------------------+-------------+----------------------+
While the engine is resuming, its status will be PENDING. Once it is resumed it will show READY.
Related Documentation
For more information see these documents.