CONNECTION_ID

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: November 8, 2023

Was this article helpful?