Add response header timeouts to broker transports

Merged Cecylia Bocovich requested to merge cohosh/snowflake:bug/40005 into master

The client and proxy use the net/http default transport to make round trip connecitons to the broker. These by default don't time out and can wait indefinitely for the broker to respond if the broker hangs and doesn't terminate the connection.

Closes #40005 (closed)

Merge request reports