Share via


MULTI_STATEMENT_TRANSACTION_NOT_SUPPORTED error condition

SQLSTATE: 0A000

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.