Editor

The goal of the Editor is to open-up data to more users by making self service querying easy and productive.

Editor’s Layout

 

Overview

It is available in Editor or Notebook mode and with the Dashboard. The Editor is pluggable and compatible with any databases or query engines:

  • SQL: MySQL, SparkSQL, Oracle, Apache Phoenix, Apache Presto, Apache Drill, Apache Kylin, PostgreSQL, Redshift, BigQuery…
  • MapReduce
  • Spark
  • Pig
  • Solr SQL

 

Read more about configuring the connectors.

 

A typical data analysis scenario consists in finding or importing the data, exploring it then charting/exporting the results.

Where is the data?

Find or import your data

Use the left metadata assists to browse your existing data without losing your editor. The top search will look through your saved queries and matching tables, columns and databases. Objects can be tagged for a quick retrieval or assigning a more “humane” name.

Ad-hoc import of data

If the data does not exist yet, just drag & drop it to trigger the Create Table wizard and to import it in just two steps.

 

Query Assistance

When you found your data, the Editor’s autocomplete is extremely powerful as they support 90-100% of the language syntax and will highlight any syntax or logical error. The right assistant provides quick previews of the datasets, which columns or JOINs are popular and recommendations on how to type optimized queries. After the querying, refine your results before exporting to S3/HDFS/ADLS or downloaded as CSV/Excel.

  • If multiple statements are present in the editor, the position of the cursor will determine what is the active statement that will be executed. In order to execute multiple statements (e.g. a series of CREATE tables) in sequence, they need to be manually highlighted or all selected via selected all shortcut (e.g. CTRL/CMD + A).

Risk alert educating the user on writing more optimized queries

Look at more functionalities here.

Variables

Variables can have default values

Parameterize your queries, read more about it.

 

Links available in record explorer via double click:

Leverage the results

Download in several formats, or export to the object store / another table huge results.

Chart with bars, timelines, maps, scatter plot and pie with pivot options.

Explore via a rich grid result with scrolling and zooming in/out levels.

 

Share you queries with colleagues and add them to the query knowledge bank.