Skip to main content

SQLSTATE error codes

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

All error classes returned by 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 Databricks.

Where neccessary Spark and 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 Databricks

Databricks uses the following SQLSTATE classes:

Class 07: dynamic SQL error

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

Class 08: connection exception

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

Class 0A: feature not supported

SQLSTATEDescription and issuing error classes
0A000feature not supported
AI_FUNCTION_INVALID_RESPONSE_FORMAT_TYPE, AI_FUNCTION_UNSUPPORTED_REQUEST, AI_FUNCTION_UNSUPPORTED_RESPONSE_FORMAT, AI_FUNCTION_UNSUPPORTED_RETURN_TYPE, AI_QUERY_ENDPOINT_NOT_SUPPORT_STRUCTURED_OUTPUT, AI_QUERY_RETURN_TYPE_COLUMN_TYPE_MISMATCH, AI_SEARCH_CONFLICTING_QUERY_PARAM_SUPPLY_ERROR, AI_SEARCH_EMBEDDING_COLUMN_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_EMPTY_QUERY_PARAM_ERROR, AI_SEARCH_HYBRID_QUERY_PARAM_DEPRECATION_ERROR, AI_SEARCH_HYBRID_TEXT_NOT_FOUND_ERROR, AI_SEARCH_INDEX_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_MISSING_EMBEDDING_INPUT_ERROR, AI_SEARCH_QUERY_TYPE_CONVERT_ENCODE_ERROR, AI_SEARCH_QUERY_TYPE_UNSUPPORTED_ERROR, AI_SEARCH_UNSUPPORTED_NUM_RESULTS_ERROR, ANALYZE_CONSTRAINTS_NOT_SUPPORTED, AVRO_DEFAULT_VALUES_UNSUPPORTED, AVRO_POSITIONAL_FIELD_MATCHING_UNSUPPORTED, CANNOT_INVOKE_IN_TRANSFORMATIONS, CANNOT_UPDATE_FIELD, CF_ADD_NEW_NOT_SUPPORTED, CF_EVENT_NOTIFICATION_NOT_SUPPORTED, CF_PERIODIC_BACKFILL_NOT_SUPPORTED, CF_SFTP_NOT_ENABLED, CF_SFTP_REQUIRE_UC_CLUSTER, CF_SOURCE_UNSUPPORTED, 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, CLUSTER_BY_AUTO_FEATURE_NOT_ENABLED, COLUMN_ARRAY_ELEMENT_TYPE_MISMATCH, COLUMN_MASKS_ABAC_MISMATCH, 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_SHOW_PARTITIONS_UNSUPPORTED, 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, COPY_INTO_UNSUPPORTED_FEATURE, CREATE_OR_REFRESH_MV_ST_ASYNC, CREATE_PERMANENT_VIEW_WITHOUT_ALIAS, CSV_ENFORCE_SCHEMA_NOT_SUPPORTED, DC_UNSUPPORTED_ERROR, DELTA_ADDING_DELETION_VECTORS_DISALLOWED, DELTA_ADD_CONSTRAINTS, DELTA_CANNOT_WRITE_INTO_VIEW, DELTA_CLUSTERING_CLONE_TABLE_NOT_SUPPORTED, DELTA_CLUSTERING_COLUMNS_DATATYPE_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_UNIFORM_INGRESS_NOT_SUPPORTED, 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, DESCRIBE_JSON_NOT_EXTENDED, DISTINCT_WINDOW_FUNCTION_UNSUPPORTED, EMPTY_SCHEMA_NOT_SUPPORTED_FOR_DATASOURCE, EXTERNAL_TABLE_INVALID_SCHEME, FABRIC_REFRESH_INVALID_SCOPE, FORBIDDEN_DATASOURCE_IN_SERVERLESS, FROM_JSON_INFERENCE_NOT_SUPPORTED, H3_NOT_ENABLED, HYBRID_ANALYZER_EXCEPTION, INFINITE_STREAMING_TRIGGER_NOT_SUPPORTED, INVALID_PANDAS_UDF_PLACEMENT, INVALID_PARTITION_COLUMN_DATA_TYPE, KINESIS_POLLING_MODE_UNSUPPORTED, MATERIALIZED_VIEW_OUTPUT_WITHOUT_EXPLICIT_ALIAS, MATERIALIZED_VIEW_UNSUPPORTED_OPERATION, METRIC_CONSTRAINT_NOT_SUPPORTED, MOVE_TABLE_BETWEEN_PIPELINES_FEATURE_DISABLED, 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, NOT_SUPPORTED_WITH_SERVERLESS, ONLY_SUPPORTED_WITH_UC_SQL_CONNECTOR, PIPE_OPERATOR_AGGREGATE_EXPRESSION_CONTAINS_NO_AGGREGATE_FUNCTION, PIPE_OPERATOR_CONTAINS_AGGREGATE_FUNCTION, PROCEDURE_CREATION_EMPTY_ROUTINE, PROCEDURE_NOT_SUPPORTED, PROCEDURE_NOT_SUPPORTED_WITH_HMS, PROTOBUF_JAVA_CLASSES_NOT_SUPPORTED, PS_SPARK_SPECULATION_NOT_SUPPORTED, PS_UNSUPPORTED_GET_OFFSET_CALL, RECIPIENT_EXPIRATION_NOT_SUPPORTED, RESTRICTED_STREAMING_OPTION_PERMISSION_ENFORCED, ROW_LEVEL_SECURITY_ABAC_MISMATCH, 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_SHOW_PARTITIONS_UNSUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_SOURCE_NOT_SUPPORTED, ROW_LEVEL_SECURITY_TABLE_CLONE_TARGET_NOT_SUPPORTED, ROW_LEVEL_SECURITY_UNSUPPORTED_PROVIDER, SAAS_CONNECTOR_UNSUPPORTED_ERROR, SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION, SET_TBLPROPERTIES_NOT_ALLOWED_FOR_DLT_DATASET, STAR_GROUP_BY_POS, STREAMING_AQE_NOT_SUPPORTED_FOR_STATEFUL_OPERATORS, STREAMING_FROM_MATERIALIZED_VIEW, STREAMING_REAL_TIME_MODE, ST_NOT_ENABLED, ST_UNSUPPORTED_RETURN_TYPE, TABLE_VALUED_ARGUMENTS_NOT_YET_IMPLEMENTED_FOR_SQL_FUNCTIONS, TRIGGER_SOURCE_TYPE_NOT_SUPPORTED, UC_HIVE_METASTORE_FEDERATION_NOT_ENABLED, UDF_PYSPARK_UNSUPPORTED_TYPE, UDF_UNSUPPORTED_PARAMETER_DEFAULT_VALUE, UNSTRUCTURED_DATA_PROCESSING_UNSUPPORTED_FILE_FORMAT, UNSTRUCTURED_DATA_PROCESSING_UNSUPPORTED_MODEL, UNSUPPORTED_ADD_FILE, UNSUPPORTED_ALTER_COLUMN_PARAMETER, UNSUPPORTED_ARROWTYPE, UNSUPPORTED_CALL, UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING, UNSUPPORTED_CLAUSE_FOR_OPERATION, UNSUPPORTED_COLLATION, UNSUPPORTED_CONSTRAINT_CLAUSES, UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY, UNSUPPORTED_DATATYPE, UNSUPPORTED_DATA_SOURCE_SAVE_MODE, UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE, UNSUPPORTED_DATA_TYPE_FOR_ENCODER, UNSUPPORTED_DEFAULT_VALUE, UNSUPPORTED_DESERIALIZER, UNSUPPORTED_FEATURE, UNSUPPORTED_FEATURE_FOR_WORKSPACE, UNSUPPORTED_FN_TYPE, UNSUPPORTED_JOIN_TYPE, UNSUPPORTED_LANGUAGE, UNSUPPORTED_NESTED_ROW_OR_COLUMN_ACCESS_POLICY, UNSUPPORTED_PARTITION_TRANSFORM, UNSUPPORTED_SAVE_MODE, UNSUPPORTED_SHOW_CREATE_TABLE, UNSUPPORTED_SINGLE_PASS_ANALYZER_FEATURE, UNSUPPORTED_STREAMING_OPERATOR_WITHOUT_WATERMARK, 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, UNSUPPORTED_UDF_FEATURE, UNSUPPORTED_UDF_TYPES_IN_SAME_PLACE
0AKD0Cross 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
0AKD1Security feature not supported
COLUMN_MASKS_UNSUPPORTED_CONSTANT_AS_PARAMETER, ROW_LEVEL_SECURITY_UNSUPPORTED_CONSTANT_AS_PARAMETER
0AKDCNot 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_COLLATIONS_NOT_SUPPORTED, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_PARTITIONED_COLUMN, DELTA_COLUMN_DATA_SKIPPING_NOT_SUPPORTED_TYPE, DELTA_CONVERSION_MERGE_ON_READ_NOT_SUPPORTED, DELTA_CONVERSION_UNSUPPORTED_COLLATED_PARTITION_COLUMN, DELTA_CONVERSION_UNSUPPORTED_COLUMN_MAPPING, DELTA_CONVERSION_UNSUPPORTED_SCHEMA_CHANGE, DELTA_CONVERT_NON_PARQUET_TABLE, DELTA_CREATE_TABLE_IDENTIFIER_LOCATION_MISMATCH, DELTA_DROP_COLUMN_ON_SINGLE_FIELD_SCHEMA, DELTA_GEOSPATIAL_NOT_SUPPORTED, 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_OPERATION_NOT_SUPPORTED_FOR_COLUMN_WITH_COLLATION, DELTA_OPERATION_NOT_SUPPORTED_FOR_EXPRESSION_WITH_COLLATION, DELTA_OPERATION_ON_VIEW_NOT_ALLOWED, DELTA_TABLE_FOR_PATH_UNSUPPORTED_HADOOP_CONF, DELTA_TRUNCATE_TABLE_PARTITION_NOT_SUPPORTED, DELTA_UNIFORM_COMPATIBILITY_LOCATION_CANNOT_BE_CHANGED, DELTA_UNIFORM_INGRESS_NOT_SUPPORTED_FORMAT, DELTA_UNIFORM_NOT_SUPPORTED, DELTA_UNIFORM_REFRESH_NOT_SUPPORTED, DELTA_UNIFORM_REFRESH_NOT_SUPPORTED_FOR_MANAGED_ICEBERG_TABLE_WITH_METADATA_PATH, 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_OPERATIONS_ON_COLUMNS_WITH_BLOOM_FILTER_INDEX, 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_TYPE_CHANGE_IN_SCHEMA, DELTA_UNSUPPORTED_TYPE_CHANGE_ON_COLUMNS_WITH_BLOOM_FILTER_INDEX, DELTA_UNSUPPORTED_VACUUM_SPECIFIC_PARTITION, DELTA_UNSUPPORTED_WRITES_WITHOUT_COORDINATOR, WRONG_COLUMN_DEFAULTS_FOR_DELTA_ALTER_TABLE_ADD_COLUMN_NOT_SUPPORTED
0AKDDFeature requires Delta
DELTA_COPY_INTO_TARGET_FORMAT, DELTA_IDENTITY_COLUMNS_ALTER_NON_DELTA_FORMAT, DELTA_IDENTITY_COLUMNS_NON_DELTA_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
0AKDEFeature non enabled for this Delta table
DELTA_CANNOT_DROP_CHECK_CONSTRAINT_FEATURE, DELTA_CANNOT_DROP_COLLATIONS_FEATURE, 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_DEPENDENT_FEATURE, 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
0AKUCNot 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_COMMAND_NOT_SUPPORTED_IN_SERVERLESS, UC_COMMAND_NOT_SUPPORTED_IN_SHARED_ACCESS_MODE, UC_CREDENTIAL_PURPOSE_NOT_SUPPORTED, UC_DATASOURCE_NOT_SUPPORTED, UC_DATASOURCE_OPTIONS_NOT_SUPPORTED, UC_FAILED_PROVISIONING_STATE, UC_FILE_SCHEME_FOR_TABLE_CREATION_NOT_SUPPORTED, UC_INVALID_NAMESPACE, UC_INVALID_REFERENCE, UPGRADE_NOT_SUPPORTED
0AKUDFeature requires Unity Catalog
FEATURE_REQUIRES_UC, OPERATION_REQUIRES_UNITY_CATALOG

