JetBrains DataSpell 2021.1 Help

Managing connection sessions

Connection is a physical communication channel. Session is a state of information exchange. A single connection can have multiple sessions. When you connect to the database server with the client application, the two sides establish a session to exchange information.

In the Services tool window, you can view data sources (1), connection sessions (2), and attached files (3). The small green light indicates that interaction with a data source is active.

The Services tool window automatically pops up when you run something related to a service (for example, run a query). Alternatively, to open the Services tool window, click View | Tool Windows | Services. For more information about the Services tool window, see the Services tool window topic.

The Services tool window

The following table includes basic actions that you can use to work with sessions.

ActionDescription
Create a connection session to a data source

Click the <session> list and select New session.

Create a connection session to a data source
Attach to an existing connection session

Click the <session> list and select an existing session.

Attach to an existing connection session
Detach a connection session

Click the <session_name> list and select an existing session.

Detach a connection session
Rename a connection session

In the Services tool window, right-click a session and select Rename Session.

Rename a connection session
Move a session or a data source to a separate tab

In the Services tool window, right-click a session or a data source and select Show in New Tab. To revert this action, close the separated tab.

Move a session or a data source to a separate tab
Close all connection sessions

In the Services tool window, right-click a data source and select Close All Sessions.

Close all connection sessions

Configuring session options

Set a time zone for a session

  1. In the Database tool window (View | Tool Windows | Database ), click the Data Source Properties icon The Data Source Properties icon.

  2. Select a data source that you want to modify and click the Options tab.

  3. In the Time zone field, start typing the time zone that you want to use.

  4. Apply settings and click OK.

    Select a time zone in the Time zone field

Change a data source and a connection session

  1. Detach a file from the current connection session. To detach the file, click Detach Session from the Sessions list.

  2. From the list of dialects, select another dialect.

  3. From the Sessions list, select a connection session of this dialect.

    Change a data source and a connection session
Last modified: 08 March 2021