The creator of the warehouse has exclusive access to Query Editor and must explicitly authorize other users (by creating the user in SQL). For more information, see Add Native Users.

Query Editor attempts to connect to the warehouse using the current console user. If the user is not registered with the warehouse, the user will encounter errors. If the user is authorized, the connection will be seamless to the user.

The Query Editor will open a persistent connection to the db database for the editor window and load the schema for the database upon launch.

The connection will persist for eight hours or until the warehouse shuts down, whichever comes first. Upon session expiration, you must restart Query Editor.

The icon indicator to the right of the connection configuration dropdown provides the status of the connection selected:

AWS AV-1 and Azure: indicates successful connection. If the connection fails on startup or expires, the status indicator will display a line through it to indicate a disconnected state.

Google Cloud and AWS AV-2: indicates successful connection. If the connection fails on startup or expires, the status indicator displays to indicate a disconnected state.