Overview

Introduction to SQL Editor

The SQL Editor is one of the essential features in the workspace. Here you can see all the data no matter which database it stores. Several different and heterogenous databases can view as " the concept of a single database" in this SQL Editor. It works exactly like a database, but a virtual rather than a physical one.

The following is the screen introduction of SQL Editor follows.

1. It represents the current workspace, and you can click the Switch button to switch.
2. Represents all available data in this job quickly and can be found by searching
3. Area for writing SQL Statement
4. Status of SQL execution and resources used
5. SQL records during execution and historical execution

Available Datasets

In the left panel, you can see the Datasets you can use in this workspace. Click the triangle Icon to expand and view which Datasets are available.

For the Dataset, click the triangle Icon to expand and view the data types of each column.

These Columns and Datasets can use unlimitedly in this workspace.

View Datasets

When you slide over each Dataset or Column, you can insert the name of the table directly into the SQL Editor or preview the data set quickly.

Preview Data

Selecting Preview Data will only retrieve the first 100 data you can browse.

The previewed data will appear at the bottom of the screen.