SQLSTATE codes

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 12.2 and above

All error classes returned by Azure Databricks are associated with a 5 character SQLSTATE. A SQLSTATE is a SQL standard encoding for error conditions commonly used by JDBC, ODBC, and other client APIs.

A SQLSTATE consists of two portions: A two character class, and a three character subclass. Each character must be a digit '0' to '9' or 'A' to 'Z'.

While many SQLSTATE values are prescribed by the SQL standard, others are common in the industry, specific to Spark, or Azure Databricks.

Where neccessary Spark and Azure Databricks use the 'KD' class and 'K**' subclass ranges for custom SQLSTATEs. The class 'XX' is used for internal errors warranting a bug report.

For an ordered list of error classes see: Error handling in Azure Databricks

Azure Databricks uses the following SQLSTATE classes:

Class 07: dynamic SQL error

SQLSTATE Description and issuing error classes
07001 using clause does not match dynamic parameter specifications
ALL_PARAMETERS_MUST_BE_NAMED
07501 The option specified on PREPARE or EXECUTE is not valid.
INVALID_STATEMENT_FOR_EXECUTE_INTO, NESTED_EXECUTE_IMMEDIATE

Class 08: connection exception

SQLSTATE Description and issuing error classes
08000 connection exception
AI_FUNCTION_HTTP_REQUEST_ERROR, AI_FUNCTION_INVALID_HTTP_RESPONSE, CANNOT_VALIDATE_CONNECTION
08001 SQL-client unable to establish SQL-connection
CANNOT_ESTABLISH_CONNECTION, CANNOT_ESTABLISH_CONNECTION_SERVERLESS
08003 connection does not exist
DELTA_ACTIVE_SPARK_SESSION_NOT_FOUND
08KD1 server busy
SERVER_IS_BUSY

Class 0A: feature not supported

SQLSTATE Description and issuing error classes
0A000 feature not supported
AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AVRO_DEFAULT_VALUES_UNSUPPORTED, AVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTED, CANNOT_INVOKE_IN_TRANSFORMATIONS, CANNOT_SAVE_VARIANT, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SOURCE_UNSUPPORTED, CF_STATEFUL_STREAMING_SCHEMA_EVOLUTION, CF_UNSUPPORTED_CLOUD_FILES_SQL_FUNCTION, CF_UNSUPPORTED_FORMAT_FOR_SCHEMA_INFERENCE, CF_UNSUPPORTED_LOG_VERSION, CF_UNSUPPORTED_SCHEMA_EVOLUTION_MODE, CLASS_UNSUPPORTED_BY_MAP_OBJECTS, CLEANROOM_COMMANDS_NOT_SUPPORTED, COLUMN_MASKS_CHECK_CONSTRAINT_UNSUPPORTED, COLUMN_MASKS_FEATURE_NOT_SUPPORTED, COLUMN_MASKS_INCOMPATIBLE_SCHEMA_CHANGE, COLUMN_MASKS_MERGE_UNSUPPORTED_SOURCE, COLUMN_MASKS_MERGE_UNSUPPORTED_TARGET, COLUMN_MASKS_REQUIRE_UNITY_CATALOG, COLUMN_MASKS_TABLE_CLONE_SOURCE_NOT_SUPPORTED, COLUMN_MASKS_TABLE_CLONE_TARGET_NOT_SUPPORTED, COLUMN_MASKS_UNSUPPORTED_PROVIDER, COLUMN_MASKS_UNSUPPORTED_SUBQUERY, CONCURRENT_QUERY, CONSTRAINTS_REQUIRE_UNITY_CATALOG, COPY_INTO_CREDENTIALS_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_ALLOWED_ON, COPY_INTO_ENCRYPTION_NOT_SUPPORTED_FOR_AZURE, COPY_INTO_SOURCE_FILE_FORMAT_NOT_SUPPORTED, CREATE_OR_REFRESH_MV_ST_ASYNC, CREATE_PERMANENT_VIEW_WITHOUT_ALIAS, CSV_ENFORCE_SCHEMA_NOT_SUPPORTED, DC_FEATURE_NOT_ENABLED, DC_UNSUPPORTED_ERROR, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTED, DELTA_CLUSTERING_SHOW_CREATE_TABLE_WITHOUT_CLUSTERING_COLUMNS, DELTA_CLUSTERING_WITH_PARTITION_PREDICATE, DELTA_DOMAIN_METADATA_NOT_SUPPORTED, DELTA_DYNAMIC_PARTITION_OVERWRITE_DISABLED, DELTA_NESTED_SUBQUERY_NOT_SUPPORTED, DELTA_NOT_NULL_NESTED_FIELD, DELTA_OPERATION_ON_TEMP_VIEW_WITH_GENERATED_COLS_NOT_SUPPORTED, DELTA_SOURCE_IGNORE_DELETE, DELTA_SOURCE_TABLE_IGNORE_CHANGES, DELTA_UNSUPPORTED_DEEP_CLONE, DELTA_UNSUPPORTED_EXPRESSION, DELTA_UNSUPPORTED_FSCK_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_GENERATE_WITH_DELETION_VECTORS, DELTA_UNSUPPORTED_LIST_KEYS_WITH_PREFIX, DELTA_UNSUPPORTED_MERGE_SCHEMA_EVOLUTION_WITH_CDC, DELTA_UNSUPPORTED_SORT_ON_BUCKETED_TABLES, DELTA_UNSUPPORTED_TRUNCATE_SAMPLE_TABLES, DELTA_UNSUPPORTED_WRITE_SAMPLE_TABLES, DELTA_VIOLATE_TABLE_PROPERTY_VALIDATION_FAILED, DELTA_WRITE_INTO_VIEW_NOT_SUPPORTED, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_INVALID_SCOPE, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, MULTI_UDF_INTERFACE_ERROR, NAMED_PARAMETERS_NOT_SUPPORTED_FOR_SQL_UDFS, NAMED_PARAMETER_SUPPORT_DISABLED, NOT_SUPPORTED_CHANGE_COLUMN, NOT_SUPPORTED_COMMAND_FOR_V2_TABLE, NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT, NOT_SUPPORTED_IN_JDBC_CATALOG, NOT_SUPPORTED_WITH_DB_SQL, PROTOBUF_JAVA_CLASSES_NOT_SUPPORTED, PS_SPARK_SPECULATION_NOT_SUPPORTED, PS_UNSUPPORTED_GET_OFFSET_CALL, RESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCED, ROW_LEVEL_SECURITY_CHECK_CONSTRAINT_UNSUPPORTED, ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_INCOMPATIBLE_SCHEMA_CHANGE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_SOURCE, ROW_LEVEL_SECURITY_MERGE_UNSUPPORTED_TARGET, ROW_LEVEL_SECURITY_REQUIRE_UNITY_CATALOG, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTED, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, STAR_GROUP_BY_POS, STORED_PROCEDURE_NOT_SUPPORTED, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, UC_HIVE_METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UDTF_PYSPARK_NOT_SUPPORTED, UNSUPPORTED_ADD_FILE, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING, UNSUPPORTED_CLAUSE_FOR_OPERATION, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY, UNSUPPORTED_DATATYPE, UNSUPPORTED_DATA_SOURCE_SAVE_MODE, UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE, UNSUPPORTED_DEFAULT_VALUE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_SAVE_MODE, UNSUPPORTED_STREAMING_OPTIONS_FOR_VIEW, UNSUPPORTED_STREAMING_OPTIONS_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SINK_PERMISSION_ENFORCED, UNSUPPORTED_STREAMING_SOURCE_PERMISSION_ENFORCED, UNSUPPORTED_STREAM_READ_LIMIT_FOR_KINESIS_SOURCE, UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY, UNSUPPORTED_TIMESERIES_WITH_MORE_THAN_ONE_COLUMN, UNSUPPORTED_TRIGGER_FOR_KINESIS_SOURCE, UNSUPPORTED_TYPED_LITERAL
0AKD0 Cross catalog or schema operation not supported
CANNOT_COPY_STATE, CANNOT_REFERENCE_UC_IN_HMS, CANNOT_RENAME_ACROSS_CATALOG, CANNOT_RENAME_ACROSS_SCHEMA, CANNOT_SHALLOW_CLONE_ACROSS_UC_AND_HMS
0AKD1 Security feature not supported
COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETER, ROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDC Not supported in Delta
DELTA_CANNOT_EVALUATE_EXPRESSION, DELTA_CANNOT_GENERATE_CODE_FOR_EXPRESSION, DELTA_CDC_NOT_ALLOWED_IN_THIS_VERSION, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_DATA_SCHEMA, DELTA_CHANGE_DATA_FEED_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_CLONE_UNSUPPORTED_SOURCE, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMN, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPE, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_INCORRECT_LOG_STORE_IMPLEMENTATION, DELTA_MISSING_PROVIDER_FOR_CONVERT, DELTA_MODE_NOT_SUPPORTED, DELTA_NESTED_NOT_NULL_CONSTRAINT, DELTA_NON_DETERMINISTIC_FUNCTION_NOT_SUPPORTED, DELTA_OPERATION_NOT_ALLOWED, DELTA_OPERATION_NOT_ALLOWED_DETAIL, DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF, DELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED, DELTA_UNIFORM_NOT_SUPPORTED, DELTA_UNSUPPORTED_ABS_PATH_ADD_FILE, DELTA_UNSUPPORTED_ALTER_TABLE_CHANGE_COL_OP, DELTA_UNSUPPORTED_ALTER_TABLE_REPLACE_COL_OP, DELTA_UNSUPPORTED_CLONE_REPLACE_SAME_TABLE, DELTA_UNSUPPORTED_COLUMN_MAPPING_MODE_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_SCHEMA_CHANGE, DELTA_UNSUPPORTED_COLUMN_MAPPING_WRITE, DELTA_UNSUPPORTED_COLUMN_TYPE_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_COMMENT_MAP_ARRAY, DELTA_UNSUPPORTED_DATA_TYPES, DELTA_UNSUPPORTED_DROP_CLUSTERING_COLUMN, DELTA_UNSUPPORTED_DROP_COLUMN, DELTA_UNSUPPORTED_DROP_NESTED_COLUMN_FROM_NON_STRUCT_TYPE, DELTA_UNSUPPORTED_DROP_PARTITION_COLUMN, DELTA_UNSUPPORTED_FIELD_UPDATE_NON_STRUCT, DELTA_UNSUPPORTED_INVARIANT_NON_STRUCT, DELTA_UNSUPPORTED_IN_SUBQUERY, DELTA_UNSUPPORTED_MANIFEST_GENERATION_WITH_COLUMN_MAPPING, DELTA_UNSUPPORTED_MULTI_COL_IN_PREDICATE, DELTA_UNSUPPORTED_NESTED_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_NESTED_FIELD_IN_OPERATION, DELTA_UNSUPPORTED_NON_EMPTY_CLONE, DELTA_UNSUPPORTED_OUTPUT_MODE, DELTA_UNSUPPORTED_PARTITION_COLUMN_IN_BLOOM_FILTER, DELTA_UNSUPPORTED_RENAME_COLUMN, DELTA_UNSUPPORTED_SCHEMA_DURING_READ, DELTA_UNSUPPORTED_SUBQUERY, DELTA_UNSUPPORTED_SUBQUERY_IN_PARTITION_PREDICATES, DELTA_UNSUPPORTED_TIME_TRAVEL_VIEWS, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDD Feature requires Delta
DELTA_COPY_INTO_TARGET_FORMAT, DELTA_NOT_A_DELTA_TABLE, DELTA_ONLY_OPERATION, DELTA_TABLE_ONLY_OPERATION, DELTA_UNSUPPORTED_SOURCE, DELTA_UNSUPPORTED_STATIC_PARTITIONS, SYNC_METADATA_DELTA_ONLY, UNSUPPORTED_MANAGED_TABLE_CREATION
0AKDE Feature non enabled for this Delta table
DELTA_CLUSTERING_PHASE_OUT_FAILED, DELTA_DATA_CHANGE_FALSE, DELTA_FEATURES_PROTOCOL_METADATA_MISMATCH, DELTA_FEATURES_REQUIRE_MANUAL_ENABLEMENT, DELTA_FEATURE_DROP_CONFLICT_REVALIDATION_FAIL, DELTA_FEATURE_DROP_FEATURE_NOT_PRESENT, DELTA_FEATURE_DROP_HISTORICAL_VERSIONS_EXIST, DELTA_FEATURE_DROP_HISTORY_TRUNCATION_NOT_ALLOWED, DELTA_FEATURE_DROP_NONREMOVABLE_FEATURE, DELTA_FEATURE_DROP_UNSUPPORTED_CLIENT_FEATURE, DELTA_FEATURE_DROP_WAIT_FOR_RETENTION_PERIOD, DELTA_FEATURE_REQUIRES_HIGHER_READER_VERSION, DELTA_FEATURE_REQUIRES_HIGHER_WRITER_VERSION, DELTA_UNSUPPORTED_FEATURE_STATUS, WRONG_COLUMN_DEFAULTS_FOR_DELTA_FEATURE_NOT_ENABLED
0AKUC Not supported in Unity Catalog
CANNOT_SHALLOW_CLONE_NESTED, CANNOT_SHALLOW_CLONE_NON_UC_MANAGED_TABLE_AS_SOURCE_OR_TARGET, INVALID_SCHEME, PARTITION_METADATA, UC_BUCKETED_TABLES, UC_COMMAND_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED
0AKUD Feature requires Unity Catalog
FEATURE_REQUIRES_UC, OPERATION_REQUIRES_UNITY_CATALOG, SYNC_METADATA_NOT_SUPPORTED

