User interface in Explorer

Elements of the user interface

1. Filters and Tags
2. Toolbar
3. Connections and metadata
4. Data in a grid format
5. Data in its raw (original) format
6. SQL editor
7. Information about a connection or metadata object

Explorer UI

You can change the size of panels 3 and 4, by dragging the divider between the panels to the left or right.

Navigation

In Explorer, different information is displayed in each tab. The following tabs are available:

INFO

Information about a connection, table, columns, etc. When in the INFO tab, click the View/Edit button to view or edit connection parameters.

SQL

The SQL editor

DATA

Data in a grid format

RAW DATA

Raw data (the contents of the file, response from a web service, etc.)

Connections and formats

Explorer cannot work with connections that contain tokens, such as {params} in the URL. The tokens can, for example, be used to create dynamic URL. Instead, create a new connection, with the hard-coded URL pointing to the real resource.

There are two types of connections in Explorer:

1. The ones that don't need a format - such as database connections and APIs.
2. The ones that do require a format to view the data in the grid and execute SQL queries - such as file connections, web services, Redis, MongoDB, etc.

If the user tries to expand a connection that requires a format, Explorer will display a pop-up asking them to select a format. Once the format is selected, it will be associated with that connection. The user can change the format by clicking on the Format icon and selecting a new format.

Only one format can be associated with a particular connection. If you use the same connection for different types of data (for example, JSON and XML files), you will need to create as many identical connections as there are formats.