View actions

This page describes the actions available on a catalog view. Refer to the Introduction to catalog view. You can also refer to this guide for an example of creating a view for the classification dataset.

Create View

1. To initiate the view creation wizard, on the catalog page, click the 3-dot icon on top right, and click Create View.

   

2. Fill in basic details like View Name and View Description.
   

   

   A view requires at least two tables and a join condition.

3. Click Select Leftmost table and select a table or a view from the list presented.
   

   

4. Click the Add button.

5. Edit the Alias Name for the table, if required.
   The alias name is prefixed to each table column to ensure the view has unique column names even if the same column name is present in multiple tables.
   

   

6. Click the + (plus) button to select an additional table.
   

   

7. Select tables from the list of available internal or external tables.
   

   

8. Click Set Conditions and specify the columns from both tables to be used as a join condition.
   

   

9. Click the Next button.
   For basic view creation, continue by clicking Next on the 'TYPE MAPPINGS' step. Click Preview on the 'VIRTUAL COLUMNS' step.
   

   

10. Review the preview results and click Save View.
    

    

Other view actions

1. To view other view actions, on the catalog page, click the 3-dots icon, and click Tables/View Actions.

   

2. In the Settings window, under the Views section, click the 3-dots icon against a view.
   

   

   1. Delete: To delete a view. Deletion of the view does not impact the contents of the tables that were part of the view.

   2. Show Details: Shows the view details with the tables and join conditions used to create the view.
      

      

   3. Edit Details: To edit the view. Displays the View Details in edit mode. You can change the details and recreate the view if needed.

Union View

A view is a way to join tables on a common column.

For example, if an image has five ground truths and six predictions imported into two tables, namely gt_tbl and pred_tbl. You must join these tables with a pipeline primary table to visualize the ground truths and predictions. A view with (primary JOIN gt_tbl JOIN pred_tbl) will result in a view with 5x6 = 30 rows, which is not the intent here. Union View allows you to generate a view resulting in 5+6 = 11 rows as intended. A Union View will enable you to specify a view (primary JOIN gt_tbl) UNION ALL (primary JOIN pred_tbl). In this view, you can append the rows of the first JOIN to the rows from the second JOIN. Let’s see how to create a Union View.

1. On the catalog page, click the 3-dots icon on the top-right corner and click Create View.
   

2. Enter the View Name and Description. 

3. Click SELECT LEFTMOST TABLE to select the internal tables or views.

4. In the Internal table or views window, select the table and click the Add button.
   

5. In the Create View screen, enter the Alias and click the + (plus) button.

6. Select a table for the ground truth.

   1. Select a table for the ground truth in the Select table window, and click the Add button.

   2. Enter the Alias Name.

   3. Under Set Conditions, select the left and right columns for the ground truth.

7. Select UNION to add another set of tables on which you want to create a Union View.
   
   In the above screen, clicking the + (plus) button adjacent to the Alias Name would allow adding another set of ground truth conditions for a selected table, which is not required. You need to join another set of tables with prediction conditions for the primary LEFTMOST TABLE using the UNION option.

8. Select a table for the predictions.

   1. In the Select table window, select a table for the predictions, and click the Add button.
      The LEFT MOST TABLE for this remains the same as you had selected previously.

   2. Enter the Alias Name.

   3. Under Set Conditions, select the left and right columns for the predictions.
      

9. Click Next.

10. Click Preview to generate a preview of the Union View.

11. Click Save View.
    
    
    You can view the saved Union View by clicking the 3-dots icon of the catalog page, and navigating to Table/View Actions > Settings > Views.