data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

Support client_session_keep_alive value for snowflake

Open dlawin opened this issue 2 years ago • 1 comments

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'))'

dlawin avatar Apr 17 '23 22:04 dlawin

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?)

dlawin avatar Apr 28 '23 17:04 dlawin