Skip to main content
Last updated on

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 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 transaction.

COMMAND​

Command <command> is not supported in a transaction. Only SELECT / INSERT / MERGE / UPDATE / DELETE are supported.

DELTA_SHARING​

Accessing delta sharing table <tableName> is not supported in a multi-statement transaction.

FGAC_ON_DEDICATED_COMPUTE​

Accessing table <tableName> with fine-grained access control on a dedicated compute cluster is not supported in a 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 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 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 transaction.

INFORMATION_SCHEMA_TABLE​

Accessing tables from INFORMATION_SCHEMA (<tableName>) is not supported in a transaction.

INTERACTIVE_TRANSACTION​

Interactive transactions (BEGIN TRANSACTION… COMMIT) can only be run against Databricks SQL warehouses. To execute multiple SQL statements atomically in the current context, please use SQL scripting syntax with BEGIN ATOMIC ... END; blocks (<docLink>).

INTERACTIVE_TRANSACTION_OLD_SQL_EDITOR​

Interactive transactions are not supported in the legacy SQL Editor. Switch to the new SQL Editor (<docLink>) or use a notebook connected to a Databricks SQL warehouse.

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 transaction. Please use table names instead.

PREVIEW_NOT_ENABLED​

Transactions are not enabled for this workspace. Please contact your Databricks support representative to enable this feature.

SQL_SCRIPT_TRANSACTION_COMMAND​

Transaction command <command> is not supported in SQL scripts. To execute multiple SQL statements atomically in a SQL script, please use BEGIN ATOMIC ... END; blocks.

SYSTEM_TABLE​

Accessing system table <tableName> is not supported in a transaction.

TIME_TRAVEL_QUERY​

Time travel queries are not supported in a 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 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 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 transaction.

WRITE_NON_DELTA_TABLE_WITH_NAME​

Table <tableName> is not a Delta table. Only Delta tables can be written to in a transaction.

WRITE_NON_UC_MANAGED_TABLE​

Table <tableName> is not UC-managed. Only UC-managed tables can be written in a transaction.

WRITE_TABLE_WITH_CDF​

Table <tableName> has Change Data Feed enabled. Writing to tables with this feature enabled is not supported in a transaction.

WRITE_VIEW​

Writing to view <viewName> is not supported in a transaction. Please write directly to the underlying table instead.