Class 0B: invalid transaction initiation

SQLSTATE Description and issuing error classes
0B000 invalid transaction initiation
DELTA_ACTIVE_TRANSACTION_ALREADY_SET

Class 0N: SQL/XML mapping error

SQLSTATE Description and issuing error classes
0N000 SQL/XML mapping error
XML_UNSUPPORTED_NESTED_TYPES

Class 21: cardinality violation

SQLSTATE Description and issuing error classes
21000 cardinality violation
ROW_SUBQUERY_TOO_MANY_ROWS, SCALAR_SUBQUERY_TOO_MANY_ROWS
21506 The same row of a table cannot be the target for more than one of an update, delete or insert operation.
DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE
21S01 Insert value list does not match column list
CREATE_VIEW_COLUMN_ARITY_MISMATCH, INSERT_COLUMN_ARITY_MISMATCH, INSERT_PARTITION_COLUMN_ARITY_MISMATCH

Class 22: data exception

SQLSTATE Description and issuing error classes
22000 data exception
AI_FUNCTION_JSON_PARSE_ERROR, CF_BUCKET_MISMATCH, CF_CANNOT_EVOLVE_SCHEMA_LOG_EMPTY, CF_CANNOT_PARSE_QUEUE_MESSAGE, CF_CANNOT_RESOLVE_CONTAINER_NAME, CF_CANNOT_RUN_DIRECTORY_LISTING, CF_DUPLICATE_COLUMN_IN_DATA, CF_EVENT_GRID_AUTH_ERROR, CF_EVENT_GRID_CREATION_FAILED, CF_EVENT_GRID_NOT_FOUND_ERROR, CF_FAILED_TO_CHECK_STREAM_NEW, CF_FAILED_TO_CREATED_PUBSUB_SUBSCRIPTION, CF_FAILED_TO_CREATED_PUBSUB_TOPIC, CF_FAILED_TO_DELETE_GCP_NOTIFICATION, CF_FAILED_TO_DESERIALIZE_PERSISTED_SCHEMA, CF_FAILED_TO_EVOLVE_SCHEMA, CF_FAILED_TO_INFER_SCHEMA, CF_FAILED_TO_WRITE_TO_SCHEMA_LOG, CF_FOUND_MULTIPLE_AUTOLOADER_PUBSUB_SUBSCRIPTIONS, CF_GCP_LABELS_COUNT_EXCEEDED, CF_GCP_RESOURCE_TAGS_COUNT_EXCEEDED, CF_INCOMPLETE_LOG_FILE_IN_SCHEMA_LOG, CF_INCOMPLETE_METADATA_FILE_IN_CHECKPOINT, CF_INVALID_MANAGED_FILE_EVENTS_RESPONSE, CF_LATEST_OFFSET_READ_LIMIT_REQUIRED, CF_LOG_FILE_MALFORMED, CF_MANAGED_FILE_EVENTS_BACKFILL_IN_PROGRESS, CF_METADATA_FILE_CONCURRENTLY_USED, CF_MULTIPLE_PUBSUB_NOTIFICATIONS_FOR_TOPIC, CF_NEW_PARTITION_ERROR, CF_PARTITON_INFERENCE_ERROR, CF_PREFIX_MISMATCH, CF_PROTOCOL_MISMATCH, CF_RESTRICTED_GCP_RESOURCE_TAG_KEY, CF_SAME_PUB_SUB_TOPIC_NEW_KEY_PREFIX, CF_THREAD_IS_DEAD, CF_UNABLE_TO_LIST_EFFICIENTLY, CF_UNEXPECTED_READ_LIMIT, CF_UNKNOWN_READ_LIMIT, DELTA_CANNOT_FIND_BUCKET_SPEC, DELTA_CLUSTERING_COLUMN_MISSING_STATS, DELTA_CLUSTERING_CREATE_EXTERNAL_NON_LIQUID_TABLE_FROM_LIQUID_TABLE, DELTA_COMPACTION_VALIDATION_FAILED, DELTA_CONVERT_TO_DELTA_ROW_TRACKING_WITHOUT_STATS, DELTA_DV_HISTOGRAM_DESERIALIZATON, DELTA_INVALID_FORMAT, DELTA_INVALID_TABLE_VALUE_FUNCTION, DELTA_MATERIALIZED_ROW_TRACKING_COLUMN_NAME_MISSING, DELTA_ROW_ID_ASSIGNMENT_WITHOUT_STATS, DELTA_STREAMING_METADATA_EVOLUTION, DELTA_STREAMING_SCHEMA_EVOLUTION_UNSUPPORTED_ROW_FILTER_COLUMN_MASKS, DELTA_STREAMING_SCHEMA_LOCATION_CONFLICT, DELTA_STREAMING_SCHEMA_LOCATION_NOT_UNDER_CHECKPOINT, DELTA_STREAMING_SCHEMA_LOG_DESERIALIZE_FAILED, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_DELTA_TABLE_ID, DELTA_STREAMING_SCHEMA_LOG_INCOMPATIBLE_PARTITION_SCHEMA, DELTA_STREAMING_SCHEMA_LOG_INIT_FAILED_INCOMPATIBLE_METADATA, DELTA_STREAMING_SCHEMA_LOG_PARSE_SCHEMA_FAILED, HLL_UNION_DIFFERENT_LG_K, INVALID_TIMESTAMP_FORMAT, KAFKA_DATA_LOSS, KINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSET, PS_FETCH_RETRY_EXCEPTION, PS_INVALID_KEY_TYPE, PS_INVALID_UNSAFE_ROW_CONVERSION_FROM_PROTO, PS_MOVING_CHECKPOINT_FAILURE, PS_MULTIPLE_FAILED_EPOCHS, PS_OPTION_NOT_IN_BOUNDS, PS_UNABLE_TO_PARSE_PROTO, STAGING_PATH_CURRENTLY_INACCESSIBLE
22001 string data, right truncation
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003 numeric value out of range
ARITHMETIC_OVERFLOW, BINARY_ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, DELTA_CANNOT_RESTORE_TABLE_VERSION, DELTA_CANNOT_RESTORE_TIMESTAMP_GREATER, DELTA_CAST_OVERFLOW_IN_TABLE_WRITE, DELTA_INVALID_CDC_RANGE, INCORRECT_RAMP_UP_RATE, INVALID_ARRAY_INDEX, INVALID_ARRAY_INDEX_IN_ELEMENT_AT, INVALID_BITMAP_POSITION, INVALID_BOUNDARY, INVALID_INDEX_OF_ZERO, INVALID_NUMERIC_LITERAL_RANGE, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE, SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT
22004 null value not allowed
COMPARATOR_RETURNS_NULL, TWS_VALUE_SHOULD_NOT_BE_NULL
22005 error in assignment
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE, DELTA_FAILED_TO_MERGE_FIELDS, DELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006 invalid interval format
CANNOT_PARSE_INTERVAL, DELTA_INVALID_INTERVAL
22007 invalid datetime format
CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT
22008 datetime field overflow
DATETIME_OVERFLOW
2200E null value in array target
NULL_MAP_KEY
2200G most specific type mismatch
DELTA_COLUMN_STRUCT_TYPE_MISMATCH
2200P interval value out of range
DELTA_INVALID_CALENDAR_INTERVAL_EMPTY
22012 division by zero
DIVIDE_BY_ZERO, INTERVAL_DIVIDED_BY_ZERO
22015 interval field overflow
INTERVAL_ARITHMETIC_OVERFLOW
22018 invalid character value for cast
CANNOT_PARSE_DECIMAL, CANNOT_PARSE_PROTOBUF_DESCRIPTOR, CAST_INVALID_INPUT, CONVERSION_INVALID_INPUT, DELTA_FAILED_CAST_PARTITION_VALUE, FAILED_PARSE_STRUCT_TYPE
2201B invalid regular expression
DELTA_REGEX_OPT_SYNTAX_ERROR
22023 invalid parameter value
CONFLICTING_PROVIDER, DELTA_INVALID_AUTO_COMPACT_TYPE, DELTA_INVALID_BUCKET_COUNT, DELTA_INVALID_BUCKET_INDEX, DELTA_UNSUPPORTED_STRATEGY_NAME, EMPTY_LOCAL_FILE_IN_STAGING_ACCESS_QUERY, EWKB_PARSE_ERROR, GEOJSON_PARSE_ERROR, H3_INVALID_CELL_ID, H3_INVALID_GRID_DISTANCE_VALUE, H3_INVALID_RESOLUTION_VALUE, H3_PENTAGON_ENCOUNTERED_ERROR, H3_UNDEFINED_GRID_DISTANCE, INVALID_FRACTION_OF_SECOND, INVALID_PARAMETER_MARKER_VALUE, INVALID_PARAMETER_VALUE, MALFORMED_RECORD_IN_PARSING, MALFORMED_VARIANT, MAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCE, RULE_ID_NOT_FOUND, SECOND_FUNCTION_ARGUMENT_NOT_INTEGER, ST_DIFFERENT_SRID_VALUES, ST_INVALID_ARGUMENT, ST_INVALID_ARGUMENT_TYPE, ST_INVALID_CRS_TRANSFORMATION_ERROR, ST_INVALID_ENDIANNESS_VALUE, ST_INVALID_GEOHASH_VALUE, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_VALUE, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALL, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALID, VARIANT_SIZE_LIMIT, WKB_PARSE_ERROR, WKT_PARSE_ERROR, XML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22032 invalid JSON text
AI_FUNCTION_INVALID_MAX_WORDS, AI_INVALID_ARGUMENT_VALUE_ERROR, INVALID_JSON_ROOT_FIELD, INVALID_JSON_SCHEMA_MAP_TYPE, REMOTE_FUNCTION_HTTP_RESULT_PARSE_ERROR
2203G sql json item cannot be cast to target type
AI_FUNCTION_HTTP_PARSE_CAST_ERROR, AI_FUNCTION_HTTP_PARSE_COLUMNS_ERROR, CANNOT_PARSE_JSON_FIELD
22525 Partitioning key value is not valid.
DELTA_PARTITION_COLUMN_CAST_FAILED
22531 The argument of a built-in or system provided routine resulted in an error.
INVALID_SECRET_LOOKUP
22546 The value for a routine argument is not valid.
CANNOT_DECODE_URL, HLL_INVALID_INPUT_SKETCH_BUFFER, HLL_INVALID_LG_K
22KD1 Invalid URI or PATH
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI, DELTA_CANNOT_RENAME_PATH, DELTA_INVALID_CLONE_PATH, DELTA_INVALID_PARTITION_PATH
22KD2 Identity claim is unset
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3 Cannot evolve source type to target type.
AVRO_INCOMPATIBLE_READ_TYPE, FROM_JSON_SCHEMA_EVOLUTION_FAILED
22P02 invalid text representation
INVALID_URL
22P03 invalid binary representation
INVALID_BYTE_STRING

