The new and advanced Query Builder UI is finally released to fulfill the following three objectives:
- Improve the usability of the page
- Build the navigation
- Make data engineering more productive
Visual Builder
Use Visual Builder to build the Query in a no-code visual interface by performing a simple drag and drop of collections/tables from the schema browser to define the Metrics, Dimensions, and Filters. You can also select the values for Metrics, Dimensions, and Filters from the dropdown list.
Query Editor
Switch to Query Editor using a toggle switch and write the Query directly in the versatile text editor that comes with a number of languages modes and add-ons for implementing advanced editing functionalities.
Schema Browser
Use the schema browser on the left to drag and drop the automatically detected collections/tables in the visual builder for building the Query. The schema browser also highlights the joined parts if your database supports the joined parts between the tables.
Navigation Bar
Use the navigation bar on the left-hand side of the UI to navigate around Data Strategy, Settings, Joined Sections, Machine Learning model, or Final Preview.
Data Strategy
The Data Strategy section now accommodates the complex use cases where you can store the results in Knowi’s ElasticStore. With ElasticStore usage, Overwrite Strategy provides you control on how the data is updated for the dataset when the Query is run by selecting a value from the dropdown like- Upsert, Append, TTL- Time Based Retention, or Replace All.
Dataset Page
Once you save and run your Query, you are redirected to the recently launched Dataset page that provides the essential details about the Dataset while also providing you with an option to Modify automatically detected data types, Edit Search-based analytics, View dataset diagram displaying data lineage of Query → Dataset → Visualizations, Interact and modify settings for each item directly within the dataset diagram, Create visualizations on top of the dataset, and much more.
Other Improvements
- Added setting to data grids to specify the number of records to be presented on the widget. Defaults to 1000 records. You can still view all the records by using the scroll on the side of the widget but this setting affects the number of records displayed at first glance on the dashboard. Find this by going to widget settings -> More Options -> First Page Limit.