Class 0B: invalid transaction initiation

SQLSTATEDescription and issuing error classes
0B000invalid transaction initiation
DELTA_ACTIVE_TRANSACTION_ALREADY_SET

Class 0N: SQL/XML mapping error

SQLSTATEDescription and issuing error classes
0N000SQL/XML mapping error
XML_UNSUPPORTED_NESTED_TYPES

Class 21: cardinality violation

SQLSTATEDescription and issuing error classes
21000cardinality violation
BOOLEAN_STATEMENT_WITH_EMPTY_ROW, ROW_SUBQUERY_TOO_MANY_ROWS, SCALAR_SUBQUERY_TOO_MANY_ROWS
21506The 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
21S01Insert value list does not match column list
COPY_INTO_COLUMN_ARITY_MISMATCH, CREATE_VIEW_COLUMN_ARITY_MISMATCH, INSERT_COLUMN_ARITY_MISMATCH, INSERT_PARTITION_COLUMN_ARITY_MISMATCH

Class 22: data exception

SQLSTATEDescription and issuing error classes
22000data 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, DELTA_VACUUM_COPY_INTO_STATE_FAILED, HLL_UNION_DIFFERENT_LG_K, INVALID_TIMESTAMP_FORMAT, KAFKA_DATA_LOSS, KINESIS_COULD_NOT_READ_SHARD_UNTIL_END_OFFSET, KINESIS_RECORD_SEQ_NUMBER_ORDER_VIOLATION, MALFORMED_CHARACTER_CODING, 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
22001string data, right truncation
DELTA_EXCEED_CHAR_VARCHAR_LIMIT
22003numeric value out of range
ARITHMETIC_OVERFLOW, BINARY_ARITHMETIC_OVERFLOW, CAST_OVERFLOW, CAST_OVERFLOW_IN_TABLE_INSERT, COLUMN_ORDINAL_OUT_OF_BOUNDS, DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION, DELTA_CANNOT_RESTORE_TABLE_VERSION, DELTA_CANNOT_RESTORE_TIMESTAMP_EARLIER, 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, NEGATIVE_VALUES_IN_FREQUENCY_EXPRESSION, NUMERIC_OUT_OF_SUPPORTED_RANGE, NUMERIC_VALUE_OUT_OF_RANGE, SCHEDULE_PERIOD_INVALID, SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT, TRIGGER_INTERVAL_INVALID, TRIGGER_INTERVAL_VALUE_INVALID
22004null value not allowed
COMPARATOR_RETURNS_NULL, NULL_QUERY_STRING_EXECUTE_IMMEDIATE
22005error in assignment
DELTA_COMPLEX_TYPE_COLUMN_CONTAINS_NULL_TYPE, DELTA_FAILED_TO_MERGE_FIELDS, DELTA_MERGE_UNEXPECTED_ASSIGNMENT_KEY
22006invalid interval format
CANNOT_PARSE_INTERVAL, DELTA_INVALID_INTERVAL, INVALID_INTERVAL_FORMAT, INVALID_INTERVAL_WITH_MICROSECONDS_ADDITION
22007invalid datetime format
CANNOT_PARSE_TIMESTAMP, DELTA_INVALID_TIMESTAMP_FORMAT, INVALID_DATETIME_PATTERN
22008datetime field overflow
DATETIME_OVERFLOW
22009invalid time zone displacement value
ILLEGAL_DAY_OF_WEEK, INVALID_TIMEZONE
2200Enull value in array target
NULL_MAP_KEY
2200Gmost specific type mismatch
DELTA_COLUMN_STRUCT_TYPE_MISMATCH
2200Pinterval value out of range
DELTA_INVALID_CALENDAR_INTERVAL_EMPTY
22012division by zero
DIVIDE_BY_ZERO, INTERVAL_DIVIDED_BY_ZERO
22015interval field overflow
INTERVAL_ARITHMETIC_OVERFLOW
22018invalid 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
2201Binvalid regular expression
DELTA_REGEX_OPT_SYNTAX_ERROR
2201Einvalid argument for natural logarithm
STRUCT_ARRAY_LENGTH_MISMATCH
22022indicator overflow
INVALID_CONF_VALUE
22023invalid parameter value
AI_FUNCTION_INVALID_MODEL_PARAMETERS, CONFLICTING_PROVIDER, DATETIME_FIELD_OUT_OF_BOUNDS, 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_HTTP_REQUEST_METHOD, INVALID_HTTP_REQUEST_PATH, INVALID_JSON_RECORD_TYPE, INVALID_PARAMETER_MARKER_VALUE, INVALID_PARAMETER_VALUE, INVALID_REGEXP_REPLACE, INVALID_VARIANT_CAST, INVALID_VARIANT_FROM_PARQUET, INVALID_VARIANT_GET_PATH, INVALID_VARIANT_SHREDDING_SCHEMA, KINESIS_SOURCE_REGISTERED_CONSUMER_ID_COUNT_MISMATCH, KINESIS_SOURCE_REGISTERED_CONSUMER_NOT_FOUND, KINESIS_SOURCE_REGISTERED_CONSUMER_TYPE_INVALID, MALFORMED_RECORD_IN_PARSING, MALFORMED_VARIANT, MAX_RECORDS_PER_FETCH_INVALID_FOR_KINESIS_SOURCE, METRIC_STORE_INVALID_ARGUMENT_VALUE_ERROR, ROW_VALUE_IS_NULL, 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_INDEX_VALUE, ST_INVALID_PRECISION_VALUE, ST_INVALID_SRID_VALUE, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INCOMPATIBLE_WITH_CALL, TABLE_VALUED_FUNCTION_REQUIRED_METADATA_INVALID, UNKNOWN_PRIMITIVE_TYPE_IN_VARIANT, VARIANT_CONSTRUCTOR_SIZE_LIMIT, VARIANT_DUPLICATE_KEY, VARIANT_SIZE_LIMIT, WKB_PARSE_ERROR, WKT_PARSE_ERROR, XML_WILDCARD_RESCUED_DATA_CONFLICT_ERROR
22024unterminated C string
NULL_DATA_SOURCE_OPTION
22029noncharacter in UCS string
INVALID_UTF8_STRING
22032invalid 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
2203Gsql json item cannot be cast to target type
AI_FUNCTION_HTTP_PARSE_CAST_ERROR, AI_FUNCTION_HTTP_PARSE_COLUMNS_ERROR, AI_FUNCTION_MODEL_SCHEMA_PARSE_ERROR, CANNOT_PARSE_JSON_FIELD, FAILED_ROW_TO_JSON, INVALID_JSON_DATA_TYPE, INVALID_JSON_DATA_TYPE_FOR_COLLATIONS
22525Partitioning key value is not valid.
DELTA_PARTITION_COLUMN_CAST_FAILED
22531The argument of a built-in or system provided routine resulted in an error.
INVALID_SECRET_LOOKUP
22546The value for a routine argument is not valid.
CANNOT_DECODE_URL, HLL_INVALID_INPUT_SKETCH_BUFFER, HLL_INVALID_LG_K, INVALID_BOOLEAN_STATEMENT
22KD0Transient error
DELTA_FEATURE_DROP_CHECKPOINT_FAILED, DELTA_FEATURE_DROP_CHECKPOINT_PROTECTION_WAIT_FOR_RETENTION_PERIOD
22KD1Invalid URI or PATH
DELTA_CANNOT_RECONSTRUCT_PATH_FROM_URI, DELTA_CANNOT_RENAME_PATH, DELTA_INVALID_CLONE_PATH, DELTA_INVALID_PARTITION_PATH, INVALID_NON_ABSOLUTE_PATH
22KD2Identity claim is unset
OAUTH_CUSTOM_IDENTITY_CLAIM_NOT_PROVIDED
22KD3Cannot evolve source type to target type.
AVRO_INCOMPATIBLE_READ_TYPE, CANNOT_USE_KRYO, FROM_JSON_SCHEMA_EVOLUTION_FAILED, PROTOBUF_NOT_LOADED_SQL_FUNCTIONS_UNUSABLE
22P02invalid text representation
INVALID_URL
22P03invalid binary representation
INVALID_BYTE_STRING

