Learn how to register and manage your databases within Kosmoy Studio’s Data Catalog.
The Databases section of the Data Catalog allows you to register databases, creating metadata representations that point to your actual database instances. This provides a structured view of your database contents and enables you to use them in other parts of Kosmoy Studio, such as Data Channels and Vector Pipelines.
Prerequisites:
Before registering a database, you must have a corresponding Connection configured. Refer to the Connections section for details.
Kosmoy Studio currently supports the following database types:
Navigate to Databases: From the Kosmoy Studio home page, click on the “Data Management” menu in the left-hand navigation bar, then select “Data Catalog” and then click on “Databases”.
Add a New Database: Click the ”+ ADD” button located in the upper right corner of the Databases section.
Select Database Type: Choose either “SQL” or “Vector”.
Select Connection: From the dropdown menu, select the appropriate pre-configured Connection for your database.
Configure Database-Specific Settings:
Click “Next”: Proceed to the next step.
Name and Describe the Database: Give your database a unique name and an optional description.
Click “Review”: Review the database details.
Click “Create”: Register the database in the Data Catalog.
The Databases section displays each registered database as a card. Each card shows:
You cannot edit or delete a database if it is currently referenced by other entities within Kosmoy Studio. This includes being used in:
Before attempting to edit or delete a database, ensure it is not actively used in any of these areas.
You can update the configuration of a registered database, including its connection parameters, name and description, provided it is not currently referenced by any other component.
If you attempt to edit a database that is currently in use, a warning banner will be displayed at the top of the screen, preventing the modification.
You can remove a registered database if it’s no longer needed. However, you cannot delete a database that is currently referenced by any other component.
If you attempt to delete a database that is currently in use, a modal will appear, preventing the deletion and explaining that the database is in use.
Warning: Deleting a database is a permanent action and cannot be undone. Ensure that the database is not being referenced by any other component before proceeding.
Registered databases can be used to create Data Channels. Vector databases can also be used to create Collections.
Learn how to register and manage your databases within Kosmoy Studio’s Data Catalog.
The Databases section of the Data Catalog allows you to register databases, creating metadata representations that point to your actual database instances. This provides a structured view of your database contents and enables you to use them in other parts of Kosmoy Studio, such as Data Channels and Vector Pipelines.
Prerequisites:
Before registering a database, you must have a corresponding Connection configured. Refer to the Connections section for details.
Kosmoy Studio currently supports the following database types:
Navigate to Databases: From the Kosmoy Studio home page, click on the “Data Management” menu in the left-hand navigation bar, then select “Data Catalog” and then click on “Databases”.
Add a New Database: Click the ”+ ADD” button located in the upper right corner of the Databases section.
Select Database Type: Choose either “SQL” or “Vector”.
Select Connection: From the dropdown menu, select the appropriate pre-configured Connection for your database.
Configure Database-Specific Settings:
Click “Next”: Proceed to the next step.
Name and Describe the Database: Give your database a unique name and an optional description.
Click “Review”: Review the database details.
Click “Create”: Register the database in the Data Catalog.
The Databases section displays each registered database as a card. Each card shows:
You cannot edit or delete a database if it is currently referenced by other entities within Kosmoy Studio. This includes being used in:
Before attempting to edit or delete a database, ensure it is not actively used in any of these areas.
You can update the configuration of a registered database, including its connection parameters, name and description, provided it is not currently referenced by any other component.
If you attempt to edit a database that is currently in use, a warning banner will be displayed at the top of the screen, preventing the modification.
You can remove a registered database if it’s no longer needed. However, you cannot delete a database that is currently referenced by any other component.
If you attempt to delete a database that is currently in use, a modal will appear, preventing the deletion and explaining that the database is in use.
Warning: Deleting a database is a permanent action and cannot be undone. Ensure that the database is not being referenced by any other component before proceeding.
Registered databases can be used to create Data Channels. Vector databases can also be used to create Collections.