Class 23: integrity constraint violation

SQLSTATE Description and issuing error classes
23001 restrict violation
DELTA_VIOLATE_CONSTRAINT_WITH_VALUES
23502 An insert or update value is null, but the column cannot contain null values.
DELTA_MISSING_NOT_NULL_COLUMN_VALUE, DELTA_NOT_NULL_CONSTRAINT_VIOLATED
23505 A violation of the constraint imposed by a unique index or a unique constraint occurred.
DUPLICATED_MAP_KEY, DUPLICATE_KEY
23512 The check constraint cannot be added, because the table contains rows that do not satisfy the constraint definition.
DELTA_NEW_CHECK_CONSTRAINT_VIOLATION, DELTA_NEW_NOT_NULL_VIOLATION
23K01 MERGE cardinality violation
MERGE_CARDINALITY_VIOLATION

Class 25: invalid transaction state

SQLSTATE Description and issuing error classes
25000 invalid transaction state
COPY_INTO_DUPLICATED_FILES_COPY_NOT_ALLOWED, COPY_INTO_NON_BLIND_APPEND_NOT_ALLOWED, COPY_INTO_ROCKSDB_MAX_RETRY_EXCEEDED, DATA_LINEAGE_SECURE_VIEW_LEAF_NODE_HAS_NO_RELATION, DELTA_INVALID_ISOLATION_LEVEL, DELTA_MERGE_MATERIALIZE_SOURCE_FAILED_REPEATEDLY

Class 2B: dependent privilege descriptors still exist

SQLSTATE Description and issuing error classes
2BP01 dependent objects still exist
SCHEMA_NOT_EMPTY

Class 2D: invalid transaction termination

SQLSTATE Description and issuing error classes
2D521 SQL COMMIT or ROLLBACK are invalid in the current operating environment.
DELTA_DELETION_VECTOR_MISSING_NUM_RECORDS, DELTA_DUPLICATE_ACTIONS_FOUND
2DKD0 Post commit hook failed.
DELTA_POST_COMMIT_HOOK_FAILED

Class 38: external routine exception

SQLSTATE Description and issuing error classes
38000 external routine exception
FAILED_FUNCTION_CALL, INVALID_UDF_IMPLEMENTATION, NO_UDF_INTERFACE, PYTHON_DATA_SOURCE_ERROR, TABLE_VALUED_FUNCTION_FAILED_TO_ANALYZE_IN_PYTHON

Class 39: external routine invocation exception

SQLSTATE Description and issuing error classes
39000 external routine invocation exception
FAILED_EXECUTE_UDF, FOREACH_BATCH_USER_FUNCTION_ERROR, UDF_USER_CODE_ERROR

Class 3D: invalid catalog name

SQLSTATE Description and issuing error classes
3D000 invalid catalog name
UC_CATALOG_NAME_NOT_PROVIDED

Class 40: transaction rollback

SQLSTATE Description and issuing error classes
40000 transaction rollback
CONCURRENT_STREAM_LOG_UPDATE, DELTA_MAX_COMMIT_RETRIES_EXCEEDED

Class 42: syntax error or access rule violation

