View Properties

The Properties page is used to determine the database, to which a view, view's physical name and view query's text are added.

Determine the parameters:

Select Database. In the drop-down list select a database, to which query will be placed. When ClickHouse DBMS is selected, and the Saved View checkbox is selected, a table is created to store data obtained after query execution using the MergeTree mechanism.

To quickly select an object, enter object's name/identifier/key in the search box depending on display settings. Search is executed automatically while the searched text is entered into the search string. The list will display the objects, which names/identifiers/keys contain the entered text.

To set up displaying of repository objects, click the Show Object button and select display option in the drop-down menu:

Name. Objects are displayed with their names. Default option.
Identifier. Objects are displayed with their identifiers.
Key. Objects are displayed with their keys.

Several options can be selected. Identifier and key will be specified in brackets.

To reset selection for selected objects, click the Clear button.

Physical Name. By default, table identifier is used as the physical name of the table.
Permit an Incorrect View to Be Created. The checkbox is deselected by default. Select the checkbox to create a view with an incorrect query.
Saved View. Select the checkbox to work both with view data and with data of a standard table. When the checkbox is selected, editing view data does not result in changing data of basic tables. When data of the basic tables is changed, view contents is not refreshed. One can create indexes for a saved view.

NOTE. A view, which is saved incorrectly, cannot be created.

Query to Database. Create a query to database in the SQL language according to the syntax that is set for the selected DBMS.

The selected DBMS driver and the list of available drivers are displayed next to the Query to Database box. By default, the driver list displays the selected driver used during repository connection setup. If query is specified for one or several drivers, the selected driver(s) will be marked in the driver list.

To show or hide the driver list, use the Hide Driver List/Show Driver List button.

Click the Check Query button to check if the created query is correct.

To set the specified query to database for all DBMS, click the Apply for All DBMS button. The confirmation dialog box opens. If query is already specified for at least one driver that is different from the current one, all existing queries will be replaced with the current one if the answer is positive.