SYS.PROJECT.ENGINES
The sys.project.engines table contains metadata for engines in a project.
SELECT *
FROM sys.project.engines
Example Output
| engine_id | engine_name | state | start_time | stop_time | maximum_replicas | active_replicas | minimum_replicas | engine_size | auto_stop_delay_secs | queue_time_limit_secs | run_time_limit_secs | drain_time_limit_secs | last_query_timestamp | maximum_replica_concurrency | nodes | average_node_memory | average_node_cores | provisioning_nodes | cloud_tags |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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:test.user@dremio.com |
| 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:test.user@dremio.com |
Fields
| Field | Data Type | Description |
|---|---|---|
| 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</soan>, 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. |