SQLSTATE Description and issuing error classes
42000 syntax error or access rule violation
AMBIGUOUS_REFERENCE_TO_FIELDS, CF_AMBIGUOUS_AUTH_OPTIONS_ERROR, CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR, CF_AZURE_STORAGE_SUFFIXES_REQUIRED, CF_CLEAN_SOURCE_ALLOW_OVERWRITES_BOTH_ON, CF_EMPTY_DIR_FOR_SCHEMA_INFERENCE, CF_FAILED_TO_FIND_PROVIDER, CF_FILE_FORMAT_REQUIRED, CF_GCP_AUTHENTICATION, CF_INCORRECT_SQL_PARAMS, CF_INTERNAL_ERROR, CF_INVALID_ARN, CF_INVALID_CHECKPOINT, CF_INVALID_CLEAN_SOURCE_MODE, CF_INVALID_GCP_RESOURCE_TAG_KEY, CF_INVALID_GCP_RESOURCE_TAG_VALUE, CF_INVALID_MANAGED_FILE_EVENTS_OPTION_KEYS, CF_INVALID_SCHEMA_EVOLUTION_MODE, CF_INVALID_SCHEMA_HINTS_OPTION, CF_INVALID_SCHEMA_HINT_COLUMN, CF_MANAGED_FILE_EVENTS_ENDPOINT_NOT_FOUND, CF_MANAGED_FILE_EVENTS_ENDPOINT_PERMISSION_DENIED, CF_MAX_MUST_BE_POSITIVE, CF_MISSING_METADATA_FILE_ERROR, CF_MISSING_PARTITION_COLUMN_ERROR, CF_MISSING_SCHEMA_IN_PATHLESS_MODE, CF_PATH_DOES_NOT_EXIST_FOR_READ_FILES, CF_REGION_NOT_FOUND_ERROR, CF_RESOURCE_SUFFIX_EMPTY, CF_RESOURCE_SUFFIX_INVALID_CHAR_AWS, CF_RESOURCE_SUFFIX_INVALID_CHAR_AZURE, CF_RESOURCE_SUFFIX_INVALID_CHAR_GCP, CF_RESOURCE_SUFFIX_LIMIT, CF_RESOURCE_SUFFIX_LIMIT_GCP, CF_RETENTION_GREATER_THAN_MAX_FILE_AGE, CF_SOURCE_DIRECTORY_PATH_REQUIRED, CF_STATE_INCORRECT_SQL_PARAMS, CF_STATE_INVALID_CHECKPOINT_PATH, CF_STATE_INVALID_VERSION, CF_UNABLE_TO_DERIVE_STREAM_CHECKPOINT_LOCATION, CF_UNABLE_TO_DETECT_FILE_FORMAT, CF_UNABLE_TO_EXTRACT_BUCKET_INFO, CF_UNABLE_TO_EXTRACT_KEY_INFO, CF_UNABLE_TO_EXTRACT_STORAGE_ACCOUNT_INFO, CF_UNKNOWN_OPTION_KEYS_ERROR, CF_USE_DELTA_FORMAT, CONNECTION_ALREADY_EXISTS, CONNECTION_NAME_CANNOT_BE_EMPTY, CONNECTION_NOT_FOUND, CONNECTION_OPTION_NOT_SUPPORTED, CONNECTION_TYPE_NOT_SUPPORTED, DELTA_ADDING_COLUMN_WITH_INTERNAL_NAME_FAILED, DELTA_ADDING_DELETION_VECTORS_WITH_TIGHT_BOUNDS_DISALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_NOT_ALLOWED, DELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWED, DELTA_ALTER_TABLE_RENAME_NOT_ALLOWED, DELTA_ALTER_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_CANNOT_RELATIVIZE_PATH, DELTA_CLONE_INCOMPLETE_FILE_COPY, DELTA_CLUSTERING_NOT_SUPPORTED, DELTA_CLUSTERING_REPLACE_TABLE_WITH_PARTITIONED_TABLE, DELTA_CLUSTERING_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_CREATE_TABLE_SET_CLUSTERING_TABLE_FEATURE_NOT_ALLOWED, DELTA_INCONSISTENT_BUCKET_SPEC, DELTA_INCORRECT_GET_CONF, DELTA_INVALID_MANAGED_TABLE_SYNTAX_NO_SCHEMA, DELTA_MAX_ARRAY_SIZE_EXCEEDED, DELTA_MAX_LIST_FILE_EXCEEDED, DELTA_MISSING_TRANSACTION_LOG, DELTA_NAME_CONFLICT_IN_BUCKETED_TABLE, DELTA_NOT_A_DATABRICKS_DELTA_TABLE, DELTA_OVERWRITE_MUST_BE_TRUE, DELTA_STATS_COLLECTION_COLUMN_NOT_FOUND, FOREIGN_OBJECT_NAME_CANNOT_BE_EMPTY, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_INLINE_TABLE, INVALID_SAVE_MODE, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, INVALID_USAGE_OF_STAR_OR_REGEX, INVALID_WRITE_DISTRIBUTION, MISSING_CONNECTION_OPTION, MISSING_NAME_FOR_CHECK_CONSTRAINT, MULTIPLE_LOAD_PATH, NAMESPACE_ALREADY_EXISTS, NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, NON_PARTITION_COLUMN, NOT_NULL_CONSTRAINT_VIOLATION, NO_HANDLER_FOR_UDAF, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, PS_INVALID_EMPTY_OPTION, PS_INVALID_OPTION, PS_INVALID_OPTION_TYPE, PS_INVALID_READ_LIMIT, PS_MISSING_AUTH_INFO, PS_MISSING_REQUIRED_OPTION, PS_PROVIDE_CREDENTIALS_WITH_OPTION, PS_UNABLE_TO_CREATE_SUBSCRIPTION, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSUPPORTED_BATCH_TABLE_VALUED_FUNCTION, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTION, VOLUME_ALREADY_EXISTS
42001 Invalid encoder error
INVALID_EXPRESSION_ENCODER
42501 The authorization ID does not have the privilege to perform the specified operation on the identified object.
CANNOT_READ_SENSITIVE_KEY_FROM_SECURE_PROVIDER, CF_CLEAN_SOURCE_UNAUTHORIZED_WRITE_PERMISSION, INSUFFICIENT_PERMISSIONS, INSUFFICIENT_PERMISSIONS_EXT_LOC, INSUFFICIENT_PERMISSIONS_NO_OWNER, INSUFFICIENT_PERMISSIONS_OWNERSHIP_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE, INSUFFICIENT_PERMISSIONS_SECURABLE_PARENT_OWNER, INSUFFICIENT_PERMISSIONS_STORAGE_CRED, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES, INSUFFICIENT_PERMISSIONS_UNDERLYING_SECURABLES_VERBOSE, INVALID_S3_COPY_CREDENTIALS, UNAUTHORIZED_ACCESS
42601 A character, token, or clause is invalid or missing.
COLUMN_ALIASES_NOT_ALLOWED, COMMA_PRECEDING_CONSTRAINT_ERROR, COPY_INTO_CREDENTIALS_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED, COPY_INTO_ENCRYPTION_REQUIRED_WITH_EXPECTED, COPY_INTO_SYNTAX_ERROR, CREDENTIAL_MISSING, DATA_SOURCE_OPTION_IS_REQUIRED, DELTA_CANNOT_CHANGE_LOCATION, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA, DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION, DELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERROR, DELTA_FAILED_RECOGNIZE_PREDICATE, DELTA_ILLEGAL_USAGE, DELTA_MERGE_MISSING_WHEN, DELTA_MERGE_RESOLVED_ATTRIBUTE_MISSING_FROM_INPUT, DELTA_MERGE_UNRESOLVED_EXPRESSION, DELTA_NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, DELTA_NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, DELTA_NON_LAST_NOT_MATCHED_CLAUSE_OMIT_CONDITION, DELTA_NON_PARSABLE_TAG, DELTA_NO_START_FOR_CDC_READ, DELTA_ONEOF_IN_TIMETRAVEL, DELTA_OPERATION_MISSING_PATH, DELTA_UNEXPECTED_ACTION_EXPRESSION, DELTA_UNKNOWN_PRIVILEGE, DELTA_UNKNOWN_READ_LIMIT, DELTA_UNRECOGNIZED_COLUMN_CHANGE, EVENT_LOG_REQUIRES_SHARED_COMPUTE, FROM_JSON_CONFLICTING_SCHEMA_UPDATES, FROM_JSON_CORRUPT_RECORD_COLUMN_IN_SCHEMA, FROM_JSON_CORRUPT_SCHEMA, FROM_JSON_INFERENCE_FAILED, FROM_JSON_INVALID_CONFIGURATION, IDENTIFIER_TOO_MANY_NAME_PARTS, INVALID_EXTRACT_FIELD, INVALID_FORMAT, INVALID_PARTITION_OPERATION, INVALID_SHARED_ALIAS_NAME, INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC, LOCAL_MUST_WITH_SCHEMA_FILE, MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE, NOT_ALLOWED_IN_FROM, NOT_A_CONSTANT_STRING, PARSE_SYNTAX_ERROR, REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION, SORT_BY_WITHOUT_BUCKETING, SPECIFY_BUCKETING_IS_NOT_ALLOWED, SPECIFY_PARTITION_IS_NOT_ALLOWED, STDS_REQUIRED_OPTION_UNSPECIFIED, STREAMING_TABLE_OPERATION_NOT_ALLOWED, UC_EXTERNAL_VOLUME_MISSING_LOCATION, UC_LOCATION_FOR_MANAGED_VOLUME_NOT_SUPPORTED, UNCLOSED_BRACKETED_COMMENT, USER_DEFINED_FUNCTIONS, WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE, WITH_CREDENTIAL, WRITE_STREAM_NOT_ALLOWED
42602 A character that is invalid in a name has been detected.
DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE, INVALID_SCHEMA_OR_RELATION_NAME
42604 An invalid numeric or string constant has been detected.
AS_OF_JOIN, DELTA_TIME_TRAVEL_INVALID_BEGIN_VALUE, EMPTY_JSON_FIELD_VALUE, INVALID_ESC, INVALID_ESCAPE_CHAR, INVALID_PIPELINE_ID, INVALID_STAGING_PATH_IN_STAGING_ACCESS_QUERY, INVALID_TYPED_LITERAL, INVALID_UUID
42605 The number of arguments specified for a scalar function is invalid.
INCORRECT_NUMBER_OF_ARGUMENTS, WRONG_NUM_ARGS
42607 An operand of an aggregate function or CONCAT operator is invalid.
NESTED_AGGREGATE_FUNCTION
42608 The use of NULL or DEFAULT in VALUES or an assignment statement is invalid.
DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE
42613 Clauses are mutually exclusive.
DELTA_AMBIGUOUS_PATHS_IN_CREATE_TABLE, DELTA_CANNOT_SET_LOCATION_ON_PATH_IDENTIFIER, DELTA_CLONE_AMBIGUOUS_TARGET, DELTA_CLUSTERING_WITH_ZORDER_BY, DELTA_CLUSTER_BY_WITH_BUCKETING, DELTA_CLUSTER_BY_WITH_PARTITIONED_BY, DELTA_FILE_LIST_AND_PATTERN_STRING_CONFLICT, DELTA_OVERWRITE_SCHEMA_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_PARTITION_SCHEMA_IN_ICEBERG_TABLES, DELTA_REPLACE_WHERE_IN_OVERWRITE, DELTA_REPLACE_WHERE_WITH_DYNAMIC_PARTITION_OVERWRITE, DELTA_REPLACE_WHERE_WITH_FILTER_DATA_CHANGE_UNSET, DELTA_STARTING_VERSION_AND_TIMESTAMP_BOTH_SET, DELTA_TABLE_LOCATION_MISMATCH, DELTA_UNSUPPORTED_TIME_TRAVEL_MULTIPLE_FORMATS, INCOMPATIBLE_JOIN_TYPES, INVALID_LATERAL_JOIN_TYPE, INVALID_QUERY_MIXED_QUERY_PARAMETERS, INVALID_SINGLE_VARIANT_COLUMN, MANAGED_TABLE_WITH_CRED, MUTUALLY_EXCLUSIVE_CLAUSES, NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION, NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITION, STDS_CONFLICT_OPTIONS
42614 A duplicate keyword or clause is invalid.
DELTA_MULTIPLE_CDC_BOUNDARY, DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER, DUPLICATE_CLAUSES, REPEATED_CLAUSE
42616 Invalid options specified
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVE, DELTA_ILLEGAL_OPTION, DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS, DELTA_UNSET_NON_EXISTENT_PROPERTY, STDS_INVALID_OPTION_VALUE, UNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCE, UNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE
42617 The statement string is blank or empty.
PARSE_EMPTY_STATEMENT
42621 The check constraint or generated column expression is invalid.
DELTA_AGGREGATE_IN_GENERATED_COLUMN, DELTA_INVALID_GENERATED_COLUMN_REFERENCES, DELTA_NON_BOOLEAN_CHECK_CONSTRAINT, DELTA_UDF_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMN, UNSUPPORTED_EXPRESSION_GENERATED_COLUMN
42623 A DEFAULT clause cannot be specified.
GENERATED_COLUMN_WITH_DEFAULT_VALUE, INVALID_DEFAULT_VALUE
42701 The same target is specified more than once for assignment in the same SQL statement.
DELTA_CONFLICT_SET_COLUMN, DELTA_DUPLICATE_COLUMNS_ON_INSERT, DELTA_DUPLICATE_COLUMNS_ON_UPDATE_TABLE, DELTA_DUPLICATE_DATA_SKIPPING_COLUMNS, DUPLICATE_ASSIGNMENTS, EXEC_IMMEDIATE_DUPLICATE_ARGUMENT_ALIASES
42702 A column reference is ambiguous, because of duplicate names.
AMBIGUOUS_COLUMN_OR_FIELD, AMBIGUOUS_COLUMN_REFERENCE, AMBIGUOUS_LATERAL_COLUMN_ALIAS, DELTA_AMBIGUOUS_PARTITION_COLUMN, EXCEPT_OVERLAPPING_COLUMNS
42703 An undefined column or parameter name was detected.
COLUMN_NOT_DEFINED_IN_TABLE, COLUMN_NOT_FOUND, DELTA_BLOOM_FILTER_DROP_ON_NON_EXISTING_COLUMNS, DELTA_CANNOT_CREATE_BLOOM_FILTER_NON_EXISTING_COL, DELTA_CANNOT_DROP_BLOOM_FILTER_ON_NON_INDEXED_COLUMN, DELTA_CANNOT_RESOLVE_COLUMN, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET, DELTA_COLUMN_MAPPING_MAX_COLUMN_ID_NOT_SET_CORRECTLY, DELTA_COLUMN_NOT_FOUND, DELTA_COLUMN_NOT_FOUND_IN_MERGE, DELTA_COLUMN_NOT_FOUND_IN_SCHEMA, DELTA_FAILED_FIND_ATTRIBUTE_IN_OUTPUT_COLUMNS, DELTA_MISSING_COLUMN, DELTA_MISSING_SET_COLUMN, DELTA_PARTITION_COLUMN_NOT_FOUND, DELTA_ZORDERING_COLUMN_DOES_NOT_EXIST, EXCEPT_RESOLVED_COLUMNS_WITHOUT_MATCH, EXCEPT_UNRESOLVED_COLUMN_IN_STRUCT_EXPANSION, UNRESOLVED_COLUMN, UNRESOLVED_FIELD, UNRESOLVED_MAP_KEY, UNRESOLVED_USING_COLUMN_FOR_JOIN, ZORDERBY_COLUMN_DOES_NOT_EXIST
42704 An undefined object or constraint name was detected.
AMBIGUOUS_REFERENCE, CANNOT_RESOLVE_DATAFRAME_COLUMN, CANNOT_RESOLVE_STAR_EXPAND, CODEC_SHORT_NAME_NOT_FOUND, COLLATION_INVALID_NAME, DATA_SOURCE_NOT_EXIST, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, DELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINED, ENCODER_NOT_FOUND, FIELD_NOT_FOUND, INDEX_NOT_FOUND, SCHEMA_NOT_FOUND, UC_VOLUME_NOT_FOUND, UNRECOGNIZED_SQL_TYPE
42710 A duplicate object or constraint name was detected.
ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE, DATA_SOURCE_ALREADY_EXISTS, DELTA_CONSTRAINT_ALREADY_EXISTS, DUPLICATED_METRICS_NAME, FIELDS_ALREADY_EXISTS, FOUND_MULTIPLE_DATA_SOURCES, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS, MULTIPLE_XML_DATA_SOURCE
42711 A duplicate column name was detected in the object definition or ALTER TABLE statement.
COLUMN_ALREADY_EXISTS, DELTA_DUPLICATE_COLUMNS_FOUND, DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS, DUPLICATE_ROUTINE_RETURNS_COLUMNS
42713 A duplicate object was detected in a list or is the same as an existing object.
DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT, STATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST
42723 A routine with the same signature already exists in the schema, module, or compound block where it is defined.
ROUTINE_ALREADY_EXISTS, VARIABLE_ALREADY_EXISTS
42734 A duplicate parameter-name, SQL variable name, label, or condition-name was detected.
COLUMN_MASKS_DUPLICATE_USING_COLUMN_NAME, COLUMN_MASKS_USING_COLUMN_NAME_SAME_AS_TARGET_COLUMN, DUPLICATE_ROUTINE_PARAMETER_NAMES, ROW_LEVEL_SECURITY_DUPLICATE_COLUMN_NAME
4274K Invalid use of a named argument when invoking a routine.
DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT, NAMED_PARAMETERS_NOT_SUPPORTED, READ_FILES_AMBIGUOUS_ROUTINE_PARAMETERS, READ_TVF_UNEXPECTED_REQUIRED_PARAMETER, REQUIRED_PARAMETER_NOT_FOUND, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_PARAMETER_NAME
42802 The number of target values is not the same as the number of source values.
ASSIGNMENT_ARITY_MISMATCH, DELTA_INSERT_COLUMN_ARITY_MISMATCH, DELTA_INSERT_COLUMN_MISMATCH, STATE_STORE_CANNOT_REMOVE_DEFAULT_COLUMN_FAMILY, STATE_STORE_MULTIPLE_VALUES_PER_KEY, UDTF_ALIAS_NUMBER_MISMATCH, UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD, UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803 A column reference in the SELECT or HAVING clause is invalid, because it is not a grouping column; or a column reference in the GROUP BY clause is invalid.
GROUPING_COLUMN_MISMATCH, GROUPING_ID_COLUMN_MISMATCH, MISSING_AGGREGATION, MISSING_GROUP_BY, UNRESOLVED_ALL_IN_GROUP_BY
42805 An integer in the ORDER BY clause does not identify a column of the result table.
GROUP_BY_POS_OUT_OF_RANGE, ORDER_BY_POS_OUT_OF_RANGE
42806 A value cannot be assigned to a variable, because the data types are not compatible.
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
42807 The data-change statement is not permitted on this object.
DELTA_CHANGE_TABLE_FEED_DISABLED, DELTA_UNSUPPORTED_WRITES_STAGED_TABLE
42809 The identified object is not the type of object to which the statement applies.
DELTA_CANNOT_DESCRIBE_VIEW_HISTORY, DELTA_CANNOT_MODIFY_APPEND_ONLY, DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_TABLE, DELTA_TABLE_NOT_SUPPORTED_IN_OP, DELTA_UNSUPPORTED_DESCRIBE_DETAIL_VIEW, EXPECT_PERMANENT_VIEW_NOT_TEMP, EXPECT_TABLE_NOT_VIEW, EXPECT_VIEW_NOT_TABLE, FORBIDDEN_OPERATION, INVALID_DEST_CATALOG, INVALID_SOURCE_CATALOG, INVALID_UPGRADE_SYNTAX, NOT_A_PARTITIONED_TABLE, UNSUPPORTED_INSERT, WRONG_COMMAND_FOR_OBJECT_TYPE
42816 A datetime value or duration in an expression is invalid.
DELTA_TIMESTAMP_GREATER_THAN_COMMIT, DELTA_TIMESTAMP_INVALID
42818 The operands of an operator or function are not compatible or comparable.
INCOMPARABLE_PIVOT_COLUMN
42822 An expression in the ORDER BY clause or GROUP BY clause is not valid.
EXPRESSION_TYPE_IS_NOT_ORDERABLE, GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
42823 Multiple columns are returned from a subquery that only allows one column.
INVALID_SUBQUERY_EXPRESSION
42825 The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have compatible columns.
CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE, INCOMPATIBLE_COLUMN_TYPE
42826 The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have the same number of columns.
NUM_COLUMNS_MISMATCH, NUM_TABLE_VALUE_ALIASES_MISMATCH
42830 The foreign key does not conform to the description of the parent key.
FOREIGN_KEY_MISMATCH
42832 The operation is not allowed on system objects.
BUILT_IN_CATALOG, CANNOT_DELETE_SYSTEM_OWNED, EVENT_LOG_UNSUPPORTED_TABLE_TYPE, MODIFY_BUILTIN_CATALOG, SAMPLE_TABLE_PERMISSIONS
42837 The column cannot be altered, because its attributes are not compatible with the current column attributes.
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
42845 An invalid use of a NOT DETERMINISTIC or EXTERNAL ACTION function was detected.
AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
42846 Cast from source type to target type is not supported.
CANNOT_CAST_DATATYPE, CANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPE, CANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPE, CANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPE, CANNOT_UP_CAST_DATATYPE, DELTA_UPDATE_SCHEMA_MISMATCH_EXPRESSION, EXPRESSION_DECODING_FAILED, EXPRESSION_ENCODING_FAILED, UNEXPECTED_SERIALIZER_FOR_CLASS
42852 The privileges specified in GRANT or REVOKE are invalid or inconsistent. (For example, GRANT ALTER on a view.)
INVALID_PRIVILEGE
42883 No routine was found with a matching signature.
ROUTINE_NOT_FOUND, UNRESOLVABLE_TABLE_VALUED_FUNCTION, UNRESOLVED_ROUTINE, UNRESOLVED_VARIABLE, VARIABLE_NOT_FOUND
42887 The function or table-reference is not valid in the context where it occurs.
CYCLIC_FUNCTION_REFERENCE, DELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEW, INVALID_CURRENT_RECIPIENT_USAGE, NOT_A_SCALAR_FUNCTION, NOT_A_TABLE_FUNCTION
42891 A duplicate constraint already exists.
MULTIPLE_MATCHING_CONSTRAINTS
428C4 The number of elements on each side of the predicate operator is not the same.
UNPIVOT_VALUE_SIZE_MISMATCH
428EK The schema qualifier is not valid.
TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS
428FR A column cannot be altered as specified.
CANNOT_ALTER_PARTITION_COLUMN
428FT The partitioning clause specified on CREATE or ALTER is not valid.
DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITION, PARTITIONS_ALREADY_EXIST, PARTITIONS_NOT_FOUND
428GU A table must include at least one column that is not implicitly hidden.
DELTA_EMPTY_DATA, DELTA_READ_TABLE_WITHOUT_COLUMNS, DELTA_TARGET_TABLE_FINAL_SCHEMA_EMPTY
428H2 Data type is not supported in the context where it is being used.
EXCEPT_NESTED_COLUMN_INVALID_TYPE
428HD The statement cannot be processed because a column mask cannot be applied or the definition of the mask conflicts with the statement.
QUERIED_TABLE_INCOMPATIBLE_WITH_COLUMN_MASK_POLICY, QUERIED_TABLE_INCOMPATIBLE_WITH_ROW_LEVEL_SECURITY_POLICY
42902 The object of the INSERT, UPDATE, or DELETE is also identified (possibly implicitly through a view) in a FROM clause.
UNSUPPORTED_OVERWRITE
42903 Invalid use of an aggregate function or OLAP function.
DELTA_AGGREGATION_NOT_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_WHERE_CONDITION
42908 The statement does not include a required column list.
DELTA_CLUSTER_BY_SCHEMA_NOT_PROVIDED, DELTA_SCHEMA_NOT_PROVIDED, SPECIFY_CLUSTER_BY_WITH_BUCKETING_IS_NOT_ALLOWED, SPECIFY_CLUSTER_BY_WITH_PARTITIONED_BY_IS_NOT_ALLOWED
42939 The name cannot be used, because the specified identifier is reserved for system use.
DELTA_CANNOT_CHANGE_PROVIDER, DELTA_CANNOT_MODIFY_TABLE_PROPERTY, RESERVED_CDC_COLUMNS_ON_WRITE, ROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996 A specified column may not be used in a partition key.
DELTA_INVALID_PARTITION_COLUMN, DELTA_INVALID_PARTITION_COLUMN_NAME, DELTA_INVALID_PARTITION_COLUMN_TYPE
429BB The data type of a column, parameter, or SQL variable is not supported.
CANNOT_RECOGNIZE_HIVE_TYPE
429BQ The specified alter of the data type or attribute is not allowed.
DELTA_AMBIGUOUS_DATA_TYPE_CHANGE, DELTA_CANNOT_CHANGE_DATA_TYPE, DELTA_CANNOT_UPDATE_ARRAY_FIELD, DELTA_CANNOT_UPDATE_MAP_FIELD, DELTA_CANNOT_UPDATE_OTHER_FIELD, DELTA_CANNOT_UPDATE_STRUCT_FIELD
42K01 data type not fully specified
DATATYPE_MISSING_SIZE, INCOMPLETE_TYPE_DEFINITION
42K02 data source not found
DATA_SOURCE_NOT_FOUND, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE
42K03 File not found
BATCH_METADATA_NOT_FOUND, CANNOT_LOAD_PROTOBUF_CLASS, CLOUD_FILE_SOURCE_FILE_NOT_FOUND, DATA_SOURCE_TABLE_SCHEMA_MISMATCH, DEFAULT_FILE_NOT_FOUND, DELTA_CHANGE_DATA_FILE_NOT_FOUND, DELTA_CHECKPOINT_NON_EXIST_TABLE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_TXN_LOG, DELTA_DELETED_PARQUET_FILE_NOT_FOUND, DELTA_EMPTY_DIRECTORY, DELTA_FILE_NOT_FOUND, DELTA_FILE_NOT_FOUND_DETAILED, DELTA_FILE_OR_DIR_NOT_FOUND, DELTA_FILE_TO_OVERWRITE_NOT_FOUND, DELTA_LOG_FILE_NOT_FOUND_FOR_STREAMING_SOURCE, DELTA_PATH_DOES_NOT_EXIST, DELTA_SHALLOW_CLONE_FILE_NOT_FOUND, DELTA_TRUNCATED_TRANSACTION_LOG, LOAD_DATA_PATH_NOT_EXISTS, PATH_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND, STDS_FAILED_TO_READ_STATE_SCHEMA, STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04 Duplicate file
DELTA_FILE_ALREADY_EXISTS, DELTA_LOG_ALREADY_EXISTS, DELTA_PATH_EXISTS, FAILED_RENAME_PATH, FILE_IN_STAGING_PATH_ALREADY_EXISTS, KINESIS_FETCHED_SHARD_LESS_THAN_TRACKED_SHARD, PARTITION_LOCATION_ALREADY_EXISTS, PATH_ALREADY_EXISTS
42K05 Name is not valid
CLEANROOM_INVALID_SHARED_DATA_OBJECT_NAME, COLUMN_MASKS_MULTI_PART_TARGET_COLUMN_NAME, COLUMN_MASKS_MULTI_PART_USING_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAME, DELTA_INVALID_CHARACTERS_IN_COLUMN_NAMES, DELTA_INVALID_COLUMN_NAMES_WHEN_REMOVING_COLUMN_MAPPING, DELTA_NESTED_FIELDS_NEED_RENAME, DELTA_NON_SINGLE_PART_NAMESPACE_FOR_CATALOG, INVALID_EMPTY_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE, ROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME
42K06 Invalid type for options
DELTA_PROTOCOL_PROPERTY_NOT_INT, INVALID_OPTIONS
42K07 Not a valid schema literal
INVALID_SCHEMA
42K08 Not a constant
ARGUMENT_NOT_CONSTANT, INVALID_SQL_ARG, NON_FOLDABLE_ARGUMENT, NON_LITERAL_PIVOT_VALUES, SEED_EXPRESSION_IS_UNFOLDABLE
42K09 Data type mismatch
DATATYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_MERGE_INCOMPATIBLE_DATATYPE, DELTA_NOT_NULL_COLUMN_NOT_FOUND_IN_STRUCT, EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE, INVALID_VARIABLE_TYPE_FOR_QUERY_EXECUTE_IMMEDIATE, PIVOT_VALUE_DATA_TYPE_MISMATCH, UNEXPECTED_INPUT_TYPE, UNPIVOT_VALUE_DATA_TYPE_MISMATCH
42K0A Invalid UNPIVOT clause
UNPIVOT_REQUIRES_ATTRIBUTES, UNPIVOT_REQUIRES_VALUE_COLUMNS
42K0B Legacy feature blocked
INCONSISTENT_BEHAVIOR_CROSS_VERSION
42K0C Ambiguous reference to constraint
AMBIGUOUS_CONSTRAINT, CANNOT_DROP_AMBIGUOUS_CONSTRAINT
42K0D Invalid lambda function
INVALID_LAMBDA_FUNCTION_CALL
42K0E An expression is not valid in teh context it is used
INVALID_LIMIT_LIKE_EXPRESSION, INVALID_NON_DETERMINISTIC_EXPRESSIONS, INVALID_OBSERVED_METRICS, INVALID_TIME_TRAVEL_SPEC, INVALID_TIME_TRAVEL_TIMESTAMP_EXPR, JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE, MULTIPLE_TIME_TRAVEL_SPEC, MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION, NO_MERGE_ACTION_SPECIFIED, ONLY_SECRET_FUNCTION_SUPPORTED_HERE, SECRET_FUNCTION_INVALID_LOCATION, UNSUPPORTED_EXPR_FOR_OPERATOR, UNSUPPORTED_EXPR_FOR_PARAMETER, UNSUPPORTED_GENERATOR, UNSUPPORTED_GROUPING_EXPRESSION, UNSUPPORTED_MERGE_CONDITION, UNTYPED_SCALA_UDF, WINDOW_FUNCTION_AND_FRAME_MISMATCH
42K0F A persisted object cannot reference a temporary object.
INVALID_TEMP_OBJ_REFERENCE
42K0G A protobuf is invalid
PROTOBUF_DEPENDENCY_NOT_FOUND, PROTOBUF_DESCRIPTOR_FILE_NOT_FOUND, PROTOBUF_FIELD_MISSING, PROTOBUF_FIELD_MISSING_IN_SQL_SCHEMA, PROTOBUF_FIELD_TYPE_MISMATCH, PROTOBUF_MESSAGE_NOT_FOUND, PROTOBUF_TYPE_NOT_SUPPORT, RECURSIVE_PROTOBUF_SCHEMA, SCHEMA_REGISTRY_CONFIGURATION_ERROR, UNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPE, UNKNOWN_PROTOBUF_MESSAGE_TYPE
42K0H A cyclic invocation has been detected.
RECURSIVE_VIEW
42K0I SQL Config not found.
SQL_CONF_NOT_FOUND
42K0J Property not found.
UNSET_NONEXISTENT_PROPERTIES
42K0K Invalid inverse distribution function
INVALID_INVERSE_DISTRIBUTION_FUNCTION
42KD0 Ambiguous name reference.
AMBIGUOUS_ALIAS_IN_NESTED_CTE
42KD1 Operation not supported in READ ONLY session mode.
OP_NOT_SUPPORTED_READ_ONLY
42KD2 The source and target table names of a SYNC operaton must be the same.
SYNC_SRC_TARGET_TBL_NOT_SAME
42KD3 A column can not be added as specified.
DELTA_ADD_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_ADD_COLUMN_PARENT_NOT_STRUCT, DELTA_ADD_COLUMN_STRUCT_NOT_FOUND
42KD4 Operation not supported because table schema has changed.
DELTA_BLOCK_COLUMN_MAPPING_AND_CDC_OPERATION, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE, DELTA_STREAMING_INCOMPATIBLE_SCHEMA_CHANGE_USE_SCHEMA_LOG
42KD5 Cannot create file or path.
DELTA_CANNOT_CREATE_LOG_PATH, PARTITION_LOCATION_IS_NOT_UNDER_TABLE_DIRECTORY
42KD6 No partition information found.
DELTA_CONVERSION_NO_PARTITION_FOUND, DELTA_MISSING_PARTITION_COLUMN, DELTA_MISSING_PART_FILES
42KD7 Table signature mismatch.
DELTA_CREATE_TABLE_SCHEME_MISMATCH, DELTA_CREATE_TABLE_WITH_DIFFERENT_CLUSTERING, DELTA_CREATE_TABLE_WITH_DIFFERENT_PARTITIONING, DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY, DELTA_SET_LOCATION_SCHEMA_MISMATCH
42KD8 Column position out of range.
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT, DELTA_INDEX_LARGER_THAN_STRUCT
42KD9 Cannot infer table schema.
CANNOT_MERGE_SCHEMAS, COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA
42KDA Failed to merge file into table schema.
DELTA_FAILED_MERGE_SCHEMA_FILE
42KDB Invalid URL
DATA_SOURCE_URL_NOT_ALLOWED
42KDC Archived file reference.
DELTA_ARCHIVED_FILES_IN_LIMIT, DELTA_ARCHIVED_FILES_IN_SCAN
42KDD Unsupported operation in streaming view.
UNEXPECTED_OPERATOR_IN_STREAMING_VIEW
42KDE Unsupported operation on streaming dataset.
CALL_ON_STREAMING_DATASET_UNSUPPORTED, CANNOT_CREATE_DATA_SOURCE_TABLE, INVALID_WRITER_COMMIT_MESSAGE, NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING
42KDF A required routine parameter is missing an argument.
MISSING_PARAMETER_FOR_KAFKA, MISSING_PARAMETER_FOR_ROUTINE, XML_ROW_TAG_MISSING
42KDG The target schema is not compatible with the ingested data.
COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE
42P01 undefined table
DELTA_CANNOT_REPLACE_MISSING_TABLE, DELTA_MISSING_DELTA_TABLE, DELTA_MISSING_DELTA_TABLE_COPY_INTO, DELTA_NO_RELATION_TABLE, DELTA_TABLE_NOT_FOUND, TABLE_OR_VIEW_NOT_FOUND, TABLE_WITH_ID_NOT_FOUND, VIEW_NOT_FOUND
42P02 undefined parameter
UNBOUND_SQL_PARAMETER
42P06 duplicate schema
SCHEMA_ALREADY_EXISTS
42P07 duplicate table
DELTA_TABLE_ALREADY_EXISTS, TABLE_OR_VIEW_ALREADY_EXISTS, TEMP_TABLE_OR_VIEW_ALREADY_EXISTS, VIEW_ALREADY_EXISTS
42P10 invalid column reference
DELTA_CLUSTERING_COLUMNS_MISMATCH, DELTA_NON_PARTITION_COLUMN_REFERENCE, DELTA_NON_PARTITION_COLUMN_SPECIFIED, DELTA_SHOW_PARTITION_IN_NON_PARTITIONED_COLUMN, DELTA_ZORDERING_ON_PARTITION_COLUMN
42P18 indeterminate datatype
DELTA_NULL_SCHEMA_IN_STREAMING_WRITE
42P20 windowing error
UNSUPPORTED_EXPR_FOR_WINDOW
42S22 Column not found
NO_SQL_TYPE_IN_PROTOBUF_SCHEMA

Class 44: with check option violation

SQLSTATE Description and issuing error classes
44000 with check option violation
DELTA_REPLACE_WHERE_MISMATCH

Class 46: Java DDL 1

SQLSTATE Description and issuing error classes
46103 unresolved class name
CANNOT_LOAD_FUNCTION_CLASS
46110 unsupported feature
CANNOT_MODIFY_CONFIG
46121 invalid column name
INVALID_COLUMN_NAME_AS_PATH

Class 51: Invalid Application State

SQLSTATE Description and issuing error classes
51024 An object cannot be used, because it has been marked inoperative.
INCOMPATIBLE_VIEW_SCHEMA_CHANGE

Class 53: insufficient resources

SQLSTATE Description and issuing error classes
53200 out of memory
EXECUTOR_BROADCAST_JOIN_OOM, UNABLE_TO_ACQUIRE_MEMORY

Class 54: program limit exceeded

SQLSTATE Description and issuing error classes
54000 program limit exceeded
COLLECTION_SIZE_LIMIT_EXCEEDED, DELTA_CLUSTER_BY_INVALID_NUM_COLUMNS, GROUPING_SIZE_LIMIT_EXCEEDED, RELATION_LARGER_THAN_8G
54006 The result string is too long.
EXCEED_LIMIT_LENGTH, KRYO_BUFFER_OVERFLOW
54023 too many arguments
TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS
54K00 Maximum depth of nested views was exceeded.
VIEW_EXCEED_MAX_NESTED_DEPTH
54KD0 Maximum UDF count in query plan exceeded.
UDF_LIMITS, UDF_MAX_COUNT_EXCEEDED
54KD1 Maximum object count in session exceeded.
MAX_NUMBER_VARIABLES_IN_SESSION_EXCEEDED

