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. 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 to the underlying query but offers powerful analytics functions on the results returned.
Use the Preview button to preview the results
To change the visualization settings, click on Modify Visualization Settings on the bottom right