howto custom set warehouse settings?

[wubx]

In my case:
I need on query use two theads in one warehouse.

set global max_thread=2;

But this setting affects all warehouse. Is there have any solution?

[BohuTANG]

SET_VARS:
https://databend.rs/doc/sql-commands/setting-cmds/set-var