Trying to find the setting for this.
The configuration docs should help you locate the conf file - it has to be manually edited, the UI does not expose those settings.
The story was I was trying to fin the scratch dir … ending up just asking the person who installed the instance.
It might be useful to know where CREATE TABLE AS in a more explicit way in the future (from the UI for users). Otherwise we rely on knowing the config which might not be accessible.
If you use our CREATE TABLE AS and run it, it should show you the scratch dir path as an output.