So as an update* The "resolution" we found to this (which to me is NOT a real resolution!) is to add the following to the Kestrel server build options and then allow it to run synchronously with snowflakedata's SnowflakeDbConnection. Running it Async seems to lead back to the timeout, but running the pod synchronously does work, but it is taking roughly 5 and 1/2 hours to return around rows of data. (That is a weeks worth of data, and snowflake is updated weekly so we were following suite). We are looking at throttling the queries even more but I wouldn't expect the network to take that long to return 300,000 rows of data.
Kestral Options (incase anyone else find this and needs it!)
.UseKestrel(opt =>
{
opt.Limits.MaxConcurrentConnections = 100;
opt.Limits.MaxConcurrentUpgradedConnections = 100;
opt.Limits.KeepAliveTimeout = TimeSpan.FromMinutes(120);
opt.Limits.MaxRequestLineSize = 512000;
opt.Limits.MaxRequestBufferSize = 90000000;
opt.Limits.MaxResponseBufferSize = 90000000;
opt.Limits.MaxRequestHeadersTotalSize = 512000;
opt.Limits.MaxRequestBodySize = 90000000;
opt.AllowSynchronousIO = true;
})