Manage database connections in a notebook

Access attached database connections

Use the Attached data tool from the left-hand sidebar of the editor to access and manage attached data sources. All further procedures are performed from here.

1. In the editor, open the Attached data tool from the left-hand sidebar.

2. Switch to the Databases tab.

On this tab, you can see all database connections from the respective workspace that are either already attached to the notebook or available for attachment. When attached, a database connection can be used as a data source for this particular notebook.

Attach a database connection from the workspace

1. In the Attached data tool, switch to the Databases tab.

2. To attach or detach a database connection to the notebook, use the toggle for the respective item on the list. The off position of the toggle indicates the database is detached, meaning it is not accessible from the notebook as a data source.

Manage attached database connections

The procedure explains how to manage database connections from the Attached data tool when working on a notebook in the editor.

• To edit the details of a database connection:

  1. Click the ellipsis and select Edit database connection from the popup menu. This will open the Edit [database_type] connection dialog.

  2. In the Edit [database_type] connection dialog, edit the connection details. Find database-specific information in the respective article listed under Configure a database connection.

  3. Click the Save and close button to finish the procedure.

• To edit the introspection scope of an attached database connection:

  1. Click the database connection. This will open the detail view of the database schema.

  2. Click the ellipsis and select Edit introspection scope from the popup menu.

     

  3. Select or deselect the list items in the Edit introspection scope dialog and click Save and close to finish the procedure.

     

• To refresh a database schema, click the ellipsis and select Refresh schema from the popup menu.

• To delete a database connection, click the ellipsis and select Delete database.