Query Builder
      Back to home
      1. Zetaris Support - Knowledge Base
      2. Using Zetaris
      3. Query Builder

      Processes for Automation: Table, View, Schema creation / deletion

      This article explains how to use Zetaris' Query Builder to create and delete views.

      Steps to create view

      1. Login to Zetaris

      2. Go to query builder tab

       QBImage1

       

      3.   In the middle pane drag and drop tables that are needed in the view.

      QBImage2
       
      4.   Join the key column and choose the type of join that is needed.

      5.   Select all the columns that are needed by clicking on the plus button, then further clicking add.

      QBImage3
       
      6.   Once all columns, predicates, aggregations for and the name of the permanent view are set, click on "Save Permanent View."

      7.   This will save your view.


      Steps to delete view

      1. Login to Zetaris

      2. Go to query builder tab

       QBImage4
      3.   From the left search for the permanent view to be deleted.Click on Bin button next to view.

      4.   This will delete your view.