Class 23: integrity constraint violation

SQLSTATEDescription and issuing error classes
23001restrict violation
DELTA_VIOLATE_CONSTRAINT_WITH_VALUES
23502An insert or update value is null, but the column cannot contain null values.
DELTA_MISSING_NOT_NULL_COLUMN_VALUE, DELTA_NOT_NULL_CONSTRAINT_VIOLATED
23505A violation of the constraint imposed by a unique index or a unique constraint occurred.
DUPLICATED_MAP_KEY, DUPLICATE_KEY
23512The 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
23K01MERGE cardinality violation
MERGE_CARDINALITY_VIOLATION

Class 25: invalid transaction state

SQLSTATEDescription and issuing error classes
25000invalid 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 28: invalid authorization specification

SQLSTATEDescription and issuing error classes
28000invalid authorization specification
DELTA_SHARING_INVALID_PROVIDER_AUTH, DELTA_SHARING_INVALID_RECIPIENT_AUTH

Class 2B: dependent privilege descriptors still exist

SQLSTATEDescription and issuing error classes
2BP01dependent objects still exist
SCHEMA_NOT_EMPTY

Class 2D: invalid transaction termination

SQLSTATEDescription and issuing error classes
2D521SQL COMMIT or ROLLBACK are invalid in the current operating environment.
DELTA_CONCURRENT_APPEND, DELTA_CONCURRENT_DELETE_DELETE, DELTA_CONCURRENT_DELETE_READ, DELTA_CONCURRENT_TRANSACTION, DELTA_CONCURRENT_WRITE, DELTA_DELETION_VECTOR_MISSING_NUM_RECORDS, DELTA_DUPLICATE_ACTIONS_FOUND, DELTA_METADATA_CHANGED, DELTA_PROTOCOL_CHANGED
2DKD0Post commit hook failed.
DELTA_POST_COMMIT_HOOK_FAILED

Class 38: external routine exception

SQLSTATEDescription and issuing error classes
38000external routine exception
CLASS_NOT_OVERRIDE_EXPECTED_METHOD, FAILED_FUNCTION_CALL, FAILED_TO_LOAD_ROUTINE, INVALID_UDF_IMPLEMENTATION, NO_UDF_INTERFACE, PYTHON_DATA_SOURCE_ERROR, PYTHON_STREAMING_DATA_SOURCE_RUNTIME_ERROR, TABLE_VALUED_FUNCTION_FAILED_TO_ANALYZE_IN_PYTHON

Class 39: external routine invocation exception

SQLSTATEDescription and issuing error classes
39000external routine invocation exception
FAILED_EXECUTE_UDF, FLATMAPGROUPSWITHSTATE_USER_FUNCTION_ERROR, FOREACH_BATCH_USER_FUNCTION_ERROR, FOREACH_USER_FUNCTION_ERROR, ISOLATED_COMMAND_FAILURE, ISOLATED_COMMAND_UNKNOWN_FAILURE, UDF_ENVIRONMENT_ERROR, UDF_PYSPARK_ERROR, UDF_PYSPARK_USER_CODE_ERROR, UDF_USER_CODE_ERROR

Class 3D: invalid catalog name

SQLSTATEDescription and issuing error classes
3D000invalid catalog name
UC_CATALOG_NAME_NOT_PROVIDED

Class 3F: invalid schema name

SQLSTATEDescription and issuing error classes
3F000invalid schema name
MISSING_DATABASE_FOR_V1_SESSION_CATALOG

Class 40: transaction rollback

SQLSTATEDescription and issuing error classes
40000transaction rollback
CONCURRENT_STREAM_LOG_UPDATE, DELTA_MAX_COMMIT_RETRIES_EXCEEDED, MOVE_TABLE_BETWEEN_PIPELINES_TABLE_CHANGED

Class 42: syntax error or access rule violation

