What causes 390501 (08007)?

The session exceeded the idle timeout configured on the warehouse or account (CLIENT_SESSION_KEEP_ALIVE not enabled). A network interruption between the client and Snowflake terminated the TCP connection. The Snowflake virtual warehouse was suspended while a query was executing. A load balancer or proxy in the network path reset the idle connection. The session was explicitly terminated by an admin using SYSTEM$CANCEL_ALL_QUERIES

How do I fix 390501 (08007)?

Enable CLIENT_SESSION_KEEP_ALIVE=TRUE in the connection string to prevent idle session expiry. Add retry logic in the pipeline code to reconnect and resubmit the query on connection reset. Increase the warehouse idle timeout: ALTER WAREHOUSE SET AUTO_SUSPEND = . Check if a network proxy or load balancer is resetting idle TCP connections. Verify the warehouse was not manually suspended during the query execution

Medium severityconnection

Power BI Refresh Error:
390501 (08007)

What does this error mean?

An active Snowflake session connection was reset unexpectedly. The session was alive but was terminated — either by a network interruption, an idle timeout, or the Snowflake service reclaiming the session.

Common causes

1The session exceeded the idle timeout configured on the warehouse or account (CLIENT_SESSION_KEEP_ALIVE not enabled)
2A network interruption between the client and Snowflake terminated the TCP connection
3The Snowflake virtual warehouse was suspended while a query was executing
4A load balancer or proxy in the network path reset the idle connection
5The session was explicitly terminated by an admin using SYSTEM$CANCEL_ALL_QUERIES

How to fix it

1Enable CLIENT_SESSION_KEEP_ALIVE=TRUE in the connection string to prevent idle session expiry
2Add retry logic in the pipeline code to reconnect and resubmit the query on connection reset
3Increase the warehouse idle timeout: ALTER WAREHOUSE <wh> SET AUTO_SUSPEND = <seconds>
4Check if a network proxy or load balancer is resetting idle TCP connections
5Verify the warehouse was not manually suspended during the query execution

Frequently asked questions

Is CLIENT_SESSION_KEEP_ALIVE safe to enable?

Yes for pipelines, but be cautious with interactive sessions — it keeps the session alive indefinitely, which can leave a warehouse running if users forget to close their sessions.

Does a connection reset roll back an in-progress transaction?

Yes — Snowflake automatically rolls back any uncommitted transaction when a session is terminated.