Skip to main content

Product Versions

This document aims to give an overview of all active product versions in Holistics.

👉 Check your current version

Main Versions

There are three main Holistics versions:

  • Version 2.0 (SQL Reporting): This version involves building reports directly by writing SQL. This version is no longer being actively developed.
  • Version 3.0 (Modelling-based Reporting): The key differences in this version are our modeling-centric layer, self-service analytics, modelling/datasets-based reports. This version is no longer being actively developed.
  • Version 4.0 (3.0 + Analytics-as-code): Our latest, actively developing version. Its key concepts include Analytics-as-code (with AMQL development, Holistics's Modeling & Querying languages), Git Version Control, and dbt Integration.

Both version 2.0 and 3.0 are currently in maintainence mode (no new feature development). If you're on these 2 versions, consider migrating to the latest version.

To differentiate these three main versions in details, please take a glance at the following table:

ConceptDescriptionVersion 2.0Version 3.0Version 4.0

Development Status

🟠 Maintain🟠 MaintainActive

Data Modeling Layer

A real-time layer above the database that centralizes all data components and logics of an organization

Data Importing

The process of transferring data from other source into SQL database

Data Transformation

The process of centralizing and optimizing SQL logic by pre-transforming data

Self-service Analytics

The process of analyzing and examining data sets to discover patterns, relationships, and other insights


The process of preparing and presenting reports, allowing users to share actionable insights and make informed decisionsBuild reports by writing SQL queriesBuild reports by drag-and-dropBuild reports by drag-and-drop

Analytics As-Code

The ability to do analytics work using Holistics's code language (AMQL)

Git Version Control

Utilizes Git for code management, allowing users to track changes, create branches, and review code for quality and collaboration.

dbt Integration

Connects dbt transformations with BI tools, improving metadata consistency and reporting accuracy

User Roles

Learn more about User Roles in Holistics

Admin, Analyst, ViewerAdded: ExplorerAdded: Explorer

Transitional Versions (Holistics 2.5 and 2.7)

In the past, Holistics developed the two transitional versions to provide a stable release for 2.0 customers who were not yet ready to migrate to version 3.0.

  • Version 2.5: A combination of 2.0 and 3.0 where you can both keep the old way to create reports from SQL and experience our Data Modeling Layer.
  • Version 2.7: A more stable and upgraded version than Holistics 2.5, where 2.0 and 3.0 features are used and managed separately. Hence, it provides 2.0 customers a clearer migration path to 3.0 version.

Both of our transitional versions are no longer active and not stable long-term. If you're on one of these plans, to request an upgrade to Holistics 3.0, please fill in this form.

Let us know what you think about this document :)