This article describes the snapshot mode in Exasol.
To avoid transaction conflicts, you can run SQL statements in snapshot mode. This feature is especially useful when making frequent queries to the metadata system tables, as such queries can lead to delayed execution caused by transaction management. For example, BI tools and other front end systems need metadata from Exasol to display information about existing tables. If there is any information that cannot be retrieved through regular metadata calls on API level, you have to fall back to SQL queries on the system tables.