Connect Data Sources

This page outlines the essential concepts you need to understand when connecting and working with data sources in KX Dashboards.

A data source is a configuration that retrieves data from a connected database or service. It powers dashboard components like grids, charts, and forms.

The following sections explain how to connect to data, run queries, and interact with datasets in KX Dashboards, enabling you to view and analyze real-time and historical data.

Creating and Configuring Data Sources

Data sources are created via the Data dialog, accessible from each component’s properties.

  • You can define a connection, write a query, and preview results before applying them to components.

  • Configuration options include auto-execution, max rows, and subscription types for real-time updates.

Query Types

KX Dashboards supports multiple query methods:

  • SQL: Standard SQL queries (requires specific setup).

  • kdb+/q: Native q language queries for kdb+ databases.

  • Builder: A visual, no-code query builder.

  • Analytic: Predefined analytic functions.

  • Python: Python-based queries (requires PyKX).

  • Streaming: Real-time data queries.

  • Virtual: JavaScript-based queries for advanced use cases.

Advanced Features

The following features offer advanced ways to interact with and manipulate data within your dashboards, enabling greater flexibility and control:

  • Pivot queries: Special configurations for pivot grid components.

  • Update Queries: Allow writing back to the database from components like the Data Grid.

  • View State Mapping: Enables dynamic interaction between data sources and dashboard state.

Further Reading