SQLSTATEDescription and issuing error classes
42000syntax error or access rule violation
AMBIGUOUS_REFERENCE_TO_FIELDS, CANNOT_REMOVE_RESERVED_PROPERTY, CF_AMBIGUOUS_AUTH_OPTIONS_ERROR, CF_AMBIGUOUS_INCREMENTAL_LISTING_MODE_ERROR, CF_AZURE_AUTHENTICATION_MISSING_OPTIONS, CF_AZURE_AUTHENTICATION_MULTIPLE_OPTIONS, 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_AZURE_CERTIFICATE, CF_INVALID_AZURE_CERT_PRIVATE_KEY, 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_SCHEMA_LOG_DEEP_CLONE_FAILED, CF_SFTP_MISSING_PASSWORD_OR_KEY_FILE, CF_SFTP_USERNAME_NOT_FOUND, 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, CLUSTERING_NOT_SUPPORTED, COMMENT_ON_CONNECTION_NOT_IMPLEMENTED_YET, CONNECTION_ALREADY_EXISTS, CONNECTION_NAME_CANNOT_BE_EMPTY, CONNECTION_NOT_FOUND, CONNECTION_OPTION_NOT_SUPPORTED, CONNECTION_TYPE_NOT_SUPPORTED, COPY_UNLOAD_FORMAT_TYPE_NOT_SUPPORTED, CREATE_FOREIGN_SCHEMA_NOT_IMPLEMENTED_YET, CREATE_FOREIGN_TABLE_NOT_IMPLEMENTED_YET, 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_TO_PARTITIONED_TABLE_WITH_NON_EMPTY_CLUSTERING_COLUMNS, 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_INVENTORY_SCHEMA, 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, DROP_SCHEDULE_DOES_NOT_EXIST, DROP_SCHEDULE_SCHEDULE_DOES_NOT_EXIST, FOREIGN_OBJECT_NAME_CANNOT_BE_EMPTY, INVALID_AWS_AUTHENTICATION, INVALID_AWS_AUTHENTICATION_EXPLICIT_OPTIONS, INVALID_COLUMN_OR_FIELD_DATA_TYPE, INVALID_EXTRACT_BASE_FIELD_TYPE, INVALID_EXTRACT_FIELD_TYPE, INVALID_FIELD_NAME, INVALID_INLINE_TABLE, INVALID_QUALIFIED_COLUMN_NAME, INVALID_RESET_COMMAND_FORMAT, INVALID_SAVE_MODE, INVALID_SET_SYNTAX, INVALID_SQL_SYNTAX, INVALID_USAGE_OF_STAR_OR_REGEX, INVALID_WRITE_DISTRIBUTION, MATERIALIZED_VIEW_OVER_STREAMING_QUERY_INVALID, MISSING_CONNECTION_OPTION, MISSING_NAME_FOR_CHECK_CONSTRAINT, MISSING_SCHEDULE_DEFINITION, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_NOT_FOUND, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_PERMISSION_DENIED, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_NOT_FOUND, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_PERMISSION_DENIED, MULTIPLE_LOAD_PATH, MULTIPLE_QUERY_RESULT_CLAUSES_WITH_PIPE_OPERATORS, NAMESPACE_ALREADY_EXISTS, NAMESPACE_NOT_EMPTY, NAMESPACE_NOT_FOUND, NON_PARTITION_COLUMN, NOTEBOOK_NOT_FOUND, NOT_NULL_ASSERT_VIOLATION, NOT_NULL_CONSTRAINT_VIOLATION, NO_HANDLER_FOR_UDAF, NULLABLE_COLUMN_OR_FIELD, NULLABLE_ROW_ID_ATTRIBUTES, PARTITION_COLUMN_NOT_FOUND_IN_SCHEMA, PS_INVALID_EMPTY_OPTION, PS_INVALID_OPTION, PS_INVALID_OPTION_TYPE, PS_INVALID_READ_LIMIT, PS_MISSING_AUTH_INFO, PS_MISSING_REQUIRED_OPTION, PS_MULTIPLE_AUTH_OPTIONS, PS_PROVIDE_CREDENTIALS_WITH_OPTION, PS_UNABLE_TO_CREATE_SUBSCRIPTION, ROUTINE_PARAMETER_NOT_FOUND, STREAMING_TABLE_QUERY_INVALID, UNSTRUCTURED_OCR_COLUMN_NOT_ALLOWED_WITH_METADATA_MODEL_OPTION, UNSUPPORTED_BATCH_TABLE_VALUED_FUNCTION, UNSUPPORTED_CONSTRAINT_TYPE, UNSUPPORTED_STREAMING_TABLE_VALUED_FUNCTION, VOLUME_ALREADY_EXISTS
42001Invalid encoder error
INVALID_EXPRESSION_ENCODER
42501The 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, CLUSTER_CREATION_PERMISSION_DENIED, CLUSTER_POLICY_PERMISSION_DENIED, 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
42601A 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_COLUMN_MISSING_DATA_TYPE, DELTA_CREATE_EXTERNAL_TABLE_WITHOUT_SCHEMA, DELTA_CREATE_TABLE_MISSING_TABLE_NAME_OR_LOCATION, DELTA_CREATE_TABLE_WITH_NON_EMPTY_LOCATION, DELTA_DUPLICATE_DOMAIN_METADATA_INTERNAL_ERROR, DELTA_FAILED_RECOGNIZE_PREDICATE, DELTA_IDENTITY_COLUMNS_PARTITION_NOT_SUPPORTED, 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_OPTIMIZE_FULL_NOT_SUPPORTED, DELTA_UNEXPECTED_ACTION_EXPRESSION, DELTA_UNIFORM_COMPATIBILITY_MISSING_OR_INVALID_LOCATION, 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, GET_WARMUP_TRACING_FAILED, GET_WARMUP_TRACING_FUNCTION_NOT_ALLOWED, IDENTIFIER_TOO_MANY_NAME_PARTS, IDENTITY_COLUMNS_DUPLICATED_SEQUENCE_GENERATOR_OPTION, ILLEGAL_STATE_STORE_VALUE, INVALID_ATTRIBUTE_NAME_SYNTAX, INVALID_BUCKET_COLUMN_DATA_TYPE, INVALID_EXTRACT_FIELD, INVALID_FORMAT, INVALID_PARTITION_OPERATION, INVALID_SHARED_ALIAS_NAME, INVALID_STATEMENT_OR_CLAUSE, INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC, LOCAL_MUST_WITH_SCHEMA_FILE, MERGE_WITHOUT_WHEN, MIGRATION_NOT_SUPPORTED, MISSING_CLAUSES_FOR_OPERATION, MV_ST_ALTER_QUERY_INCORRECT_BACKING_TYPE, NOT_ALLOWED_IN_FROM, NOT_ALLOWED_IN_PIPE_OPERATOR_WHERE, NOT_A_CONSTANT_STRING, NOT_UNRESOLVED_ENCODER, PARSE_MODE_UNSUPPORTED, PARSE_SYNTAX_ERROR, PROCEDURE_CREATION_PARAMETER_OUT_INOUT_WITH_DEFAULT, 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, SYNTAX_DISCONTINUED, TRAILING_COMMA_IN_SELECT, 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
42602A character that is invalid in a name has been detected.
CIRCULAR_CLASS_REFERENCE, DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS, DUPLICATED_CTE_NAMES, INVALID_DELIMITER_VALUE, INVALID_IDENTIFIER, INVALID_PROPERTY_KEY, INVALID_PROPERTY_VALUE, INVALID_SCHEMA_OR_RELATION_NAME
42604An 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
42605The number of arguments specified for a scalar function is invalid.
INCORRECT_NUMBER_OF_ARGUMENTS, PROCEDURE_ARGUMENT_NUMBER_MISMATCH, WRONG_NUM_ARGS
42607An operand of an aggregate function or CONCAT operator is invalid.
NESTED_AGGREGATE_FUNCTION
42608The use of NULL or DEFAULT in VALUES or an assignment statement is invalid.
DEFAULT_PLACEMENT_INVALID, NO_DEFAULT_COLUMN_VALUE_AVAILABLE
42611The column, argument, parameter, or global variable definition is invalid.
CANNOT_ASSIGN_EVENT_TIME_COLUMN_WITHOUT_WATERMARK, DELTA_IDENTITY_COLUMNS_ILLEGAL_STEP, IDENTITY_COLUMNS_ILLEGAL_STEP
42613Clauses are mutually exclusive.
COPY_INTO_FEATURE_INCOMPATIBLE_SETTING, 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_IDENTITY_COLUMNS_WITH_GENERATED_EXPRESSION, 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_JOIN_TYPE_FOR_JOINWITH, 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
42614A duplicate keyword or clause is invalid.
DELTA_MULTIPLE_CDC_BOUNDARY, DELTA_MULTIPLE_CONF_FOR_SINGLE_COLUMN_IN_BLOOM_FILTER, DUPLICATE_CLAUSES, REPEATED_CLAUSE
42616Invalid options specified
BIGQUERY_OPTIONS_ARE_MUTUALLY_EXCLUSIVE, DELTA_CANNOT_MODIFY_COORDINATED_COMMITS_DEPENDENCIES, DELTA_CANNOT_OVERRIDE_COORDINATED_COMMITS_CONFS, DELTA_CANNOT_SET_COORDINATED_COMMITS_DEPENDENCIES, DELTA_CANNOT_SET_MANAGED_STATS_COLUMNS_PROPERTY, DELTA_CANNOT_SET_UC_COMMIT_COORDINATOR_CONF_IN_COMMAND, DELTA_CANNOT_SET_UC_COMMIT_COORDINATOR_CONF_IN_SESSION, DELTA_CANNOT_UNSET_COORDINATED_COMMITS_CONFS, DELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_COMMAND, DELTA_CONF_OVERRIDE_NOT_SUPPORTED_IN_SESSION, DELTA_ILLEGAL_OPTION, DELTA_INVALID_IDEMPOTENT_WRITES_OPTIONS, DELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_COMMAND, DELTA_MUST_SET_ALL_COORDINATED_COMMITS_CONFS_IN_SESSION, DELTA_NON_UC_COMMIT_COORDINATOR_NOT_SUPPORTED_IN_COMMAND, DELTA_NON_UC_COMMIT_COORDINATOR_NOT_SUPPORTED_IN_SESSION, DELTA_UNSET_NON_EXISTENT_PROPERTY, INAPPROPRIATE_URI_SCHEME_OF_CONNECTION_OPTION, STDS_INVALID_OPTION_VALUE, UNSUPPORTED_COMMON_ANCESTOR_LOC_FOR_FILE_STREAM_SOURCE, UNSUPPORTED_INITIAL_POSITION_AND_TRIGGER_PAIR_FOR_KINESIS_SOURCE
42617The statement string is blank or empty.
PARSE_EMPTY_STATEMENT
42621The check constraint or generated column expression is invalid.
DELTA_AGGREGATE_IN_GENERATED_COLUMN, DELTA_INVALID_GENERATED_COLUMN_REFERENCES, DELTA_NON_BOOLEAN_CHECK_CONSTRAINT, DELTA_NON_DETERMINISTIC_EXPRESSION_IN_GENERATED_COLUMN, DELTA_UDF_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_DATA_TYPE_IN_GENERATED_COLUMN, DELTA_UNSUPPORTED_EXPRESSION_GENERATED_COLUMN, UNSUPPORTED_EXPRESSION_GENERATED_COLUMN
42623A DEFAULT clause cannot be specified.
ADD_DEFAULT_UNSUPPORTED, DEFAULT_UNSUPPORTED, GENERATED_COLUMN_WITH_DEFAULT_VALUE, INVALID_DEFAULT_VALUE
42701The 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
42702A 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
42703An 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
42704An undefined object or constraint name was detected.
ALTER_SCHEDULE_DOES_NOT_EXIST, ALTER_SCHEDULE_SCHEDULE_DOES_NOT_EXIST, AMBIGUOUS_REFERENCE, CANNOT_RESOLVE_DATAFRAME_COLUMN, CANNOT_RESOLVE_STAR_EXPAND, CODEC_SHORT_NAME_NOT_FOUND, COLLATION_INVALID_NAME, COLLATION_INVALID_PROVIDER, DATA_SOURCE_NOT_EXIST, DEFAULT_DATABASE_NOT_EXISTS, DELTA_COLUMN_PATH_NOT_NESTED, DELTA_CONSTRAINT_DOES_NOT_EXIST, DELTA_SHARING_CURRENT_RECIPIENT_PROPERTY_UNDEFINED, DELTA_SHARING_RECIPIENT_PROPERTY_NOT_FOUND, DELTA_SHARING_RECIPIENT_TOKENS_NOT_FOUND, ENCODER_NOT_FOUND, FIELD_NOT_FOUND, INDEX_NOT_FOUND, NO_SUCH_CATALOG_EXCEPTION, SCHEMA_NOT_FOUND, UC_VOLUME_NOT_FOUND, UNRECOGNIZED_SQL_TYPE, UNRECOGNIZED_STATISTIC
42710A 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, FIELD_ALREADY_EXISTS, FOUND_MULTIPLE_DATA_SOURCES, INDEX_ALREADY_EXISTS, LOCATION_ALREADY_EXISTS, MULTIPLE_XML_DATA_SOURCE, REFRESH_MODE_ALREADY_EXISTS, SCHEDULE_ALREADY_EXISTS
42711A duplicate column name was detected in the object definition or ALTER TABLE statement.
COLUMN_ALREADY_EXISTS, CONFLICTING_COLUMN_NAMES_ERROR, DELTA_DUPLICATE_COLUMNS_FOUND, DELTA_TABLE_ALREADY_CONTAINS_CDC_COLUMNS, DUPLICATE_ROUTINE_RETURNS_COLUMNS
42713A 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
42723A routine with the same signature already exists in the schema, module, or compound block where it is defined.
ROUTINE_ALREADY_EXISTS, VARIABLE_ALREADY_EXISTS
42734A 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
4274KInvalid 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_ALREADY_PROVIDED_POSITIONALLY, REQUIRED_PARAMETER_NOT_FOUND, RESCUED_DATA_COLUMN_CONFLICT_WITH_SINGLE_VARIANT, UNEXPECTED_POSITIONAL_ARGUMENT, UNKNOWN_POSITIONAL_ARGUMENT, UNRECOGNIZED_PARAMETER_NAME
42802The 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, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_HANDLE_STATE, STATEFUL_PROCESSOR_CANNOT_PERFORM_OPERATION_WITH_INVALID_TIME_MODE, STATEFUL_PROCESSOR_DUPLICATE_STATE_VARIABLE_DEFINED, STATEFUL_PROCESSOR_INCORRECT_TIME_MODE_TO_ASSIGN_TTL, STATEFUL_PROCESSOR_TTL_DURATION_MUST_BE_POSITIVE, STATEFUL_PROCESSOR_UNKNOWN_TIME_MODE, STATE_STORE_CANNOT_CREATE_COLUMN_FAMILY_WITH_RESERVED_CHARS, STATE_STORE_CANNOT_USE_COLUMN_FAMILY_WITH_INVALID_NAME, STATE_STORE_COLUMN_FAMILY_SCHEMA_INCOMPATIBLE, STATE_STORE_HANDLE_NOT_INITIALIZED, STATE_STORE_INCORRECT_NUM_ORDERING_COLS_FOR_RANGE_SCAN, STATE_STORE_INCORRECT_NUM_PREFIX_COLS_FOR_PREFIX_SCAN, STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED, STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY, STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED, UDTF_ALIAS_NUMBER_MISMATCH, UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD, UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FROM_ANALYZE_METHOD_REQUIRES_ALIAS
42803A 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
42804The result expressions in a CASE expression are not compatible.
INVALID_CORRUPT_RECORD_TYPE
42805An 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
42806A value cannot be assigned to a variable, because the data types are not compatible.
DELTA_MERGE_INCOMPATIBLE_DECIMAL_TYPE
42807The data-change statement is not permitted on this object.
DELTA_CHANGE_TABLE_FEED_DISABLED, DELTA_UNSUPPORTED_WRITES_STAGED_TABLE
42808A column identified in the INSERT or UPDATE operation is not updatable.
DELTA_IDENTITY_COLUMNS_EXPLICIT_INSERT_NOT_SUPPORTED, DELTA_IDENTITY_COLUMNS_UPDATE_NOT_SUPPORTED
42809The 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_TARGET_FOR_ALTER_COMMAND, INVALID_TARGET_FOR_SET_TBLPROPERTIES_COMMAND, INVALID_UPGRADE_SYNTAX, NOT_A_PARTITIONED_TABLE, UNSUPPORTED_INSERT, WRONG_COMMAND_FOR_OBJECT_TYPE
42815The data type, length, scale, value, or CCSID is invalid.
EMITTING_ROWS_OLDER_THAN_WATERMARK_NOT_ALLOWED
42816A datetime value or duration in an expression is invalid.
DELTA_TIMESTAMP_GREATER_THAN_COMMIT, DELTA_TIMESTAMP_INVALID
42818The operands of an operator or function are not compatible or comparable.
INCOMPARABLE_PIVOT_COLUMN
42822An expression in the ORDER BY clause or GROUP BY clause is not valid.
EXPRESSION_TYPE_IS_NOT_ORDERABLE, GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE
42823Multiple columns are returned from a subquery that only allows one column.
INVALID_SUBQUERY_EXPRESSION
42825The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have compatible columns.
CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE, INCOMPATIBLE_COLUMN_TYPE
42826The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have the same number of columns.
NUM_COLUMNS_MISMATCH, NUM_TABLE_VALUE_ALIASES_MISMATCH
42830The foreign key does not conform to the description of the parent key.
FOREIGN_KEY_MISMATCH
42832The 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
42837The column cannot be altered, because its attributes are not compatible with the current column attributes.
DELTA_ALTER_TABLE_CHANGE_COL_NOT_SUPPORTED
42845An invalid use of a NOT DETERMINISTIC or EXTERNAL ACTION function was detected.
AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION
42846Cast 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, INVALID_PARTITION_VALUE, PARQUET_CONVERSION_FAILURE, PARQUET_TYPE_ILLEGAL, PARQUET_TYPE_NOT_RECOGNIZED, PARQUET_TYPE_NOT_SUPPORTED, UNEXPECTED_SERIALIZER_FOR_CLASS
42852The privileges specified in GRANT or REVOKE are invalid or inconsistent. (For example, GRANT ALTER on a view.)
INVALID_PRIVILEGE
42883No routine was found with a matching signature.
ROUTINE_NOT_FOUND, UNRESOLVABLE_TABLE_VALUED_FUNCTION, UNRESOLVED_ROUTINE, UNRESOLVED_VARIABLE, VARIABLE_NOT_FOUND
42887The function or table-reference is not valid in the context where it occurs.
CF_INCORRECT_BATCH_USAGE, CF_INCORRECT_STREAM_USAGE, CYCLIC_FUNCTION_REFERENCE, DELTA_SHARING_INVALID_OP_IN_EXTERNAL_SHARED_VIEW, INVALID_CURRENT_RECIPIENT_USAGE, NOT_A_SCALAR_FUNCTION, NOT_A_TABLE_FUNCTION
42891A duplicate constraint already exists.
MULTIPLE_MATCHING_CONSTRAINTS
428C4The number of elements on each side of the predicate operator is not the same.
UNPIVOT_VALUE_SIZE_MISMATCH
428EKThe schema qualifier is not valid.
TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS
428FRA column cannot be altered as specified.
CANNOT_ALTER_COLLATION_BUCKET_COLUMN, CANNOT_ALTER_PARTITION_COLUMN, DELTA_ALTER_COLLATION_NOT_SUPPORTED_BLOOM_FILTER, DELTA_ALTER_COLLATION_NOT_SUPPORTED_CLUSTER_BY
428FTThe partitioning clause specified on CREATE or ALTER is not valid.
DELTA_CANNOT_USE_ALL_COLUMNS_FOR_PARTITION, PARTITIONS_ALREADY_EXIST, PARTITIONS_NOT_FOUND
428GUA 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
428H2Data type is not supported in the context where it is being used.
DELTA_IDENTITY_COLUMNS_UNSUPPORTED_DATA_TYPE, EXCEPT_NESTED_COLUMN_INVALID_TYPE, IDENTITY_COLUMNS_UNSUPPORTED_DATA_TYPE
428HDThe 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
42902The object of the INSERT, UPDATE, or DELETE is also identified (possibly implicitly through a view) in a FROM clause.
UNSUPPORTED_OVERWRITE
42903Invalid use of an aggregate function or OLAP function.
DELTA_AGGREGATION_NOT_SUPPORTED, GROUP_BY_AGGREGATE, GROUP_BY_POS_AGGREGATE, INVALID_AGGREGATE_FILTER, INVALID_WHERE_CONDITION
42908The 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
42939The name cannot be used, because the specified identifier is reserved for system use.
DELTA_CANNOT_CHANGE_PROVIDER, DELTA_CANNOT_MODIFY_TABLE_PROPERTY, DELTA_SHARING_CANNOT_MODIFY_RESERVED_RECIPIENT_PROPERTY, RESERVED_CDC_COLUMNS_ON_WRITE, ROUTINE_USES_SYSTEM_RESERVED_CLASS_NAME
42996A specified column may not be used in a partition key.
DELTA_INVALID_PARTITION_COLUMN, DELTA_INVALID_PARTITION_COLUMN_NAME, DELTA_INVALID_PARTITION_COLUMN_TYPE
429BBThe data type of a column, parameter, or SQL variable is not supported.
CANNOT_RECOGNIZE_HIVE_TYPE
429BQThe 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, DELTA_IDENTITY_COLUMNS_ALTER_COLUMN_NOT_SUPPORTED, DELTA_IDENTITY_COLUMNS_ALTER_NON_IDENTITY_COLUMN, DELTA_IDENTITY_COLUMNS_REPLACE_COLUMN_NOT_SUPPORTED
42K01data type not fully specified
DATATYPE_MISSING_SIZE, INCOMPLETE_TYPE_DEFINITION
42K02data source not found
DATA_SOURCE_NOT_FOUND, STREAM_NOT_FOUND_FOR_KINESIS_SOURCE
42K03File 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, READ_CURRENT_FILE_NOT_FOUND, RENAME_SRC_PATH_NOT_FOUND, STDS_FAILED_TO_READ_OPERATOR_METADATA, STDS_FAILED_TO_READ_STATE_SCHEMA, STREAMING_STATEFUL_OPERATOR_NOT_MATCH_IN_STATE_METADATA
42K04Duplicate 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
42K05Name 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, DELTA_SHARING_INVALID_SHARED_DATA_OBJECT_NAME, INVALID_EMPTY_LOCATION, REQUIRES_SINGLE_PART_NAMESPACE, ROW_LEVEL_SECURITY_MULTI_PART_COLUMN_NAME, SHOW_COLUMNS_WITH_CONFLICT_NAMESPACE
42K06Invalid type for options
DELTA_PROTOCOL_PROPERTY_NOT_INT, INVALID_OPTIONS, STATE_STORE_DOES_NOT_SUPPORT_REUSABLE_ITERATOR, STATE_STORE_INVALID_CONFIG_AFTER_RESTART, STATE_STORE_INVALID_PROVIDER, STATE_STORE_INVALID_VARIABLE_TYPE_CHANGE, STATE_STORE_PROVIDER_DOES_NOT_SUPPORT_FINE_GRAINED_STATE_REPLAY, STATE_STORE_STATE_SCHEMA_FILES_THRESHOLD_EXCEEDED, STATE_STORE_VALUE_SCHEMA_EVOLUTION_THRESHOLD_EXCEEDED
42K07Not a valid schema literal
INVALID_SCHEMA
42K08Not a constant
ARGUMENT_NOT_CONSTANT, INVALID_SQL_ARG, NON_FOLDABLE_ARGUMENT, NON_LITERAL_PIVOT_VALUES, SEED_EXPRESSION_IS_UNFOLDABLE
42K09Data type mismatch
COMPLEX_EXPRESSION_UNSUPPORTED_INPUT, DATATYPE_MISMATCH, DELTA_CONSTRAINT_DATA_TYPE_MISMATCH, DELTA_CONSTRAINT_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_DATA_TYPE_MISMATCH, DELTA_GENERATED_COLUMNS_DEPENDENT_COLUMN_CHANGE, DELTA_GENERATED_COLUMNS_EXPR_TYPE_MISMATCH, DELTA_GENERATED_COLUMN_UPDATE_TYPE_MISMATCH, DELTA_MERGE_ADD_VOID_COLUMN, 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, UNEXPECTED_INPUT_TYPE_OF_NAMED_PARAMETER, UNPIVOT_VALUE_DATA_TYPE_MISMATCH
42K0AInvalid UNPIVOT clause
UNPIVOT_REQUIRES_ATTRIBUTES, UNPIVOT_REQUIRES_VALUE_COLUMNS
42K0BLegacy feature blocked
INCONSISTENT_BEHAVIOR_CROSS_VERSION
42K0CAmbiguous reference to constraint
AMBIGUOUS_CONSTRAINT, CANNOT_DROP_AMBIGUOUS_CONSTRAINT
42K0DInvalid lambda function
INVALID_LAMBDA_FUNCTION_CALL
42K0EAn expression is not valid in the 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, METRIC_VIEW_CACHE_TABLE_NOT_SUPPORTED, METRIC_VIEW_FEATURE_DISABLED, METRIC_VIEW_INVALID_MEASURE_FUNCTION_INPUT, METRIC_VIEW_IN_CTE_NOT_SUPPORTED, METRIC_VIEW_JOIN_NOT_SUPPORTED, METRIC_VIEW_MISSING_MEASURE_FUNCTION, METRIC_VIEW_UNSUPPORTED_USAGE, METRIC_VIEW_WINDOW_FUNCTION_NOT_SUPPORTED, MULTIPLE_TIME_TRAVEL_SPEC, MULTI_ALIAS_WITHOUT_GENERATOR, 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
42K0FA persisted object cannot reference a temporary object.
INVALID_TEMP_OBJ_REFERENCE
42K0GA 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
42K0HA cyclic invocation has been detected.
RECURSIVE_VIEW
42K0ISQL Config not found.
CONFIG_NOT_AVAILABLE, DELTA_UNIFORM_COMPATIBILITY_LOCATION_NOT_REGISTERED, SQL_CONF_NOT_FOUND
42K0KInvalid inverse distribution function
INVALID_INVERSE_DISTRIBUTION_FUNCTION
42K0LInvalid usage of labels.
END_LABEL_WITHOUT_BEGIN_LABEL, INVALID_LABEL_USAGE, LABELS_MISMATCH, LABEL_ALREADY_EXISTS
42K0MInvalid variable declaration.
INVALID_VARIABLE_DECLARATION
42K0NInvalid external type.
INVALID_EXTERNAL_TYPE
42K0OScalarFunction not overrides method ‘produceResult(InternalRow)’ with custom implementation.
SCALAR_FUNCTION_NOT_COMPATIBLE
42K0PScalarFunction not implements or overrides method ‘produceResult(InternalRow)’.
SCALAR_FUNCTION_NOT_FULLY_IMPLEMENTED
42K10Invalid dynamic option.
INVALID_DYNAMIC_OPTIONS
42KD0Ambiguous name reference.
AMBIGUOUS_ALIAS_IN_NESTED_CTE
42KD1Operation not supported in READ ONLY session mode.
OP_NOT_SUPPORTED_READ_ONLY
42KD2The source and target table names of a SYNC operaton must be the same.
SYNC_SRC_TARGET_TBL_NOT_SAME
42KD3A 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
42KD4Operation 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
42KD5Cannot create file or path.
DELTA_CANNOT_CREATE_LOG_PATH, PARTITION_LOCATION_IS_NOT_UNDER_TABLE_DIRECTORY
42KD6No partition information found.
DELTA_CONVERSION_NO_PARTITION_FOUND, DELTA_MISSING_PARTITION_COLUMN, DELTA_MISSING_PART_FILES
42KD7Table 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
42KD8Column position out of range.
DELTA_DROP_COLUMN_AT_INDEX_LESS_THAN_ZERO, DELTA_INDEX_LARGER_OR_EQUAL_THAN_STRUCT, DELTA_INDEX_LARGER_THAN_STRUCT
42KD9Cannot infer table schema.
CANNOT_MERGE_SCHEMAS, COPY_INTO_SOURCE_SCHEMA_INFERENCE_FAILED, DELTA_FAILED_INFER_SCHEMA, UNABLE_TO_INFER_SCHEMA
42KDAFailed to merge file into table schema.
DELTA_FAILED_MERGE_SCHEMA_FILE
42KDBInvalid URL
DATA_SOURCE_URL_NOT_ALLOWED
42KDCArchived file reference.
DELTA_ARCHIVED_FILES_IN_LIMIT, DELTA_ARCHIVED_FILES_IN_SCAN
42KDDUnsupported operation in streaming view.
UNEXPECTED_OPERATOR_IN_STREAMING_VIEW
42KDEUnsupported 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, STREAMING_OUTPUT_MODE
42KDFA required routine parameter is missing an argument.
KINESIS_SOURCE_MUST_BE_IN_EFO_MODE_TO_CONFIGURE_CONSUMERS, KINESIS_SOURCE_MUST_SPECIFY_REGISTERED_CONSUMER_ID_AND_TYPE, KINESIS_SOURCE_MUST_SPECIFY_STREAM_NAMES_OR_ARNS, KINESIS_SOURCE_NO_CONSUMER_OPTIONS_WITH_REGISTERED_CONSUMERS, MISSING_PARAMETER_FOR_KAFKA, MISSING_PARAMETER_FOR_ROUTINE, XML_ROW_TAG_MISSING
42KDGThe target schema is not compatible with the ingested data.
COPY_INTO_SCHEMA_MISMATCH_WITH_TARGET_TABLE
42P01undefined table
DELTA_CANNOT_REPLACE_MISSING_TABLE, DELTA_COMMIT_INTERMEDIATE_REDIRECT_STATE, DELTA_MISSING_DELTA_TABLE, DELTA_MISSING_DELTA_TABLE_COPY_INTO, DELTA_NO_REDIRECT_RULES_VIOLATED, DELTA_NO_RELATION_TABLE, DELTA_TABLE_NOT_FOUND, TABLE_OR_VIEW_NOT_FOUND, TABLE_WITH_ID_NOT_FOUND, VIEW_NOT_FOUND
42P02undefined parameter
UNBOUND_SQL_PARAMETER
42P06duplicate schema
SCHEMA_ALREADY_EXISTS
42P07duplicate table
DELTA_TABLE_ALREADY_EXISTS, TABLE_OR_VIEW_ALREADY_EXISTS, TEMP_TABLE_OR_VIEW_ALREADY_EXISTS, VIEW_ALREADY_EXISTS
42P08ambiguous parameter
CATALOG_NOT_FOUND
42P10invalid column reference
CLUSTERING_COLUMNS_MISMATCH, 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
42P18indeterminate datatype
DELTA_NULL_SCHEMA_IN_STREAMING_WRITE
42P20windowing error
MISSING_WINDOW_SPECIFICATION, UNSUPPORTED_EXPR_FOR_WINDOW
42P21collation mismatch
COLLATION_MISMATCH
42P22indeterminate collation
INDETERMINATE_COLLATION, INDETERMINATE_COLLATION_IN_EXPRESSION, INDETERMINATE_COLLATION_IN_SCHEMA
42S22Column not found
NO_SQL_TYPE_IN_PROTOBUF_SCHEMA
42S23Partition transform expression not in ‘partitionedBy’
PARTITION_TRANSFORM_EXPRESSION_NOT_IN_PARTITIONED_BY

