Knowi Product Update Q4 2017
To see these exciting new capabilities in action, please join Lorraine Williams, Head of Success at Knowi, for a web demo on Wednesday, January 31th at 11:00 AM PT.
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 Builder
In 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.
In 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 Draft
You now have the ability to save a query in progress without creating an associated dataset and widget. Go for that coffee break!
You 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 History
Wondering 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.
Wondering 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-Processing
You can now apply Cloud9QL functions to a dataset post join.
You 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.
Stranger Danger
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
Other Cool Stuff
Email Reporting Improvements
|
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.
|
Analyze Grid Formatting |
A number of usability enhancements we made including:
|
Embed API Formatting |
An option has been added into the JS Embed API that allows for auto-sizing of content based upon the full height of the dashboard.
|
New Datasources |
Added support for
|
Cloud9QL Enhancements |
Cloud9QL Function AutoComplete
When adding a function in Analyze or preview modes, the system now gives a dropdown list of C9QL functions available along with autocompleting capability
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
If your data is a JSON string, the PARSE function can be used to convert it into an object which can then be further manipulated and processed.
Provide an alternate value to be used in case the specified field doesn't exist or the value is NULL.
|
Please sign in to leave a comment.
0 comments