Buat tabel dengan Indeks Sekunder Global.
# Create a table with a GSI
aws dynamodb create-table \
--table-name MusicCollection \
--attribute-definitions \
AttributeName=Artist,AttributeType=S \
AttributeName=SongTitle,AttributeType=S \
AttributeName=AlbumTitle,AttributeType=S \
--key-schema \
AttributeName=Artist,KeyType=HASH \
AttributeName=SongTitle,KeyType=RANGE \
--billing-mode PAY_PER_REQUEST \
--global-secondary-indexes \
"IndexName=AlbumIndex,\
KeySchema=[{AttributeName=AlbumTitle,KeyType=HASH}],\
Projection={ProjectionType=ALL}"
Tambahkan GSI baru (sesuai permintaan) ke tabel yang ada.
# Add a new GSI to an existing table
aws dynamodb update-table \
--table-name MusicCollection \
--attribute-definitions \
AttributeName=Genre,AttributeType=S \
--global-secondary-index-updates \
"[{\"Create\":{\"IndexName\":\"GenreIndex\",\
\"KeySchema\":[{\"AttributeName\":\"Genre\",\"KeyType\":\"HASH\"}],\
\"Projection\":{\"ProjectionType\":\"ALL\"}}}]"
Perbarui (tingkatkan) throughput hangat GSI.
# Increase the warm throughput of a GSI (default values are 12k reads, 4k writes)
aws dynamodb update-table \
--table-name MusicCollection \
--global-secondary-index-updates \
"[{\"Update\":{\"IndexName\":\"AlbumIndex\",\
\"WarmThroughput\":{\"ReadUnitsPerSecond\":15000,\"WriteUnitsPerSecond\":6000}}}]"
Kueri data menggunakan GSI.
# Query the AlbumIndex GSI
aws dynamodb query \
--table-name MusicCollection \
--index-name AlbumIndex \
--key-condition-expression "AlbumTitle = :album" \
--expression-attribute-values '{":album":{"S":"Let It Be"}}'
# Query the GenreIndex GSI
aws dynamodb query \
--table-name MusicCollection \
--index-name GenreIndex \
--key-condition-expression "Genre = :genre" \
--expression-attribute-values '{":genre":{"S":"Jazz"}}'
Hapus GSI.
# Delete a GSI from a table
aws dynamodb update-table \
--table-name MusicCollection \
--global-secondary-index-updates \
"[{\"Delete\":{\"IndexName\":\"GenreIndex\"}}]"