JupiterOne Query Builder
JupiterOne is a cybersecurity data platform built on top of a proprietary query language for graph databases (J1QL).
Since J1QL is a proprietary language, to get the most from the platform you need to:
- Learn J1’s data model (100+ data classes, 1000+ data types)
- Learn J1QL - a programming language that has no value outside of JupiterOne
This was a tall ask for many potential customers.
The company had a time-to-value problem: prospective customers could see the promise of the platform, but often couldn’t get over the required investment to realize its full potential.
To address this, we decided to create a visual interface that allowed users to build queries without knowing the J1QL language. It was meant to guide customers toward constructing valid queries that would help them get as much value as possible from the platform quickly.
I paired with a senior engineer to design and develop this new feature set. We worked together from start to finish: from doing technical discovery to talking with our solutions architects to prototyping and delivery.
After 3 months we had enough for our first release. We got immediate positive feedback from existing customers, the sales team, and prospects which gave us confidence to follow up with a more refined iteration introducing more advanced features we had held back from the first release.
The screens below show the evolution from the first release to the second iteration. The main new features we added enhanced the specificity of the queries a user could build:
- Optional graph traversals
- Directionality of the relationships between graph nodes
Don’t worry, you don’t have to understand what those terms mean to catch the visual differences. But I wanted to include this work because it shows the level of visual and interaction detail we went into to get this right, even with such a targeted update.