The goal of the Editor is to open-up data to more users by making self service querying easy and productive.
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…
- 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.
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).
Look at more functionalities here.
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.