Actions on Data Sources

Edit Data Source parameters

  • Open External Database in Base Settings → Manage.
  • Click the data source that you want to edit.
  • Change the data source parameters as necessary. You can edit these parameters:
    1. Data source name
    2. Database & Schema
    3. Data source access permissions
  • To save the changes, click the Submit button.
To change database connection parameters (such as host and port), use the Edit connection option. Only users with Workspace Creator+ permissions can use the Edit connection option.

Source Connection Details for an external data source

Remove data source

Open External Database in Base Settings → Manage. Then do these steps:

  1. Click the Actions button (three dots) next to the data source that you want to remove.
  2. In the dropdown, select the Remove option.

The row menu, with Edit and Remove

The Remove Data Source confirmation

When you remove a data source, NocoDB does not delete the external data source. It only removes the data source from the current base.

You cannot remove the default source of a base. A base must always have at least one source.

Data source visibility

  • Open External Database in Base Settings → Manage.
  • To hide or show a data source, use its toggle in the Visibility column.

The Visibility toggle beside each data source

View visibility

Open External Database in Base Settings → Manage. Select the data source for which you want to set view visibility. Then do these steps:

  1. Select the View visibility tab. The rows show the views and tables in the data source. The columns show the roles.
  2. To enable or disable access to tables for a role, select or clear the checkboxes.
  3. To save the changes, click the Save button.

The View visibility tab, with a checkbox per role

Relations

  • Open External Database in Base Settings → Manage.
  • Select the data source for which you want to see the ERD (Relations view).
  • Click the ERD View tab.

The ERD View tab showing the source's tables and relations

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX