dbx.healthjump.com is a Datavant Site Connect tool that allows you to query, visualize and collaborate on data sources from anywhere in no time.
It allows you share your results and dashboards with other team members and empower your entire organization to be data-driven with no-code filters and parameters that instantly adjust. Get alerts for pre-defined triggers to your email, Slack, or Hipchat.
Once set up, your users will receive an email inviting them to join. Once within the app, follow the below steps to begin exploring your data.
To start working on a new query, click Create in the navigation bar and then select Query:
Publish/Unpublish
By default, each query starts in a draft state (Unpublished), which means that:
- Only the user who created this query can see it in the All Queries list or in search results.
- You can’t add visualisations from an unpublished query to dashboards or use it in alerts.
To publish a query you can simply give it a name or click the Publish button. It’s also possible to unpublish a published query by clicking on the Unpublish button in the query menu.
Query Syntax
In most cases, we use the data source's native query language. <Amazon Redshift>.
Schema Browser and Autocomplete
To the left of the query editor, you will find the Schema Browser:
The schema browser will list all your tables, and when clicking on a table will show its columns. To insert an item into your query, simply click the double arrow on the right side. You can filter the schema with the search box and refresh it by clicking on the refresh button (otherwise it refreshes periodically in the background).
Beside the schema browser, dbx.healthjump.com supports autocomplete while typing your query. The autocomplete is automatically triggered, unless you have a large schema (>5000 tokens - tables and columns). In case of a large schema, the autocomplete can be manually triggered with Ctrl + Space.
Keyboard Shorcuts
- Execute query:
Ctrl/Cmd+Enter - Save query:
Ctrl/Cmd+S
Additional Query Actions
Archiving a Query
Once a query is no longer useful, you can archive it. Archiving is almost the same as deleting, except that direct links to the query will still work. To archive a query, open the little menu at the top-right area of the query editor, next to the Save button and click Archive:
Duplicating (Forking) a Query
If you need to create a copy of an existing query (created by you or someone else), you can fork it. To fork a query, just click on the Fork button:
