Add Worksheet

A Worksheet is a web-based SQL client where you can execute SQL queries on a cluster. For more information, see Worksheets.

You can add new worksheets in the following ways: 

  • From the Worksheets page.
  • From any individual worksheet page by clicking Add worksheet .
  • From the cluster by clicking More, Run SQL and Add worksheet.

For more information, see Cluster Actions.

Worksheets are only visible to the user who created them. You cannot grant access to your worksheet to another user.

Add new worksheet

Do the following to add a worksheet and run queries from the Worksheets page:

  1. In the web console, click Worksheets icon Worksheets, and then click Add worksheet or Add worksheet.
  2. In the Create worksheet dialog box:
    • Select the database you want to query.
    • Select the cluster to which you want to connect.
    • Enter a name for the worksheet.

  3. Click Create. The worksheet page opens with the status Connected. If the status does not show as Connected, check if the database or cluster is running, and try again.
  4. Enter an SQL query and click the Run button. You can also use the keyboard shortcut CTRL+Enter or CMD + Enter to execute the query.

Duplicate Worksheets

Duplicating an existing worksheet will copy all settings and saved SQL text in the worksheet to a new worksheet. To duplicate a worksheet, do the following from the Worksheets page or from an individual worksheet:

  1. Click More on the worksheet you want to copy. Then click Duplicate.
  2. Enter in a new worksheet name and click Duplicate.

Execute Queries

You can execute queries at the current cursor by clicking the Run button at the top right corner of the worksheet page, or using the keyboard shortcut CTRL+Enter on a Windows system or CMD + Enter on Mac OS. To run all queries in the worksheet, check the Run all box. For each SQL query, you will see a result tab. Click each result tab to view the results.

All queries are run with auto-commit enabled, meaning a COMMIT is performed immediately after each statement. Auto-commit cannot be disabled.

Importing data from a local CSV file using the IMPORT FROM LOCAL CSV FILE syntax is not supported.