Overview
Should you investigate a Dremio issue, you can enable Support Key planner.verbose_profile for example, in order to provide more details on planning steps.
Instead of enabling it for the full cluster, you can run in a session via the ui by running an alter session command before your run the query you want to investigate.
The profile generated for investigation will have verbose enabled, but if you opt to download the data within the same ui framework, it will not have verbose enabled.
Applies To
All versions post Dremio 23
Details
Run the following ALTER SESSION in a later Dremio release where multi statement is possible:
alter session set planner.verbose_profile=true;
select * from sys.options;
Now, if you choose to download the data within the SQL Runner, you will find that Dremio re-runs the query, with no ALTER SESSION being applied.
Further Reading
This is being reported in Jira DX-67228