Views browser

The CrateDB Admin UI comes with a views browser that allows you to inspect and query stored views.

Table of contents

Screenshots

Here’s what a simple view looks like:

_images/views.png

The top section on this screen shows you a basic overview. If you select QUERY VIEW you can query the view using the SQL console.

Below this, you will find the columns information.

Features

View-level information

This section displays the following view-level information:

Name:

The name of the view.

Definition:

The SQL query used to create the view.

Columns information

This section section displays information about each view column:

Name:

The name of the view column.

Type:

The column data type.

Other features

Display toggle:

Different groups of views can be shown or hidden by toggling the corresponding arrow button on the left-hand sub-navigation menu.

View filter:

The displayed list of views can be filtered by entering text to match against the view name in the Filter views text input.