You have the option to either write the queries directly into the given query box or use the Query Generator to generate queries for you.
Schema on Read and Field Exploration
Depending on the datasource, a list of collections/tables along with field samples (or column names in case of relational databases) will be automatically detected. There are no data models to define or schema definitions required upfront.
For unstructured/semi-structured sources, Knowi uses native APIs for the database to infer fields where supported by the database, or fall back to sampling the data to determine fields.
Query Builder & Writing Queries
Choose Filters, Metrics and dimensions to build your query. The queries are automatically generated on the right as your filters/metrics/dimensions are applied. Filters provide the ability to build a complex query by using logic operators 'And', 'Or'. Also, the 'In' filter condition allows to use several values for each filter.. Click on Preview button to preview the data.
Instead of using the query generator, queries can directly be created via the Query box on the right.
Cloud9QL can be used to post-process/transform the return data, to complement native queries. This is not a replacement for the underlying query but offers powerful analytics functions on the results returned.
The query editor is a versatile text editor specialized for editing code and comes with a number of language modes and add-ons that implement more advanced editing functionality. Some of the supported functionality include key-maps such as:
- Start searching: (Ctrl-F / Cmd-F)
- Find next: (Ctrl-G / Cmd-G)
- Find previous: (Shift-Ctrl-G / Shift-Cmd-G)
- Replace: (Shift-Ctrl-F / Cmd-Option-F)
- Replace all: (Shift-Ctrl-R / Shift-Cmd-Option-F)
- Persistent search (dialog doesn't autoclose, enter to find next, Shift-Enter to find previous): (Alt-F)
- Jump to line: (Alt-G)
Use the Preview button to preview the results of your query. From here you can fine-tune your desired output, configure visualizations, and when done, select "Save and Run" to save and apply your changes.