View actions

Create View

1. Click the 'Create View' button on the dataset catalog page to initiate the view creation wizard.
   

    

2. Fill in basic details like View name and a description
   
3. A view requires at least two tables and a join condition. Click on 'Select Leftmost table' and select a table or a view from the list presented. Click on the 'Add' button.
   
4. Edit the 'Alias name' for the table if required. The alias name is prefixed to each table column to ensure that the view has unique column names even if the same column name is present in more than one table.
   
5. Click on the '+' button to select an additional table.
   
6. Select tables from the list of available internal or external tables.
   
7. Click on 'Select conditions' and specify the columns from both tables to be used as a join condition.
   
8. Click on 'Next'. For basic view creation, continue by clicking 'Next' on the 'TYPE MAPPINGS' step. Click 'Preview' on the 'VIRTUAL COLUMNS' step.
   
9. Review the preview results and click on 'Save View'.
   

Other actions

The list of views is available on the catalog page, as shown below.

The three dots action button against the view provides the following options:

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.