Verifying the environment your DB client is accessing can sometimes be tricky. Where do I find what version of Exasol am I running? Which user am I running as? We have a solution canned up to get you started and introduce you to the power of LUA.
1. You have access to an Exasol database.
2. You are running as SYS user (DBA account) to build the script.
How to display your environment info using a LUA script
Create the LUA script
CREATE OR REPLACE LUA SCRIPT "WHOAMI" () RETURNS ROWCOUNT AS
output("Number of Nodes:"..tostring(exa.meta.node_count))
Execute the script to display your environment info and session_id. Please note the suffix "with OUTPUT", which is required to see the scripts output.
EXECUTE SCRIPT WHOAMI() with OUTPUT;
Once the script has been created, any user can execute it providing they have been granted CREATE SESSION and granted EXECUTE SCRIPT on the script listed above.