Skip to main content
Solya’s analytics run on a Databricks lakehouse with two layers. This catalog lists the tables; for the operational (app-managed) data, see Data model.

​
Layers

  • Silver — cleaned, normalized source data (dimensions and conformed entities) produced by ingestion.
  • Gold — business-ready analytics: facts, snapshots, summaries, trends, forecasts, and AI decision data. This is what dashboards, KPIs, search, alerts, and recommendations read.
Browse any of these tables directly in the datasets explorer (filter, paginate, export).

​
Gold layer

​
Facts (transactions)

​
Stock

​
Dimensions

​
Summaries

​
Silver layer

​
Reading these in the app

The app references gold/silver columns through typed constants (under src/constants/datasetColumns/{gold,silver}/) so SQL stays in sync with the schema — a column rename surfaces as a TypeScript error rather than a silent bug. You don’t query these tables directly via the public API; instead, the dedicated endpoints (analytics, search, risks, forecasts) read them for you — see API recipes.
These are read-only analytics tables, populated by the data platform. App-managed data you create (plans, rules, alerts, tags…) lives in the operational database — see Data model.