I have tried those connection details however it they give me 400 errors when trying to connect directly using the hive thrift server contract (https://github.com/apache/hive/blob/master/service-rpc/if/TCLIService.thrift). I do not get the issues when connecting to data science and engineering clusters. Do the sql warehouse use a slightly different contract? Could I get access to the thrift file the sql warehouses use?

I know there are lots of connectors, however there are no native ones for dotnet. There is an ODBC driver but requires a level of environment setup that is not always easy possible on cloud infrastructure. Which is why I was writing a a native dotnet connector, however stuck on determining what the contract is for SQL warehouses and how it differs from normal clusters