Disconnect action
- Version:
- Updated: 2023/09/20
Disconnect action
Use the Disconnect action in the Database package to disconnect from a database.
Settings
- Session name: Enter or select a local or global session name variable.
- Variable: Enter or create a session variable of subtype Database session.
A record set is returned when you run a stored procedure or a query. To use the record set stored in the memory even if the session is disconnected, select Keep database schema in cache until bot finishes running. By using this option, you can enable the Loop action to iterate the record set by using cached schema after disconnecting from the database.
- The option Keep database schema in cache until bot finishes running is selected.
- A new database session is created after the Disconnect action.
- The name of the session is same as the previous session.
In this scenario, an error occurs stating a session already exists, and the new database session is not created. To avoid this, you can leave the Keep database schema in cache until bot finishes running unchecked.
The Snowflake database using the ODBC driver is supported.