SQL Console

The SQL Console allows you to run your SQL queries against Indexima from the Web Interface.

1 - Navigation Menu

2 - Canvas

3 - Script History

4 - Tables view

5 - Result pane

Access the SQL Console

Access the console from the navigation menu (1).

Run your SQL code in the main canvas (2).

Save your code to run it later.

Access to your saved SQL code from the left pane, by clicking on the "Saved Queries" tab in the tables view pane (4).

Clicking on a schema or on a table from the tables view pane (4) will insert its name in your SQL code.

Navigate to the Catalog view of your table to get more information.

Revise the history of run scripts from the script history pane (3).

Click on a specific query to see the corresponding returned results in the result pane(5).

You can then

Learn more about the results returned by clicking on

Download the results (as .csv file) by clicking on

Copy the query SQL code by clicking on

Close the result pane by clicking on

Clear your logs to get a clean script history pane (3).

You can create a new table with the wizard interface. Go to to Create Indexima Tables page to learn more about creating a table.

Refresh the tables view (4) by hitting 'Reload Schema.