The sys.project.engines table contains metadata for engines in a project.Syntax
SELECT * FROM sys.project.engines
|28cbd4c5-4373-4c58-a169-1a3e2cf430b4||preview||ENABLED||2021-12-19 06:07:57.450||1970-01-01 00:00:00.000||1||1||1||XX_SMALL_V1||0||300||0||0||2021-12-20 08:36:36.314||4||ip-172-22-22-222.us-east-2.compute.internal||68719476736||16||0||dremio-owner:firstname.lastname@example.org|
|3ffecd13-9ed0-4b7a-b02e-cae36406b824||First Engine||ENABLED||2021-12-20 08:11:34.364||1970-01-01 00:00:00.000||10||0||0||MEDIUM_V1||300||300||0||0||2021-12-20 08:06:33.667||10||ip-177-44-44-44.us-east-2.compute.internal, ip-177-11-11-111.us-east-2.compute.internal, ip-172-22-22-222.us-east-2.compute.internal, ip-150-55-55-55.us-east-2.compute.internal||137438953472||32||0||dremio-owner:email@example.com|
|engine_id||varchar||The UUID to identify the engine.|
|engine_name||varchar||The user-defined name for the engine.|
|state||varchar||The state of the engine.
Enum: DELETING, DISABLED, DISABLING, ENABLED, ENABLING, INVALID
|start_time||timestamp||The timestamp for when the engine was started.|
|stop_time||timestamp||The timestamp for when the engine was stopped.|
|minimum_replicas||integer||The number of minimum replicas that will be running for this engine at given point in time.|
|active_replicas||integer||The number of replicas that are curently active.|
|maximum_replicas||integer||The number of maximum replicas that can be spun up for this engine.|
|engine_size||varchar||The size of this engine.
Enum: XX_SMALL_V1, X_SMALL_V1, SMALL_V1, MEDIUM_V1, LARGE_V1, X_LARGE_V1, XX_LARGE_V1, XXX_LARGE_V1
|auto_stop_delay_secs||integer||The time (in seconds) that auto stop is delayed.|
|queue_time_limit_secs||integer||The maximum number of seconds a query will wait in the engine’s queue before it is canceled. This should not be set to less than two minutes (120 seconds), the typical time it takes to start a new replica. Changing this setting does not affect queries that are currently running or in the queue.|
|run_time_limit_secs||integer||The maximum number of seconds a query can run before being terminated.|
|drain_time_limit_secs||integer||The maximum seconds an engine replica will continue to run after the engine is resized, disabled or deleted before it is simply terminated and the running queries die.|
|last_query_timestamp||timestamp||The timestamp for when this engine was last used to run a query.|
|maximum_replica_concurrency||integer||The maximum number of concurrent queries that an engine replica can handle.|
|nodes||varchar||The list of nodes that are running for each each (includes all nodes in each replica).|
|average_node_memory||integer||The average memory for nodes in a replica for this engine.|
|average_node_cores||integer||The average cores for notes in a replica for this engine.|
|provisioning_node||integer||The number of nodes that are in the process of being provisioned for replicas of this engine.|
|cloud_tags||varchar||The tags that each engine is tagged with.|
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.