› › ›

System Functions

These functions return metadata type of information about the system being queried.

`DATABASE`

Synopsis:

DATABASE()

Input: none

Output: string

Description: Returns the name of the database being queried. In the case of Elasticsearch SQL, this is the name of the Elasticsearch cluster. This function should always return a non-null value.

SELECT DATABASE();

   DATABASE
---------------
elasticsearch

`USER`

Synopsis:

USER()

Input: none

Output: string

Description: Returns the username of the authenticated user executing the query. This function can return null in case security is disabled.

SELECT USER();

     USER
---------------
elastic

© 2023-2025 Elasticsearch
As of September 2024, Elasticsearch is available under a choice of three licenses: the Server Side Public License (SSPL), the Elastic License, or the AGPLv3 (OSI approved).
Elasticsearch and the Elasticsearch logo are trademarks of Elasticsearch B.V., registered in the U.S. and in other countries.
https://www.elastic.co/guide/en/elasticsearch/reference/7.17/sql-functions-system.html