Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
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.
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
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.
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
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.