Class 55: object not in prerequisite state

SQLSTATE Description and issuing error classes
55019 The object is in an invalid state for the operation.
DIFFERENT_DELTA_TABLE_READ_BY_STREAMING_SOURCE, EVENT_LOG_UNAVAILABLE, MATERIALIZED_VIEW_MESA_REFRESH_WITHOUT_PIPELINE_ID, STREAMING_TABLE_NEEDS_REFRESH

Class 56: Miscellaneous SQL or Product Error

SQLSTATE Description and issuing error classes
56000 Miscellaneous SQL or Product Error
CHECKPOINT_RDD_BLOCK_ID_NOT_FOUND
56038 The requested feature is not supported in this environment.
AI_FUNCTION_UNSUPPORTED_ERROR, ANSI_CONFIG_CANNOT_BE_DISABLED, CF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESS, CODEC_NOT_AVAILABLE, COLUMN_MASKS_NOT_ENABLED, DATABRICKS_DELTA_NOT_ENABLED, DELTA_MISSING_ICEBERG_CLASS, DELTA_UNRECOGNIZED_INVARIANT, DELTA_UNSUPPORTED_FEATURES_FOR_READ, DELTA_UNSUPPORTED_FEATURES_FOR_WRITE, DELTA_UNSUPPORTED_FEATURES_IN_CONFIG, DLT_EXPECTATIONS_NOT_SUPPORTED, DLT_VIEW_CLUSTER_BY_NOT_SUPPORTED, DLT_VIEW_LOCATION_NOT_SUPPORTED, DLT_VIEW_SCHEMA_WITH_TYPE_NOT_SUPPORTED, DLT_VIEW_TABLE_CONSTRAINTS_NOT_SUPPORTED, FEATURE_NOT_ON_CLASSIC_WAREHOUSE, FEATURE_UNAVAILABLE, GET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSION, INCOMPATIBLE_DATASOURCE_REGISTER, MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED, NATIVE_XML_DATA_SOURCE_NOT_ENABLED, STREAMING_TABLE_NOT_SUPPORTED, UC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWED, UC_NOT_ENABLED, UC_QUERY_FEDERATION_NOT_ENABLED, UC_VOLUMES_NOT_ENABLED, UC_VOLUMES_SHARING_NOT_ENABLED, UNSUPPORTED_TIMESERIES_COLUMNS
56098 An error occurred during implicit rebind, recompile, or revalidation.
UC_INVALID_DEPENDENCIES
56K00 Spark Connect error
CONNECT

