Once a datasource has been added, you can view, edit or remove it. Go to the main navigation menu, select Configuration > Datasources and on this page, you can perform the following actions:
View details for a datasource
- Click the ellipsis next to a datasource name and select the Details option.
- The datasource details page will open and you can view information such as:
- Datasource type: Specifies the type of datasource being used, such as MSSQL, Oracle, etc. This determines the kind of database the datasource connects to.
- Description: Specifies a brief summary of the datasource, outlining its purpose or the type of data it holds.
- Number of associated connections, datasets, fields: Indicates how many connections, datasets, and fields are associated with the datasource. For example, a datasource might have 3 connections, 5 datasets, and 20 fields.
- List and details of all the connections associated with the datasource.
- Connection: Specifies the name of the connection added within the datasource.
- Catalog Summary: Displays the current cataloged status of the data connection. Cataloging information updates automatically every 30 seconds.
Catalog Summary Description Failed with < number > of errors Displayed when an error occurs during cataloging. You can click this status link to view the error details. Cataloging Displayed when the cataloging process is ongoing. Cataloged Displayed when the schema is fully identified and cataloged, meaning all necessary metadata and information about them is available in the catalog. Not Cataloged Displayed when the schema is not yet been identified and cataloged. - Datasets: Specifies the total count of the tables that can be accessed or managed through the data connection.
- Fields: Specifies the individual columns within a dataset. Each field contains a specific type of information, such as a name, date, etc.
- Host or URL: Specifies the address you use to connect to the datasource. For databases, it might be a server address or IP, and for web-based sources, it could be a URL.
- Schedule: Specifies the scheduler frequency, which may be daily, weekly, or monthly.
Edit a datasource
- Find the datasource you want to view the details for.
- Click the datasource name, it opens the datasource page that has the connections added for that datasource.
- Click Edit Details, to edit the name and description of the datasource.
- Click Save to save the edits.
Remove a datasource
- Click the ellipsis next to a datasource name and select the Remove option.
- A Warning message will displayed, asking for confirmation for the removal of the datasource.
- Select the checkbox to confirm the removal of the datasource.
- Select Remove to proceed or Cancel to exit the operation.
Note:
- Once a datasource is removed, this action cannot be undone. All data discovery that is in progress will be stopped.
- Removing a datasource connection does not delete related assets or data quality pipelines. The associated assets remain in the catalog, and data quality pipelines are unaffected.
- To remove all associated assets, you must delete the datasource. However, data quality pipelines are not automatically deleted and must be removed manually if no longer required.