Query interface

The query interface can be interacted with using REST or directly with the Service Gateway using q interprocess communication.

APIs

• getData - Retrieve data from a table in kdb Insights.

• getMeta - Retrieve query and aggregation metadata for all data in the system. -getMeta v2 - Retrieve query and aggregation metadata for all data in system, with labels support. -getMeta v3 - Retrieve query and aggregation metadata for all data in the system, with enhanced User Defined Analytic information.

• ping - Check the status of a Data Access Process.

• qsql - Execute a qSQL query on a specific tier of a database.

• sql - Execute an SQL query across a database.

• sql2 - Execute an SQL2 query across a database.

• preview - Efficiently retrieve a small sample of a table