Class 57: operator intervention

SQLSTATE Description and issuing error classes
57012 A non-database resource is not available. This will not affect the successful execution of subsequent statements.
REMOTE_FUNCTION_HTTP_FAILED_ERROR, REMOTE_FUNCTION_HTTP_RESULT_UNEXPECTED_ERROR, REMOTE_FUNCTION_HTTP_RETRY_TIMEOUT, REMOTE_FUNCTION_MISSING_REQUIREMENTS_ERROR

Class 58: System error

SQLSTATE Description and issuing error classes
58030 I/O error
CANNOT_LOAD_STATE_STORE, CANNOT_RESTORE_PERMISSIONS_FOR_PATH, CANNOT_WRITE_STATE_STORE, FAILED_RENAME_TEMP_FILE, INVALID_BUCKET_FILE, TASK_WRITE_FAILED, UNABLE_TO_FETCH_HIVE_TABLES

Class 82: out of memory

SQLSTATE Description and issuing error classes
82100 out of memory (could not allocate)
DELTA_BLOOM_FILTER_OOM_ON_WRITE

Class F0: configuration file error

SQLSTATE Description and issuing error classes
F0000 config file error
DELTA_INCONSISTENT_LOGSTORE_CONFS, DELTA_INVALID_LOGSTORE_CONF, DELTA_UNKNOWN_CONFIGURATION, INVALID_DRIVER_MEMORY, INVALID_EXECUTOR_MEMORY, INVALID_KRYO_SERIALIZER_BUFFER_SIZE