Class 44: with check option violation

SQLSTATEDescription and issuing error classes
44000with check option violation
DELTA_REPLACE_WHERE_MISMATCH

Class 46: Java DDL 1

SQLSTATEDescription and issuing error classes
46103unresolved class name
CANNOT_LOAD_FUNCTION_CLASS
46110unsupported feature
CANNOT_MODIFY_CONFIG
46121invalid column name
INVALID_COLUMN_NAME_AS_PATH, INVALID_JAVA_IDENTIFIER_AS_FIELD_NAME

Class 51: Invalid Application State

SQLSTATEDescription and issuing error classes
51000Invalid Application State
KINESIS_EFO_CONSUMER_NOT_FOUND, KINESIS_EFO_SUBSCRIBE_LIMIT_EXCEEDED
51024An object cannot be used, because it has been marked inoperative.
INCOMPATIBLE_VIEW_SCHEMA_CHANGE

Class 53: insufficient resources

SQLSTATEDescription and issuing error classes
53000insufficient resources
CONCURRENT_SCHEDULER_INSUFFICIENT_SLOT
53200out of memory
EXECUTOR_BROADCAST_JOIN_OOM, EXECUTOR_BROADCAST_JOIN_STORE_OOM, UNABLE_TO_ACQUIRE_MEMORY

