Create View Transformation

This transformation creates a view that can be used in data mining operations. One common reason for creating a view is to eliminate attributes (columns) from a data set.

This transformation provides a visual query builder that creates a new view based on existing tables and views. You use the query builder to create a SELECT statement that defines the new view. The created view is saved in the connected user's schema.

Follow these steps to create a view:

  1. Select the tables or views to use.
  2. Define the view to create.
  3. Create the view.

Select Tables or Views

First, select the tables or views to use. The left pane of the query builder is a schema viewer. Expand a database connection to see all the schemas that the connection has been granted access to. Expand each schema to see the tables and views it contains and expand each table or view to see its columns. To use a table or view in a query, drag it to the right pane.

Define the View

The tabs in the right pane of the display allow you to visually define a SELECT statement. The right pane of the query viewer has the following tabs:

Create the View

To create the view, select File | Create View from the query builder menu bar.

You can specify a name for the new view and an optional comment describing the new view.

Click OK to create the view. If any problems occur, messages are displayed to explain the problems. The new view is created in the connected user's schema.

After it is successfully created, the view is added to the navigator tree and its details (schema and data) are displayed.