Skip to content

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