Class 54: program limit exceeded

SQLSTATEDescription and issuing error classes
54000program limit exceeded
COLLECTION_SIZE_LIMIT_EXCEEDED, DELTA_CLUSTER_BY_INVALID_NUM_COLUMNS, DELTA_SHARING_MAXIMUM_RECIPIENT_TOKENS_EXCEEDED, GROUPING_SIZE_LIMIT_EXCEEDED, INSTANCE_POOL_CAPACITY_EXCEEDED, PHOTON_DESERIALIZED_PROTOBUF_MEMORY_LIMIT_EXCEEDED, PHOTON_SERIALIZED_PROTOBUF_MEMORY_LIMIT_EXCEEDED, PIPELINE_TYPE_QUOTA_EXCEEDED, RELATION_LARGER_THAN_8G, WORKSPACE_QUOTA_EXCEEDED
54001The statement is too long or too complex.
FAILED_TO_PARSE_TOO_COMPLEX
54006The result string is too long.
EXCEED_LIMIT_LENGTH, KRYO_BUFFER_OVERFLOW
54023too many arguments
TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS
54K00Maximum depth of nested views was exceeded.
VIEW_EXCEED_MAX_NESTED_DEPTH
54KD0Maximum UDF count in query plan exceeded.
UDF_LIMITS, UDF_MAX_COUNT_EXCEEDED
54KD1Maximum object count in session exceeded.
MAX_NUMBER_VARIABLES_IN_SESSION_EXCEEDED

