Connectivity policy

Mode currently supports connectivity to customer data using Java Database Connectivity (JDBC) drivers. Mode does not write JDBC drivers. We contract the use of proprietary JDBC drivers or use established & well-supported open source JDBC drivers.

For Preferred & Supported databases, Mode ensures functionality for all versions of the database server currently actively maintained by the database vendor. Mode does not ensure continued functionality for database server versions that have reached end of life or for database types that are not explicitly supported.

Mode will usually support or recommend only one driver per database type. However, to enable customers flexibility during their update process, we will enable customers to use either the recommended or the most recent version until the next update (either 6 or 12 months). Mode will usually provide 2 months’ notice to customers before driver removal, although we reserve the right to remove drivers with known security issues on less notice.

Driver deprecation

Mode will mark for deprecation and set removal dates for older versions of drivers. We generally set removal dates for the oldest drivers 2 months out, when adding new versions of drivers.

Drivers that are past their removal date cannot be used to connect to Mode. The removed driver will no longer be available in the Preferred JDBC driver dropdown of the connection’s details.

On the removal date, any connections still using that driver will be updated by Mode to use the latest recommended driver. This may cause connectivity issues. Mode encourages customers to update their preferred drivers shortly following announced updates.

Support levels

For the listed database types below, Mode aims to support all versions of the database actively supported by the database vendor or appropriate open source community.

Tier 1: Preferred

These database and integration types are fully supported by Mode and drivers are upgraded at least semi-annually. We are committed to improving the experience of users connecting Mode to datasources of these types, and will fix issues based on severity and demand. As part of our release process, Mode runs exhaustive integration tests against all types in this tier to ensure quality.

Database / Integration Type	Database Version Support	Bridge
Amazon Redshift		Optional
PostgreSQL	9.5, 9.6, 10, 11, 12, 13, 14, 15	Optional
MySQL	5.6, 5.7, 8.0	Optional
Google BigQuery		Not Supported
Snowflake		Optional
Amazon Athena		Not Supported
Microsoft SQL Server	2012, 2014, 2016, 2017, 2019	Optional
Starburst	versions up to 413	Optional
Trino (formerly PrestoSQL)	versions up to 413	Optional
Hive	1.0.0 - 3.1	Optional
Google AlloyDB		Optional
Azure SQL Database		Optional
Azure Synapse SQL		Optional
dbt Semantic Layer		Not Supported
Looker SQL		Not Supported

Tier 2: Supported

These database types are fully supported by Mode and drivers are upgraded annually. We are committed to improving the experience of users connecting Mode to datasources of these types, and will fix issues based on severity and demand. As part of our release process, Mode runs integration tests against all types in this tier to ensure quality.

Database Type	Database Version Support	Bridge
Oracle	11.2, 12.1, 12.2, 18c, 19c, 21c	Required
Oracle Autonomous Database		Optional
ClickHouse		Optional
Cube		Not Supported
Dremio		Not Supported
Impala	2.8 - 3.2	Required
Google Cloud SQL MySQL		Optional
Google Cloud SQL PostgreSQL		Optional
Google Cloud SQL SQL Server		Optional
Amazon Aurora MySQL		Optional
Vertica	7.2 - 10.1.1	Required
Databricks		Optional
SingleStore		Optional
Teradata		Optional
Amazon Aurora PostgreSQL		Optional
Treasure Data		Optional
Apache Druid	0.20.1	Required
Denodo	8.0	Optional
Arrow Flight SQL		Not Supported

Tier 3: Works, not Supported

These database types are partially supported by Mode, but the database vendor’s recommended driver is not used. Mode is able to connect to these database types because of similarities of SQL dialects or shared database servers. Mode makes no commitment to improve implementation, fix issues, or regularly run tests against these database types.

Database Type	Database Version Support	Bridge
MariaDB		Optional
Tenjin		Optional
MemSQL		Not Supported
Citus		Not Supported
Timescale		Not Supported
mParticle		Optional
Spark	1.6, 2.1 - 3.0	Optional
PrestoDB	up to version 0.240	Optional

Databases

Amazon Athena

Supported JDBC drivers and known issues

Driver	Driver Release Date	Mode Removal Date
(Recommended) Amazon v 3.2.2	7/22/2024
Simba v 2.1.1.1001	7/31/2023
Simba v 2.0.35.1001	12/22/2022
Simba v 2.0.33.1001	10/4/2022	4/2/2025
Simba v 2.0.31.1001	5/30/2022	4/2/2025
Simba v 2.0.27.1001	1/13/2022	4/2/2025
Simba v 2.0.23.1000	6/10/2021	4/2/2025
Simba v 2.0.18.1000