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.
CDF_READ
Reading the change data feed from table <tableName> using table_changes() function is not supported. Please remove the table_changes() usage and retry the transaction.
COLUMN_MAPPING_MODE_CHANGE_IN_CDF
Column mapping mode change detected on table <tableName>. Changing column mapping mode on tables with CDF enabled is not supported in a multi-statement transaction.
COMMAND
Command <command> is not supported in a multi-statement transaction. Only SELECT / INSERT / MERGE / UPDATE / DELETE are supported.
FGAC_ON_DEDICATED_COMPUTE
Accessing table <tableName> with fine-grained access control on a dedicated compute cluster is not supported in a multi-statement transaction. If this transaction does not involve dynamic views, row filters, or column masks, you can retry with a standard compute cluster instead.
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.
INFORMATION_SCHEMA_TABLE
Accessing tables from INFORMATION_SCHEMA (<tableName>) is not supported 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.
MAX_INTERMEDIATE_COMMITS_EXCEEDED
You cannot perform more than <maxCommits> commits on table <table> in a single transaction.
MAX_TABLES_ACCESSED_EXCEEDED
You cannot access more than <maxTables> tables in a single transaction.
MAX_TABLES_WRITTEN_EXCEEDED
You cannot write to more than <maxTables> tables in a single transaction.
MAX_TRANSACTION_DURATION_EXCEEDED
Exceeded the maximum transaction duration of <maxDurationMinutes> minutes.
NESTED_TRANSACTION
Nested transactions are not supported.
PATH_BASED_ACCESS
Accessing tables by path (<path>) is not allowed in a multi-statement transaction. Please use table names instead.
PREVIEW_NOT_ENABLED
Multi-statement transactions are not enabled for this workspace. Please contact your Databricks support representative to enable this feature.
SYSTEM_TABLE
Accessing system table <tableName> is not supported in a multi-statement transaction.
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.
VIEW_FROM_DATA_FRAME
Accessing view <viewName> is not supported in a multi-statement transaction because it was created using the DataFrame API. Please create the view using SQL instead.
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
One of the tables that is being written to is not a Delta table. Only Delta tables can be written to 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.
WRITE_VIEW
Writing to view <viewName> is not supported in a multi-statement transaction. Please write directly to the underlying table instead.