Skip to content
AWS for Query.Farm

aws.neptunedata.get_engine_status

Example SQL Queries

SELECT * FROM
aws.neptunedata.get_engine_status;

Description

Retrieves the status of the graph database on the host.

When invoking this operation in a Neptune cluster that has IAM authentication enabled, the IAM user or role making the request must have a policy attached that allows the neptune-db:GetEngineStatus IAM action in that cluster.

Table Definition

Column NameColumn Data Type
db_engine_version

Set to the Neptune engine version running on your DB cluster. If this engine version has been manually patched since it was released, the version number is prefixed by Patch-.

VARCHAR
dfe_query_engine

Set to enabled if the DFE engine is fully enabled, or to viaQueryHint (the default) if the DFE engine is only used with queries that have the useDFE query hint set to true.

VARCHAR
features

Contains status information about the features enabled on your DB cluster.

MAP(VARCHAR, VARCHAR)
gremlin

Contains information about the Gremlin query language available on your cluster. Specifically, it contains a version field that specifies the current TinkerPop version being used by the engine.

STRUCT(
    "version" VARCHAR
)
Show child fields
gremlin.version

The version of the query language.

lab_mode

Contains Lab Mode settings being used by the engine.

MAP(VARCHAR, VARCHAR)
opencypher

Contains information about the openCypher query language available on your cluster. Specifically, it contains a version field that specifies the current operCypher version being used by the engine.

STRUCT(
    "version" VARCHAR
)
Show child fields
opencypher.version

The version of the query language.

role

Set to reader if the instance is a read-replica, or to writer if the instance is the primary instance.

VARCHAR
rolling_back_trx_count

If there are transactions being rolled back, this field is set to the number of such transactions. If there are none, the field doesn't appear at all.

BIGINT
rolling_back_trx_earliest_start_time

Set to the start time of the earliest transaction being rolled back. If no transactions are being rolled back, the field doesn't appear at all.

VARCHAR
settings

Contains information about the current settings on your DB cluster. For example, contains the current cluster query timeout setting (clusterQueryTimeoutInMs).

MAP(VARCHAR, VARCHAR)
sparql

Contains information about the SPARQL query language available on your cluster. Specifically, it contains a version field that specifies the current SPARQL version being used by the engine.

STRUCT(
    "version" VARCHAR
)
Show child fields
sparql.version

The version of the query language.

start_time

Set to the UTC time at which the current server process started.

VARCHAR
status

Set to healthy if the instance is not experiencing problems. If the instance is recovering from a crash or from being rebooted and there are active transactions running from the latest server shutdown, status is set to recovery.

VARCHAR