System Catalog
Sail provides a system catalog that exposes internal system information as virtual tables. You can query these tables to inspect the state of the system, such as sessions, jobs, and workers.
The system catalog is available under the name system. Please refer to the following pages for more details about the databases and tables available in the system catalog.
Examples
INFO
In the code below, spark refers to a Spark client session connected to the Sail server. You can refer to the Getting Started guide for how it works.
You can list all the sessions using the following query.
python
spark.sql("SELECT * FROM system.session.sessions").show()