Query Editor and Worksheet

Overview of Features

The Query Editor page provides a rich analytical interface for writing and submitting SQL queries as well as viewing the results as your statements complete. Performing DML, DDL, and even DCL queries are possible and our query editor supports executing multiple-statement in a single run.

Saving and Managing Worksheet

Bytehouse automatically saves worksheets as you type as a draft. To create a new worksheet, click on plus sign, and to give a more meaningful name for the worksheet (e.g. Sales Analytic ), double-click on the worksheet title in the tab bar.
To open a closed worksheet, click SQL editor menu to the left of the Data Object browser, choose one of the worksheets and click Edit Worksheet.

To share the worksheet, click on the share button on the top right. The Share Worksheet dialog will open. You can choose the appropriate role with whom you can share the worksheet with.

Using Data Object Browser

The object browser enables users to explore all databases, schemas, tables, and views accessible by the role selected for a worksheet.
The list of databases and other objects refreshes automatically when the worksheet context is changed. Users can also click the refresh button at the top of the object browser to view object changes immediately.
The object browser can be collapsed at any time to make more room for the SQL editor and results/history panes.

  1. Double-click to insert a name into SQL editor.

  2. Preview Table data

Using Virtual Warehouses

Click the Virtual Warehouse (...) menu to select a different active warehouse for the worksheet. You can resume or suspend the selected warehouse, or resize the warehouse.

Managing Queries

The query details and results displayed in the worksheet are only maintained for your current user session. If you log out of the web interface and log back in, the results from your previous session are no longer displayed in the worksheet; however, you can use the History page to see queries that were executed.

Running Queries

Execute queries in the SQL editor using any one of the following options:

ActionSteps
Execute single/multiple queries1. Select one or more contiguous queries text using the cursor.
Execute all queries1. Select the All Queries checkbox.

Aborting On-going Queries

While queries are running, the Run button changes to an Abort button. Click this button to abort the running queries.

Viewing Queries Information Details

Using Query History

History page allows you to view and drill into the details of all queries executed in the past. The page displays a historical listing of queries, including queries executed from SnowSQL or other SQL clients. The default information displayed for each query includes:

  • Current status of queries: waiting in the queue, running, succeeded, failed.

  • SQL text of your query.

  • Query ID.

  • Query start and end time, as well as duration.

  • Information about the query, including the number of bytes, scanned and a number of rows returned.

Using Query Profiler

In addition to query details and results, Bytehouse provides the Query Profile for analyzing query statistics and details, including the individual execution components that comprise the query.
Simply go to History page and click on one of the QueryID hyperlinks for the query execution you are interested in seeing the profiling information.


Did this page help you?