MULTI_STATEMENT_TRANSACTION_NOT_SUPPORTED error condition
Failed to execute the statement.
ACCESS_DELTA_TABLE_WITH_RLS_CM
Table <tableName> has row filters and/or column masks configured, which are not supported in a multi-statement transaction. You can run the statement outside of transaction block instead.
COMMAND
Command <command> is not supported in a multi-statement transaction. Only SELECT / INSERT / MERGE / UPDATE / DELETE are supported.
ILLEGAL_DATA_SOURCE_FOR_NONTRANSACTIONAL_READ
The data source <name> has format <format>, which is not allowed to be read nontransactionally in a multi-statement transaction. The allowed formats are: <allowedFormats>.
ILLEGAL_DATA_SOURCE_FOR_TRANSACTIONAL_READ
The data source <name> has format <format>, which cannot be read transactionally in a multi-statement transaction. If you want to read it nontransactionally instead, please specify explicitly by appending 'WITH (<optionKey> = true)' to the data source name.
ILLEGAL_ENTITY_ACCESS
The entity <entityName> of type <entityType> cannot be accessed in a multi-statement transaction.
INTERACTIVE_TRANSACTION
Interactive multi-statement transactions are not supported in the current context. To execute multiple SQL statements atomically, please use SQL scripting syntax with BEGIN ATOMIC ... END; blocks.
NESTED_TRANSACTION
Nested transactions are not supported.
PATH_BASED_ACCESS
Table <tableName> is not a UC-managed table. Only UC-managed tables can be written in a multi-statement transaction. Please migrate the table to Unity Catalog and retry the query or command.
PREVIEW_NOT_ENABLED
Multi-statement transactions are not enabled for this workspace. Please contact your Databricks support representative to enable this feature.
TIME_TRAVEL_QUERY
Time travel queries are not supported in a multi-statement transaction. Please remove the temporal specification when referring to table <tableName> and then retry the transaction.
WRITE_NON_CATALOG_OWNED_TABLE
Table <tableName> does not have table feature '<feature>' enabled. Only tables with this feature enabled can be written to in a multi-statement transaction. Please enable this feature and then retry the transaction.
WRITE_NON_DELTA_TABLE
The written table is not a Delta table. Only Delta tables can be written in a multi-statement transaction.
WRITE_NON_DELTA_TABLE_WITH_NAME
Table <tableName> is not a Delta table. Only Delta tables can be written to in a multi-statement transaction.
WRITE_NON_UC_MANAGED_TABLE
Table <tableName> is not UC-managed. Only UC-managed tables can be written in a multi-statement transaction.
WRITE_TABLE_WITH_CDF
Table <tableName> has Change Data Feed enabled. Writing to tables with this feature enabled is not supported in a multi-statement transaction.