Compatibility with Databases
This page list the Databases and their versions supported by DirectQuery.
The following notations are used:
| Symbol | Meaning |
|---|---|
 | fully supported |
 | partially supported |
 | will 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.
| Database | 6.0 |
|---|---|
| Amazon Redshift | |
| Google BigQuery | |
| Microsoft Azure Synapse | |
| Snowflake | |
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
| Version | 6.0 |
|---|---|
| 22.3.6.5 (LTS) | |
| 21.3.20.1 (LTS) | |
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.
Microsoft SQL Server
| Version | 6.0 (since 6.0.2) |
|---|---|
| 2017-CU31 | |
| 2019-CU18 | |
| 2022-GA | |
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.