Exasol Virtual Schemas are an abstraction layer that makes external data sources accessible in our data analytics platform through regular SQL commands. The contents of the external data sources are mapped to virtual tables which look like and can be queried as any regular Exasol table.
Regardless of whether that source is a relational database like ours, or it's like the structure of GitHub repositories, the interface that users see is always the same.
This means an user familiar with SQL will immediately feel at home when accessing remote data through Virtual Schemas.
Virtual Schemas can be also described in known terms as External Tables or Foreign Data Wrapper (FDW).
| Virtual Schema | Required Java Version | Lifecycle |
|---|---|---|
| 4.x.x | 11 | supported, active development |
| 3.x.x | 11 | supported |
| 2.x.x | 9 | discontinued |
| 1.x.x | 8 | discontinued |
| Exasol Version | Java Version Installed by Default in Language Container |
|---|---|
| 7.0 | 11 |
| 6.2 | 11 |
| 6.1 | 9 |
| 6.0 | 8 |
Note that you can update Exasol 6.0.x and 6.1.x with script language containers version 2019-11-26 or newer in order to get Java 11 support. We recommend the updating Exasol installation to at least 6.2.3 or newer for best results.
Please do not try to install language containers with lower Java versions on newer Exasol installations. This is untested.
Please contact the Exasol Support Team if you need help upgrading the language container.
The runtime dependencies are specified for each dialect in their own repository.
Please use the entry point
com.exasol.adapter.RequestDispatcher
in all your CREATE JAVA ADAPTER SCRIPT statements. The old entry point was removed with the Version 2.0.0 of Exasol's Virtual Schema.
- Read only access to data on remote data sources (see the Supported Data Sources below)
- Data in those sources appears as tables inside Exasol and can be queried using regular SQL statements.
- Pushes down queries to the remote source (some sources)
- Supports sources with no / one / multiple catalogs or schemas
- Allows limiting metadata mapping to selected catalogs and / or schemas
- Allows redirecting log output to a remote machine
- Allows remote debugging with the Java Debugger
- The Virtual Schema adapter takes about 1s to start. That means that queries that involve tables from Virtual Schema will take at least 1s.
This is an open source project which is officially supported by Exasol. For any question, you can contact our support team.
NOTE: For reporting an issue for a specific dialect, please do it in the dialect repository (see the Supported Data Sources above)
Additional resources: