Skip to content

Latest commit

 

History

History
127 lines (100 loc) · 13.8 KB

dialects.md

File metadata and controls

127 lines (100 loc) · 13.8 KB

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
Snowflake Snowflake JDBC Snowflake 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.