dialects.md

Supported Dialects

Dialect name	Source	Type	Repository	Latest release
Athena	AWS	JDBC	Athena Virtual Schema	Latest release
Aurora	AWS	JDBC	See MySQL or PostgreSQL VS (interface-compatible)
Azure Blob Storage document files	Microsoft	document	Azure Blob Storage document files Virtual Schema	Latest release
Azure Data Lake Storage Gen2 document files	Microsoft	document	Azure Data Lake Storage Gen2 document files Virtual Schema	Latest release
BucketFS document files	Exasol	document	BucketFS document files Virtual Schema	Latest release
DB2	IBM	JDBC	DB2 Virtual Schema	Latest release
Dynamo DB	AWS	document	Dynamo DB Virtual Schema	Latest release
ElasticSearch		JDBC	ElasticSearch	Latest release
Exasol	Exasol	JDBC *)	Exasol Virtual Schema	Latest release
Google Big Query	Google	JDBC	Big Query Virtual Schema	Latest release
Google Cloud Storage document files	Google	document	Google Cloud Storage document files Virtual Schema	Latest release
HANA	SAP	JDBC	Hana Virtual Schemas	Latest release
Hive	Apache	JDBC	Hive Virtual Schemas	Latest release
Impala	Apache	JDBC	Impala Virtual Schema	Latest release
MySQL		JDBC	MySQL Virtual Schema	Latest release
Oracle	Oracle	JDBC	Oracle Virtual Schema	Latest release
PostgreSQL		JDBC	PostgreSQL Virtual Schema	Latest release
Redshift	AWS	JDBC	Redshift Virtual Schema	Latest release
S3 document files	AWS	document	S3 document files Virtual Schema	Latest release
SQL Server	Microsoft	JDBC	SQL Server Virtual Schema	Latest release
Sybase ASE	Sybase	JDBC	Sybase Virtual Schema	Latest release
Generic JDBC **)	any JDBC	JDBC	Generic Virtual Schema	Latest_release

*) The Virtual Schema for Exasol databases supports three connection variants in total:

• Import from JDBC
• Using EXA Import
• Using IS_LOCAL

**) The generic JDBC Virtual Schema is a fallback solution. It does not support any other push-down capabilities than accessing table contents.

If your database is not part of that list but provides a JDBC driver, try to use the Generic driver. You can also develop a custom dialect.