Class 55: object not in prerequisite state

SQLSTATEDescription and issuing error classes
55000object not in prerequisite state
DELTA_CANNOT_VACUUM_LITE, DELTA_FEATURE_CAN_ONLY_DROP_CHECKPOINT_PROTECTION_WITH_HISTORY_TRUNCATION, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_NOT_IN_NEW_ARCHITECTURE, MOVE_TABLE_BETWEEN_PIPELINES_DESTINATION_PIPELINE_TYPE_NOT_WORKSPACE, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_NOT_IN_NEW_ARCHITECTURE, MOVE_TABLE_BETWEEN_PIPELINES_SOURCE_PIPELINE_TYPE_NOT_WORKSPACE, MOVE_TABLE_BETWEEN_PIPELINES_UPDATE_IS_RUNNING
55019The object is in an invalid state for the operation.
CANNOT_QUERY_TABLE_DURING_INITIALIZATION, COPY_INTO_STATE_INTERNAL_ERROR, 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

SQLSTATEDescription and issuing error classes
56000Miscellaneous SQL or Product Error
CHECKPOINT_RDD_BLOCK_ID_NOT_FOUND
56038The requested feature is not supported in this environment.
AI_FUNCTION_UNSUPPORTED_ERROR, ANSI_CONFIG_CANNOT_BE_DISABLED, CF_MANAGED_FILE_EVENTS_ONLY_ON_SERVERLESS, CLUSTER_BY_AUTO_REQUIRES_CLUSTERING_FEATURE_ENABLED, CLUSTER_BY_AUTO_REQUIRES_PREDICTIVE_OPTIMIZATION, CLUSTER_BY_AUTO_UNSUPPORTED_TABLE_TYPE_ERROR, CLUSTER_CREATION_TRIAL_EXPIRED, 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_ENABLED, FEATURE_NOT_ON_CLASSIC_WAREHOUSE, FEATURE_UNAVAILABLE, GET_TABLES_BY_TYPE_UNSUPPORTED_BY_HIVE_VERSION, INCOMPATIBLE_DATASOURCE_REGISTER, MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED, METRIC_STORE_UNSUPPORTED_ERROR, NATIVE_XML_DATA_SOURCE_NOT_ENABLED, NO_WORKER_ENVIRONMENTS, STREAMING_TABLE_NOT_SUPPORTED, UC_HIVE_METASTORE_FEDERATION_CROSS_CATALOG_VIEW_NOT_SUPPORTED, UC_LAKEHOUSE_FEDERATION_WRITES_NOT_ALLOWED, UC_NOT_ENABLED, UC_QUERY_FEDERATION_NOT_ENABLED, UC_SERVICE_CREDENTIALS_NOT_ENABLED, UC_VOLUMES_NOT_ENABLED, UC_VOLUMES_SHARING_NOT_ENABLED, UNSUPPORTED_TIMESERIES_COLUMNS
56098An error occurred during implicit rebind, recompile, or revalidation.
UC_INVALID_DEPENDENCIES
56K00Spark Connect error
CONNECT, CONNECT_SESSION_MIGRATION

