Skip to content
Managing Transactions

Managing Transactions in the RAI Console

Database transaction activity can be viewed, analyzed, and managed in the RAI Console.

To manage transactions, click the Transactions clock icon on the left-hand side of the Console. The Transactions page opens:

list of users

Within this page, you have access to all transactions associated with the selected RAI account. This includes transactions initiated via the Console or any of the RelationalAI SDKs.

You can inspect the details of all past and currently running transactions. Running transactions can also be canceled. For more details, see Canceling a Transaction.


Transaction information are stored and are accessible for transactions up to 30 days. Older transactions are not accessible.

Viewing Transaction Activity

When the Transactions page opens, it displays only transactions that you have initiated.

To view transactions for your entire account, click All Transactions next to the Search field.

All transaction button

To return to viewing only your transactions, click Yours.

Transaction Activity Table

The following transaction details are shown in the Transaction Activity table.

DATABASE NAMEDatabase in which the transaction ran.
ENGINE NAMEEngine on which the transaction ran.
QUERYThe actual query executed by the transaction.
STATECurrent state of the transaction. See Transaction States for details.
CREATED ONTime when the transaction was initiated.
FINISHED ATTime when the transaction completed.
DURATIONAmount of time the transaction took to run.
READ-ONLYWhether or not the transaction was read-only.

To inspect a transaction and get more detailed information, select the transaction by clicking it.

Searching for Transactions

You can search for transactions by entering text in the Search box. Search conducts a fuzzy, client-side search on all columns.

Search only returns results for transactions already displayed; it will not return results for earlier transactions.

Inspecting a Single Transaction

You can view detailed information on a transaction, which looks like this:

Page of a single transaction (9a9103ef-ee2b-95d8-4be8-b045a27b36e4)

The Transactions detail page displays the following information:

TransactionStatus and details of the transaction. See Transaction States for more information.
QueryThe executed Rel program (first 1000 characters).
ResultsResults of the transaction (if applicable).

Transaction States

Transactions can be in one of four states:

CreatedTransaction has been issued but is not yet running.
RunningTransaction is currently running. Running transactions can be canceled.
CompletedTransaction has run successfully.
AbortedTransaction has been canceled by the user or aborted by the system. See Abort Reasons below for more details.

Transaction Details

IdUnique identifier for the transaction. Useful for communicating with RAI support.
DatabaseDatabase in which the transaction ran.
EngineEngine on which the transaction ran.
StateCurrent state of the transaction: Created, Running, Completed, or Aborted.
Abort ReasonIf transaction was aborted, reason why. See Abort Reasons below for more details.
Created OnTime when the transaction was initiated.
Finished AtTime when the transaction completed.
DurationAmount of time the transaction took to run.
Read-onlyWhether or not the transaction inserted or deleted base relation data.
Format VersionVersion of the SDK used. Best practice is to use the latest version of the SDK.
User AgentName of SDK or the browser details when executed via the Console.
TagsDisplays metadata attached to a transaction via SDKs. For more information, contact
DatadogInternal option for inspecting transactions.

Abort Reasons

Abort ReasonExplanation
CanceledTransaction was canceled by user.
Engine Shutting DownEngine was shut down before transaction could complete.
Integrity Constraint ViolationTransaction canceled because query violates an integrity constraint. See Integrity Constraints for more details. In these cases, the transaction still shows results, so that you can debug the query.
Invalid RequestTransaction resulted in an invalid request to the server.
Runtime ErrorTransaction aborted because the computation of a requested relation triggered a runtime error.
System Internal ErrorSystem has experienced an error.

Canceling Transactions

While a transaction is running, you can cancel it by clicking Cancel in the far right-hand column. Canceled transactions will eventually move to an aborted state.

Cancel a running transaction

If a transaction happens to complete before the system processes the cancellation, it may move to a completed state.

Was this doc helpful?