Querying Data Overview
This section details some of the ways in which users can query the data, ingested in the previous section. Users can take advantage of two main methods for querying data. Click on the links below to learn more:
Using the UI
Explore Lets you query your data using kdb+/q or sql. The dropdown shows the available assemblies along with any gateway processes. Freeform queries can be run against these and output will be shown in the table or chart below.
Streams Gives users subscription access to real time data streams, allowing them to be queried as tables or visualized as data-charts
Using the REST API
Via the API the Service Gateway offers an authenticated, secure and OpenAPI compatible API to retrieve data from the system using the getData API
Prefer to use SQL? the KX Insights Platform allows SQL queries to be submitted against databases via the UI in self managed sandboxes or RESTfully via manually created sandboxes.