Support client_session_keep_alive value for snowflake
Is your feature request related to a problem? Please describe.
When my snowflake session timeouts are set to a low value in my snowflake account, I use this parameter in my dbt profiles.yml
client_session_keep_alive: True to keep the session alive
data-diff --dbt should also pass along this setting so that snowflake does not close the session before diffs complete
Otherwise I encounter this error:
'ProtocolError('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))'
User reported that this does not seem to be working:
doesn't seem that the sqeleton package you guys use for the Snowflake connection is pulling forward the client_session_keep_alive variable
we got around this by manually updating our settings in Snowflake to set client_session_keep_alive=True
Figure out why this setting isn't persisting (cached connections?)