Dremio Cloud
Dremio Software
 
On this page

    SYS.PROJECT.ENGINES

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

    Syntax 
    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, 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.