Class HV: FDW-specific condition

SQLSTATE Description and issuing error classes
HV000 FDW-specific condition
FAILED_JDBC

Class HY: CLI-specific condition

SQLSTATE Description and issuing error classes
HY000 CLI-specific condition
INVALID_HANDLE
HY008 operation canceled
OPERATION_CANCELED
HY109 invalid cursor position
INVALID_CURSOR

Class KD: datasource specific errors

SQLSTATE Description and issuing error classes
KD000 datasource specific errors
DC_CONNECTION_ERROR, DC_CONNECTOR_ERROR, DC_FILE_BACKUP_NOT_FOUND, DC_GA4_RAW_DATA_ERROR, DC_INVALID_OFFSET, DC_SFDC_API_DAILY_QUOTA_THRESHOLD_EXCEEDED, DC_SFDC_API_ERROR, DC_SQLSERVER_ERROR, DC_WORKDAY_RAAS_API_ERROR, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_LATEST_WITH_TRIGGER_AVAILABLENOW, END_OFFSET_HAS_GREATER_OFFSET_FOR_TOPIC_PARTITION_THAN_PREFETCHED, FAILED_REGISTER_CLASS_WITH_KRYO, GRAPHITE_SINK_INVALID_PROTOCOL, GRAPHITE_SINK_PROPERTY_MISSING, INCOMPATIBLE_DATA_FOR_TABLE, LOST_TOPIC_PARTITIONS_IN_END_OFFSET_WITH_TRIGGER_AVAILABLENOW, MALFORMED_AVRO_MESSAGE, MALFORMED_CSV_RECORD, MISMATCHED_TOPIC_PARTITIONS_BETWEEN_END_OFFSET_AND_PREFETCHED
KD001 Cannot read file footer
CANNOT_READ_FILE_FOOTER, DELTA_FAILED_READ_FILE_FOOTER
KD002 Unexpected version
DELTA_FAILED_SCAN_WITH_HISTORICAL_VERSION, DELTA_MISSING_CHANGE_DATA, DELTA_STREAMING_CANNOT_CONTINUE_PROCESSING_POST_SCHEMA_EVOLUTION, DELTA_STREAMING_CHECK_COLUMN_MAPPING_NO_SNAPSHOT
KD003 Incorrect access to data type
CANNOT_READ_ARCHIVED_FILE, CANNOT_READ_FILE, DELTA_FOUND_MAP_TYPE_COLUMN, DELTA_INCORRECT_ARRAY_ACCESS, DELTA_INCORRECT_ARRAY_ACCESS_BY_NAME, UNKNOWN_FIELD_EXCEPTION
KD004 Delta protocol version error
DELTA_INVALID_PROTOCOL_DOWNGRADE, DELTA_INVALID_PROTOCOL_VERSION, DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITE, DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
KD005 Table must include at least one non partition column
ALL_PARTITION_COLUMNS_NOT_ALLOWED, DELTA_NON_PARTITION_COLUMN_ABSENT
KD006 No commits found at log path
DELTA_NO_COMMITS_FOUND, DELTA_NO_RECREATABLE_HISTORY_FOUND, STDS_COMMITTED_BATCH_UNAVAILABLE, STDS_NO_PARTITION_DISCOVERED_IN_STATE_STORE, STDS_OFFSET_LOG_UNAVAILABLE, STDS_OFFSET_METADATA_LOG_UNAVAILABLE
KD007 Table signature changed
DELTA_SCHEMA_CHANGED, DELTA_SCHEMA_CHANGED_WITH_STARTING_OPTIONS, DELTA_SCHEMA_CHANGED_WITH_VERSION, DELTA_SCHEMA_CHANGE_SINCE_ANALYSIS, DELTA_TABLE_ID_MISMATCH
KD008 Table signature not set
DELTA_SCHEMA_NOT_SET
KD009 Partitions do not match
DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER
KD00A Unexpected partial scan
DELTA_UNEXPECTED_PARTIAL_SCAN
KD00B Unrecognised file
DELTA_UNRECOGNIZED_LOGFILE, ERROR_READING_AVRO_UNKNOWN_FINGERPRINT
KD00C Versioning not contiguous
DELTA_VERSIONS_NOT_CONTIGUOUS
KD00D Stats required
DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS
KD00E table feature validation failure
DELTA_ICEBERG_COMPAT_VIOLATION, DELTA_UNIVERSAL_FORMAT_VIOLATION

Class P0: procedural logic error

SQLSTATE Description and issuing error classes
P0001 raise exception
USER_RAISED_EXCEPTION, USER_RAISED_EXCEPTION_PARAMETER_MISMATCH, USER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS