dynobase-icon
Dynobase

Reserved Keywords in DynamoDB [The Complete List]

Written by Rafal Wilinski

When you’re performing DynamoDB queries or scans, there are certain reserved keywords (a total of 573) you’re not allowed to use as attribute names in expressions and this article covers the entire list of those reserved words.

Before we get to the list, a quick note: what if you DO want to use one of the words below in your query expression? If you do as normal, it would result in the following error: ValidationException: Invalid KeyConditionExpression: Attribute name is a reserved keyword; (click on the error link to learn the workaround solution)

With all of the above being said, here's the complete list of DynamoDB reserved words:

  • ABORT
  • ABSOLUTE
  • ACTION
  • ADD
  • AFTER
  • AGENT
  • AGGREGATE
  • ALL
  • ALLOCATE
  • ALTER
  • ANALYZE
  • AND
  • ANY
  • ARCHIVE
  • ARE
  • ARRAY
  • AS
  • ASC
  • ASCII
  • ASENSITIVE
  • ASSERTION
  • ASYMMETRIC
  • AT
  • ATOMIC
  • ATTACH
  • ATTRIBUTE
  • AUTH
  • AUTHORIZATION
  • AUTHORIZE
  • AUTO
  • AVG
  • BACK
  • BACKUP
  • BASE
  • BATCH
  • BEFORE
  • BEGIN
  • BETWEEN
  • BIGINT
  • BINARY
  • BIT
  • BLOB
  • BLOCK
  • BOOLEAN
  • BOTH
  • BREADTH
  • BUCKET
  • BULK
  • BY
  • BYTE
  • CALL
  • CALLED
  • CALLING
  • CAPACITY
  • CASCADE
  • CASCADED
  • CASE
  • CAST
  • CATALOG
  • CHAR
  • CHARACTER
  • CHECK
  • CLASS
  • CLOB
  • CLOSE
  • CLUSTER
  • CLUSTERED
  • CLUSTERING
  • CLUSTERS
  • COALESCE
  • COLLATE
  • COLLATION
  • COLLECTION
  • COLUMN
  • COLUMNS
  • COMBINE
  • COMMENT
  • COMMIT
  • COMPACT
  • COMPILE
  • COMPRESS
  • CONDITION
  • CONFLICT
  • CONNECT
  • CONNECTION
  • CONSISTENCY
  • CONSISTENT
  • CONSTRAINT
  • CONSTRAINTS
  • CONSTRUCTOR
  • CONSUMED
  • CONTINUE
  • CONVERT
  • COPY
  • CORRESPONDING
  • COUNT
  • COUNTER
  • CREATE
  • CROSS
  • CUBE
  • CURRENT
  • CURSOR
  • CYCLE
  • DATA
  • DATABASE
  • DATE
  • DATETIME
  • DAY
  • DEALLOCATE
  • DEC
  • DECIMAL
  • DECLARE
  • DEFAULT
  • DEFERRABLE
  • DEFERRED
  • DEFINE
  • DEFINED
  • DEFINITION
  • DELETE
  • DELIMITED
  • DEPTH
  • DEREF
  • DESC
  • DESCRIBE
  • DESCRIPTOR
  • DETACH
  • DETERMINISTIC
  • DIAGNOSTICS
  • DIRECTORIES
  • DISABLE
  • DISCONNECT
  • DISTINCT
  • DISTRIBUTE
  • DO
  • DOMAIN
  • DOUBLE
  • DROP
  • DUMP
  • DURATION
  • DYNAMIC
  • EACH
  • ELEMENT
  • ELSE
  • ELSEIF
  • EMPTY
  • ENABLE
  • END
  • EQUAL
  • EQUALS
  • ERROR
  • ESCAPE
  • ESCAPED
  • EVAL
  • EVALUATE
  • EXCEEDED
  • EXCEPT
  • EXCEPTION
  • EXCEPTIONS
  • EXCLUSIVE
  • EXEC
  • EXECUTE
  • EXISTS
  • EXIT
  • EXPLAIN
  • EXPLODE
  • EXPORT
  • EXPRESSION
  • EXTENDED
  • EXTERNAL
  • EXTRACT
  • FAIL
  • FALSE
  • FAMILY
  • FETCH
  • FIELDS
  • FILE
  • FILTER
  • FILTERING
  • FINAL
  • FINISH
  • FIRST
  • FIXED
  • FLATTERN
  • FLOAT
  • FOR
  • FORCE
  • FOREIGN
  • FORMAT
  • FORWARD
  • FOUND
  • FREE
  • FROM
  • FULL
  • FUNCTION
  • FUNCTIONS
  • GENERAL
  • GENERATE
  • GET
  • GLOB
  • GLOBAL
  • GO
  • GOTO
  • GRANT
  • GREATER
  • GROUP
  • GROUPING
  • HANDLER
  • HASH
  • HAVE
  • HAVING
  • HEAP
  • HIDDEN
  • HOLD
  • HOUR
  • IDENTIFIED
  • IDENTITY
  • IF
  • IGNORE
  • IMMEDIATE
  • IMPORT
  • IN
  • INCLUDING
  • INCLUSIVE
  • INCREMENT
  • INCREMENTAL
  • INDEX
  • INDEXED
  • INDEXES
  • INDICATOR
  • INFINITE
  • INITIALLY
  • INLINE
  • INNER
  • INNTER
  • INOUT
  • INPUT
  • INSENSITIVE
  • INSERT
  • INSTEAD
  • INT
  • INTEGER
  • INTERSECT
  • INTERVAL
  • INTO
  • INVALIDATE
  • IS
  • ISOLATION
  • ITEM
  • ITEMS
  • ITERATE
  • JOIN
  • KEY
  • KEYS
  • LAG
  • LANGUAGE
  • LARGE
  • LAST
  • LATERAL
  • LEAD
  • LEADING
  • LEAVE
  • LEFT
  • LENGTH
  • LESS
  • LEVEL
  • LIKE
  • LIMIT
  • LIMITED
  • LINES
  • LIST
  • LOAD
  • LOCAL
  • LOCALTIME
  • LOCALTIMESTAMP
  • LOCATION
  • LOCATOR
  • LOCK
  • LOCKS
  • LOG
  • LOGED
  • LONG
  • LOOP
  • LOWER
  • MAP
  • MATCH
  • MATERIALIZED
  • MAX
  • MAXLEN
  • MEMBER
  • MERGE
  • METHOD
  • METRICS
  • MIN
  • MINUS
  • MINUTE
  • MISSING
  • MOD
  • MODE
  • MODIFIES
  • MODIFY
  • MODULE
  • MONTH
  • MULTI
  • MULTISET
  • NAME
  • NAMES
  • NATIONAL
  • NATURAL
  • NCHAR
  • NCLOB
  • NEW
  • NEXT
  • NO
  • NONE
  • NOT
  • NULL
  • NULLIF
  • NUMBER
  • NUMERIC
  • OBJECT
  • OF
  • OFFLINE
  • OFFSET
  • OLD
  • ON
  • ONLINE
  • ONLY
  • OPAQUE
  • OPEN
  • OPERATOR
  • OPTION
  • OR
  • ORDER
  • ORDINALITY
  • OTHER
  • OTHERS
  • OUT
  • OUTER
  • OUTPUT
  • OVER
  • OVERLAPS
  • OVERRIDE
  • OWNER
  • PAD
  • PARALLEL
  • PARAMETER
  • PARAMETERS
  • PARTIAL
  • PARTITION
  • PARTITIONED
  • PARTITIONS
  • PATH
  • PERCENT
  • PERCENTILE
  • PERMISSION
  • PERMISSIONS
  • PIPE
  • PIPELINED
  • PLAN
  • POOL
  • POSITION
  • PRECISION
  • PREPARE
  • PRESERVE
  • PRIMARY
  • PRIOR
  • PRIVATE
  • PRIVILEGES
  • PROCEDURE
  • PROCESSED
  • PROJECT
  • PROJECTION
  • PROPERTY
  • PROVISIONING
  • PUBLIC
  • PUT
  • QUERY
  • QUIT
  • QUORUM
  • RAISE
  • RANDOM
  • RANGE
  • RANK
  • RAW
  • READ
  • READS
  • REAL
  • REBUILD
  • RECORD
  • RECURSIVE
  • REDUCE
  • REF
  • REFERENCE
  • REFERENCES
  • REFERENCING
  • REGEXP
  • REGION
  • REINDEX
  • RELATIVE
  • RELEASE
  • REMAINDER
  • RENAME
  • REPEAT
  • REPLACE
  • REQUEST
  • RESET
  • RESIGNAL
  • RESOURCE
  • RESPONSE
  • RESTORE
  • RESTRICT
  • RESULT
  • RETURN
  • RETURNING
  • RETURNS
  • REVERSE
  • REVOKE
  • RIGHT
  • ROLE
  • ROLES
  • ROLLBACK
  • ROLLUP
  • ROUTINE
  • ROW
  • ROWS
  • RULE
  • RULES
  • SAMPLE
  • SATISFIES
  • SAVE
  • SAVEPOINT
  • SCAN
  • SCHEMA
  • SCOPE
  • SCROLL
  • SEARCH
  • SECOND
  • SECTION
  • SEGMENT
  • SEGMENTS
  • SELECT
  • SELF
  • SEMI
  • SENSITIVE
  • SEPARATE
  • SEQUENCE
  • SERIALIZABLE
  • SESSION
  • SET
  • SETS
  • SHARD
  • SHARE
  • SHARED
  • SHORT
  • SHOW
  • SIGNAL
  • SIMILAR
  • SIZE
  • SKEWED
  • SMALLINT
  • SNAPSHOT
  • SOME
  • SOURCE
  • SPACE
  • SPACES
  • SPARSE
  • SPECIFIC
  • SPECIFICTYPE
  • SPLIT
  • SQL
  • SQLCODE
  • SQLERROR
  • SQLEXCEPTION
  • SQLSTATE
  • SQLWARNING
  • START
  • STATE
  • STATIC
  • STATUS
  • STORAGE
  • STORE
  • STORED
  • STREAM
  • STRING
  • STRUCT
  • STYLE
  • SUB
  • SUBMULTISET
  • SUBPARTITION
  • SUBSTRING
  • SUBTYPE
  • SUM
  • SUPER
  • SYMMETRIC
  • SYNONYM
  • SYSTEM
  • TABLE
  • TABLESAMPLE
  • TEMP
  • TEMPORARY
  • TERMINATED
  • TEXT
  • THAN
  • THEN
  • THROUGHPUT
  • TIME
  • TIMESTAMP
  • TIMEZONE
  • TINYINT
  • TO
  • TOKEN
  • TOTAL
  • TOUCH
  • TRAILING
  • TRANSACTION
  • TRANSFORM
  • TRANSLATE
  • TRANSLATION
  • TREAT
  • TRIGGER
  • TRIM
  • TRUE
  • TRUNCATE
  • TTL
  • TUPLE
  • TYPE
  • UNDER
  • UNDO
  • UNION
  • UNIQUE
  • UNIT
  • UNKNOWN
  • UNLOGGED
  • UNNEST
  • UNPROCESSED
  • UNSIGNED
  • UNTIL
  • UPDATE
  • UPPER
  • URL
  • USAGE
  • USE
  • USER
  • USERS
  • USING
  • UUID
  • VACUUM
  • VALUE
  • VALUED
  • VALUES
  • VARCHAR
  • VARIABLE
  • VARIANCE
  • VARINT
  • VARYING
  • VIEW
  • VIEWS
  • VIRTUAL
  • VOID
  • WAIT
  • WHEN
  • WHENEVER
  • WHERE
  • WHILE
  • WINDOW
  • WITH
  • WITHIN
  • WITHOUT
  • WORK
  • WRAPPED
  • WRITE
  • YEAR
  • ZONE

Product Features

© 2020 Dynobase