Accessing Data Modelling Workspace

vuSmartMaps Data Modelling Workspace can be accessed by navigating from the left navigation menu (Configure Observability > Data Modelling Workspace).

Landing Page

You will be directed to the Data Modelling Workspace’s home page. 

The listing gives information on the following:

• Name: The data model’s name. Click it to view the data model.
• Data Store Name: The name of the Data Store used in this Data Model.
• Type: Indicates if it’s a data model that comprises metrics or events.
• Created By: The user who originally created the data model.
• Created Date and Time: The date and time when the data model was originally created.
• Modified By: The user who recently modified the data model.
• Modified Date and Time: The date and time of the most recent modification.

Actions 

The Data Modelling Workspace’s home page can be used for various basic operations such as – Create, View, Edit, and Delete Data Models. 

Edit– Click on this icon to edit the respective Data Model.

Permissions

• Click on Edit for the data model you want to manage.
• You’ll be directed to the Set Properties page.
• Click on Permissions to access and manage Object Level Permissions.

The screen will look like this.

For each role, you can assign three types of permissions

• None: There are no permissions given.
• View: The selected user can only view the Data Modelling Workspace.
• Modify: The selected can also modify and make changes to the Data Modelling Workspace.

Delete: You can delete a Data Model by clicking the delete option under the Action column.

Multi-Delete: Select the multiple Data Models by checking the boxes on the extreme left and clicking on the Delete button on the top right.

Data Store

vuSmartMaps is compatible with various backend databases.

Querying

All Data Stores come with a standard Query Editor, designed for basic queries across different types of Data Stores. If needed, you can also input raw queries tailored to a specific Data Store, as each one may have unique query languages and capabilities.

Supported Data Stores

The following Data Stores are officially supported:

• PostgreSQL
• MySQL
• Elasticsearch
• ClickHouse
• Azure Data Explorer (ADX)

Data Store Management

Add New Data Store

1. Click Data Store on the right top corner of the Landing Page.
   
   
2. The Data Store landing page shows a list of previously configured Data Stores. Now click on the + icon on the top right to create a new Data Store.
   
   
3. You can see the list of supported Data Stores. You can search for any specific supported Data Store in the search bar. Click on the Data Store of your choice.
   
   
4. Follow the Data Store’s instructions for configuration, then click the Save & Test button.
   • PSQL Data Store
     
     
   • Elastic Search Data Store
     
     
   • ClickHouse Data Store
     
     

5. If the Data Store connection is successful, you’ll be directed to the listing page, and your newly added Data Store should be visible.
   
   

• Name: User-defined name for the Data Store.
• Data Store Name: Name of the selected Data Store (e.g., PostgreSQL, Elasticsearch).
• Created By: Name of the user who created the Data Store.
• Created At: Date and time when the Data Store was created.
• Modified By: Name of the user who made modifications to the Data Store’s configuration.
• Modified Date and Time: Date and time of the most recent configuration changes.
• Actions: Each Data Store has three buttons:
• View: Click to see the configuration details of the Data Store.
• Edit: Click to make changes to the Data Store’s configuration.
• Delete: Click to delete the Data Store (further details are in the next section).

Delete

• Click the Delete button under the “Actions” column for the specific Data Store you want to delete.
• A confirmation window will appear to ensure you want to proceed with the deletion.
• Click Delete to confirm and permanently remove the Data Store.
• If you change your mind, you can click Cancel to abort the deletion process.

Please note that deleting a Data Store is irreversible, so be certain of your decision before confirming the deletion.

With that, you have successfully created a new Data Store.

Further Reading

1. New Data Model Creation