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

Dynobase is a Professional GUI Client for DynamoDB

Start your 7-day free trial today

Product Features

© 2020 Dynobase