Knowi Product Update Q4 2017

Our query capabilities are at the heart of what makes Knowi different. We constantly add capabilities but in the past few weeks we've focused our efforts and added a number of enhancements:

Join BuilderIn addition to performance improvements to the Join functionality, we now provide query join assistance from within the Query page. The supported joins types are listed along with auto-detected key field candidates for each side of the join. You can, of course, still enter the join criteria manually.

Save Query as DraftYou now have the ability to save a query in progress without creating an associated dataset and widget. Go for that coffee break!

View Query Change HistoryWondering who messed up your query? Wonder no more.. you now have the ability to view an audit history of query changes. This is only applicable if the user has edit permissions for the query in question. From the Query Listing page, a history icon is now available. When clicked, the user will username and timestamp of when each change was made.

Query Filters Suggestions

In Query, filters auto-suggestions and hit list filter capabilities can now be seen from within the Query Builder itself.

Join Post-ProcessingYou can now apply Cloud9QL functions to a dataset post join.

Preview Data at Each Join Step

You can now preview dataset results at each join step. This can be especially useful when you have multiple join steps.

We're Getting Slacky

Slack integration allows you to trigger actions in your slack channel(s) for a given condition triggered by an alert. When the condition is triggered, we'll send a message to a predefined channel(s) including the attachment of full data or conditional data depending on the options selected.

Enterprise data security is top of mind for everyone. Whenever we can, we leverage new security capabilities from our database partners as quickly as possible.

SSL Support

We now support SSL enabled MarkLogic and Datastax/Cassandra

Role-based access control (RBAC) Support

We now support RBAC in Couchbase 5.0

Access Control List

The system now supports the ability to create white and black lists of datasource assets (tables/collections/indexes). This will allow the datasource creator to specify those assets available to subsequent queries. The datasources that support the ACL functionality are currently: Elasticsearch, Oracle, Knowi Elasticstore

Parametrized Report Templates The Email Report function has been enhanced to pass in user-lever query filters, ensuring only the data the recipient is allowed to see is contained within the report. Any dataset attachments also adhere to the passed in parameters.

A new CLoud9QL function has been added that allows you to control the display of numerical values. The format is NUMBER_FORMAT(<number>,<format>), and an example is: select number_format(clicks,##,###.00) as Number of clicks