Class 57: operator intervention

SQLSTATEDescription and issuing error classes
57000operator intervention
CLUSTER_CREATION_CREDITS_EXHAUSTED
57012A 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
57KD0Query execution timeout
QUERY_EXECUTION_TIMEOUT_EXCEEDED

Class 58: System error

SQLSTATEDescription and issuing error classes
58000System error
CLOUD_PROVIDER_ERROR, CLUSTER_LAUNCH_CLOUD_FAILURE
58030I/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

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

Class F0: configuration file error

SQLSTATEDescription and issuing error classes
F0000configuration 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

SQLSTATEDescription and issuing error classes
HV000FDW-specific condition
FAILED_JDBC
HV091invalid descriptor field identifier
NONEXISTENT_FIELD_NAME_IN_LIST

Class HY: CLI-specific condition

SQLSTATEDescription and issuing error classes
HY000CLI-specific condition
INVALID_HANDLE, MISSING_TIMEOUT_CONFIGURATION
HY008operation canceled
AQE_THREAD_INTERRUPTED, OPERATION_CANCELED, SPARK_JOB_CANCELLED
HY109invalid cursor position
INVALID_CURSOR

Class KD: datasource specific errors

SQLSTATEDescription and issuing error classes
KD000datasource specific errors
API_QUOTA_EXCEEDED, DC_API_QUOTA_EXCEEDED, DC_CONNECTION_ERROR, DC_DYNAMICS_API_ERROR, DC_NETSUITE_ERROR, DC_SERVICENOW_API_ERROR, DC_SFDC_BULK_QUERY_JOB_INCOMPLETE, DC_SHAREPOINT_API_ERROR, DC_SOURCE_API_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, SAAS_CONNECTION_ERROR, SAAS_CONNECTOR_SOURCE_API_ERROR, SERVICENOW_CONNECTOR_INSTANCE_HIBERNATION_ERROR, SERVICENOW_CONNECTOR_INVALID_TABLE_ERROR, SERVICENOW_CONNECTOR_MALFORMED_ENDPOINT_URL_ERROR, SERVICENOW_CONNECTOR_UNAUTHORIZED_ACCESS_ERROR, SFDC_CONNECTOR_BULK_QUERY_JOB_INCOMPLETE, SFDC_CONNECTOR_CREATE_BULK_QUERY_JOB_FAILED
KD001Cannot read file footer
DELTA_FAILED_READ_FILE_FOOTER, FAILED_READ_FILE
KD002Unexpected 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
KD003Incorrect 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
KD004Delta protocol version error
DELTA_INVALID_PROTOCOL_DOWNGRADE, DELTA_INVALID_PROTOCOL_VERSION, DELTA_MISSING_COMMIT_INFO, DELTA_MISSING_COMMIT_TIMESTAMP, DELTA_READ_FEATURE_PROTOCOL_REQUIRES_WRITE, DELTA_UNSUPPORTED_COLUMN_MAPPING_PROTOCOL
KD005Table must include at least one non partition column
ALL_PARTITION_COLUMNS_NOT_ALLOWED, DELTA_NON_PARTITION_COLUMN_ABSENT
KD006No 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
KD007Table 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
KD008Table signature not set
DELTA_SCHEMA_NOT_SET
KD009Partitions do not match
CONFLICTING_DIRECTORY_STRUCTURES, CONFLICTING_PARTITION_COLUMN_NAMES, DELTA_UNEXPECTED_NUM_PARTITION_COLUMNS_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_COLUMN_FROM_FILE_NAME, DELTA_UNEXPECTED_PARTITION_SCHEMA_FROM_USER, PARTITION_NUMBER_MISMATCH
KD00AUnexpected partial scan
DELTA_UNEXPECTED_PARTIAL_SCAN
KD00BUnrecognised file
DELTA_UNRECOGNIZED_LOGFILE, ERROR_READING_AVRO_UNKNOWN_FINGERPRINT
KD00CVersioning not contiguous
DELTA_VERSIONS_NOT_CONTIGUOUS
KD00DStats required
DELTA_ZORDERING_ON_COLUMN_WITHOUT_STATS
KD00Etable feature validation failure
DELTA_ICEBERG_COMPAT_VIOLATION, DELTA_UNIFORM_ICEBERG_INGRESS_VIOLATION, DELTA_UNIVERSAL_FORMAT_CONVERSION_FAILED, DELTA_UNIVERSAL_FORMAT_VIOLATION
KD00Fcloud request error
HDFS_HTTP_ERROR, NATIVE_IO_ERROR
KD010external data source failure
DATA_SOURCE_EXTERNAL_ERROR
KDL01cluster launch error
CLUSTER_LAUNCH_CLIENT_ERROR, CLUSTER_SETUP_CLIENT_ERROR

Class P0: procedural logic error

SQLSTATEDescription and issuing error classes
P0001raise exception
USER_RAISED_EXCEPTION, USER_RAISED_EXCEPTION_PARAMETER_MISMATCH, USER_RAISED_EXCEPTION_UNKNOWN_ERROR_CLASS