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