---
title: "Data Sources"
id: "1755"
type: "page"
slug: "data-sources"
published_at: "2026-09-20T21:16:34+00:00"
modified_at: "2026-09-21T01:36:28+00:00"
url: "https://xedant.com/agents/analytics/docs/data-sources"
markdown_url: "https://xedant.com/agents/analytics/docs/data-sources.md"
excerpt: "Data sources are connected in the “Data Sources” section of the web interface: creating, connection…"
---

# Data Sources

[https://xedant.com/agents/analytics/docs/data-sources.md](https://xedant.com/agents/analytics/docs/data-sources.md)

Data sources are connected in the “Data Sources” section of the web interface: creating, connection checks, source details. Three database engines are supported — SQLite, PostgreSQL and ClickHouse.

## Source types

- **SQLite** — path to the database file, timeout (30 s by default), read-only mode;
- **PostgreSQL** — host, port (5432), database, login, password, SSL, timeout;
- **ClickHouse** — host, HTTP port (8123), database, login, password, SSL, timeout.

## Schema and result caching

- schema auto-detection (`autoDetect`) — tables and columns are picked up automatically;
- periodic schema refresh — by default once every 3600 seconds;
- table caching (`cacheTables`) — the schema is not requested anew for every report;
- caching of query results with statistics and cleanup — details in the [Queries](/agents/analytics/docs/queries) section.

## Validation

`DataSourceValidationService` checks source availability: connection errors are visible before reports are built, not on a broken dashboard. A non-existent source in a block query is caught by the validator (`DATA_SOURCE_NOT_FOUND`).

## File data without setup

If your data lives in files — Parquet, SQLite, Markdown — you don’t need to configure a source: put the files into the Lakehouse folder and query them right from the file browser. Details in the [Lakehouse](/agents/analytics/docs/lakehouse)
 section.

A SQLite file in the root of the Lakehouse folder is discovered automatically and shown as a ready source: it is marked with a “lakehouse” icon in the list, and the connection is read-only. You don’t need to configure anything; if you want your own variant, create a regular source with the same name — your setting takes priority over the discovered one.

[← Back to the documentation index](/agents/analytics/docs)