import Screenshot from “@theme/Screenshot”

The Web Console will be available at . When running locally, this will be .

By default, the Web Console opens on the code editor.

Behaviour

• Check if the cursor is within a SQL statement. If yes, the statement will be executed, otherwise:
• Check if the cursor is on the same line as a SQL statement and after the semicolon. If yes, this statement will be executed, finally:
• If the cursor is on a line that does not contain a SQL statement, the next encountered statement will be executed. If there is no statement after the cursor, the previous statement will be used.

You can run a query and click on the Chart button. This will display the chart editor. You can then choose chart type, for example line and then press Draw.

Downloading results

You can download the query result by clicking the button. This file will be useful to test the import functionality below.

The import tab can be accessed by clicking this icon on the left-side navigation menu:

Import statuses

Description of the import statuses

Although the schema is automatically detected, you can amend the type of any column of an imported dataset using the following steps:

• Click on the file you want to amend in the Import screen. The schema will be displayed in a table in the lower-half of the screen.
• Click the column which type you want to change. A drop-down list allows for selecting a type for the column.

Custom import

You can amend the import behaviour with the following options. This will trigger to import the data again.