Skip to main content

Compatibility with Databases

This page list the Databases and their versions supported by DirectQuery.

The following notations are used:

SymbolMeaning
tickfully supported
pluspartially supported
crosswill not be supported

Managed Databases​

DirectQuery can connect to various managed Databases, such as Snowflake or BigQuery. These Database systems automatically updates. ActiveViam will manage DirectQuery dependencies to remain compatible with the only available versions of these databases.

Database6.0
Amazon Redshifttick
Google BigQuerytick
Microsoft Azure Synapsetick
Snowflaketick

Self-hosted Databases​

DirectQuery can connect to a limited set of self-hosted Databases. For these Databases, we will support a limited range of versions, range being decided on case by case.

ClickHouse​

Version6.0
23.3.2.37 (LTS)tick
22.8.17.17 (LTS)tick
22.3.20.29 (LTS)tick
21.3.20.1 (LTS)tick

Note: DirectQuery is also internally tested against the very latest stable version of ClickHouse. As releases of ClickHouse happen at a regular pace, this information is changing too frequently to figure in this document. Users are free to open support questions to check if a particular version is supported.

Support policy: ClickHouse releases 2 LTS per year, each one having a lifespan of 1 year. At every minor version release of Atoti Server, DirectQuery supports the 2 most recent LTS releases.
In maintenance and bugfix releases, support for a new ClickHouse LTS may be added as a backward-compatible feature.
This policy guarantees any specific ClickHouse LTS version to be supported throughout the lifespan of a given Atoti Server minor version.

Microsoft SQL Server​

Version6.0
2022-CU4tick
2019-CU20tick
2017-CU31tick

Notes:

  • GA = General Availability - when the version is officially available and supported.
  • CU = Cumulative Update - a periodic release that includes bug fixes, security fixes, and occasionally a small feature.