Actions on Data sources

Edit Data Source parameters

Open Data Sources tab in the Base Settings homepage
Click on the data source that you wish to edit
Re-configure data source parameters as required. The following parameters can be edited:
1. Data source name
2. Database & Schema
3. Data source access permissions
Click on Submit button to save the changes

To change database connection configuration parameters (like host, port, and such) use Edit connection option. Edit connection option is available only for the users with Workspace Creator+ permissions

edit-data-source

Remove data source

Open Data Sources tab in the Base Settings homepage

Click on Actions button (three dots) against the data source that you wish to remove
Select Remove option from the dropdown

datasource unlink

Removing a data source will not delete the external data source. It will only remove the data source from the current base

Data source visibility

Open Data Sources tab in the Base Settings homepage
Toggle radio button listed under Visibility column for the data source that you wish to hide/un-hide

datasource visibility

View visibility

View visibility is available only in Open-Source version of NocoDB

Open Data Sources tab in the Base Settings homepage, select the data source that you wish to configure view visibility for and follow the steps below:

Select View visibility tab
You can see the list of views & tables available in the data source as rows & roles available as columns. Toggle checkboxes to enable/disable access to tables for specific roles.
Click on Save button to save the changes

ui acl

Relations

Open Data Sources tab in the Base Settings homepage
Select the data source that you wish to access ERD (Relations view) for
Click on ERD View tab

relations