Skip to main content

SQL Editor View

Quick Look​

Query Editor View has three sub-panes:

  1. On the left is dataset explorer view
  2. Middle top is the query editor
  3. Middle bottom showns the results window

Query View

Supported Operations​

Following Operations are supported from SQL Query Editor View:

  1. View Dataset Schema
  2. Select a Compute Cluster to run
  3. Using SQL Editor
  4. Download Query Results

View Dataset Schema​

To view dataset schema, click on the dataset name. This brings up a pane with the schema in the bottom left of your query editor as shown below:

Query View

It further provides the following quick access buttons.

  1. Info button: To see a quick summary of the dataset. # of rows, # of columns etc.
  2. Link to data catalog: Links the catalog view for detailed profile of the specific dataset. For more on the catalog page refer to.

Data Catalogue

Select a Compute cluster to run your query​

Xceed Analytics supports multiple compute engines. Admin users can configure one or more compute clusters of variety of engine types and make them available for analysts to use.

Depending on the need, an analyst user can run the query on a specific cluster and engine type option, by selecting the same from the cluster drop-down list on top of the editor window panel

Supported SQL Engine Types include: Apache Drill, Apache Spark, Duckdb. Example list of available clusters is shown in the view below:

Query View

Using SQL Editor​

SQL Editor supports basic ANSI SQL auto-completion features for SQL Dialect and dataset/column names. Note, only SELECT queries are currently supported by SQL Editor. For more information on engine specific dialect, refer to respective references below:

i) SparkSQL ii) DuckDB.

Download the query results​

Expand the query output and download the output by clicking on the download and expand button .

Query View

Get the power of futuristic Data & AI Platform for your enterprise.