CONNECTION_ID

The CONNECTION_ID() function returns the unique connection ID of the current connection.

The ID returned by the function will only be unique in the context of a single (child) aggregator, so it cannot be used to uniquely identify sessions cluster-wide.

Syntax

CONNECTION_ID()

Return Type

Integer.

Example

SELECT CONNECTION_ID();
+-----------------+
| CONNECTION_ID() |
+-----------------+
|             171 |
+-----------------+

Last modified:

Was this article helpful?