Skip to main content

SYS.PROJECT.ENGINES

The sys.project.engines table contains metadata for engines in a project.

Syntax
SELECT * 
FROM sys.project.engines

Example Output

engine_idengine_namestatestart_timestop_timemaximum_replicasactive_replicasminimum_replicasengine_sizeauto_stop_delay_secsqueue_time_limit_secsrun_time_limit_secsdrain_time_limit_secslast_query_timestampmaximum_replica_concurrencynodesaverage_node_memoryaverage_node_coresprovisioning_nodescloud_tags
28cbd4c5-4373-4c58-a169-1a3e2cf430b4previewENABLED2021-12-19 06:07:57.4501970-01-01 00:00:00.000111XX_SMALL_V10300002021-12-20 08:36:36.3144ip-172-22-22-222.us-east-2.compute.internal68719476736160dremio-owner:test.user@dremio.com
3ffecd13-9ed0-4b7a-b02e-cae36406b824First EngineENABLED2021-12-20 08:11:34.3641970-01-01 00:00:00.0001000MEDIUM_V1300300002021-12-20 08:06:33.66710ip-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.internal137438953472320dremio-owner:test.user@dremio.com

Fields

FieldData TypeDescription
engine_idvarcharThe UUID to identify the engine.
engine_namevarcharThe user-defined name for the engine.
statevarcharThe state of the engine.
Enum: DELETING, DISABLED, DISABLING, ENABLED</soan>, ENABLING, INVALID`
start_timetimestampThe timestamp for when the engine was started.
stop_timetimestampThe timestamp for when the engine was stopped.
minimum_replicasintegerThe number of minimum replicas that will be running for this engine at given point in time.
active_replicasintegerThe number of replicas that are curently active.
maximum_replicasintegerThe number of maximum replicas that can be spun up for this engine.
engine_sizevarcharThe 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_secsintegerThe time (in seconds) that auto stop is delayed.
queue_time_limit_secsintegerThe 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_secsintegerThe maximum number of seconds a query can run before being terminated.
drain_time_limit_secsintegerThe 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_timestamptimestampThe timestamp for when this engine was last used to run a query.
maximum_replica_concurrencyintegerThe maximum number of concurrent queries that an engine replica can handle.
nodesvarcharThe list of nodes that are running for each each (includes all nodes in each replica).
average_node_memoryintegerThe average memory for nodes in a replica for this engine.
average_node_coresintegerThe average cores for notes in a replica for this engine.
provisioning_nodeintegerThe number of nodes that are in the process of being provisioned for replicas of this engine.
cloud_tagsvarcharThe tags that each engine is tagged with.