AppSync with DynamoDB (GraphQL) - Step-by-Step Execution

Concept Flow - AppSync with DynamoDB (GraphQL)

Client sends GraphQL request

↓

AppSync receives request

↓

AppSync parses GraphQL query/mutation

↓

AppSync maps GraphQL to DynamoDB operation

↓

DynamoDB executes operation

↓

DynamoDB returns data

↓

AppSync formats response

↓

Client receives GraphQL response

The client sends a GraphQL request to AppSync, which translates it into DynamoDB operations, executes them, and returns the results back to the client.

Execution Sample

DynamoDB

query GetBook {
  getBook(id: "123") {
    id
    title
    author
  }
}

This GraphQL query asks AppSync to get a book with id '123' from DynamoDB and return its id, title, and author.

Execution Table

Step	Action	GraphQL Operation	DynamoDB Operation	Result/Output
1	Client sends GraphQL query	query getBook(id: "123")	N/A	Request sent to AppSync
2	AppSync parses query	Extract getBook with id=123	N/A	Parsed query ready
3	AppSync maps to DynamoDB	getBook -> GetItem	GetItem with Key {"id": "123"}	DynamoDB request prepared
4	DynamoDB executes GetItem	N/A	GetItem returns item {"id": "123", "title": "My Book", "author": "Alice"}	Item retrieved
5	AppSync formats response	N/A	N/A	Response formatted as GraphQL data
6	Client receives response	GraphQL data with book details	N/A	{"data": {"getBook": {"id": "123", "title": "My Book", "author": "Alice"}}}
7	Execution ends	N/A	N/A	Query completed successfully

💡 Query completes after DynamoDB returns the item and AppSync sends the formatted response to the client.

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	After Step 5	Final
GraphQL Query	query GetBook { getBook(id: "123") { id title author } }	Parsed getBook with id=123	Mapped to DynamoDB GetItem	DynamoDB returns item	Response formatted	Response sent to client
DynamoDB Request	N/A	N/A	GetItem with Key {"id": "123"}	Executing GetItem	N/A	Completed
DynamoDB Response	N/A	N/A	N/A	Item {"id": "123", "title": "My Book", "author": "Alice"}	N/A	Used in response

Key Moments - 3 Insights

Why does AppSync need to parse the GraphQL query before accessing DynamoDB?

AppSync parses the GraphQL query (see Step 2 in execution_table) to understand what data the client wants, so it can translate it into the correct DynamoDB operation.

What happens if DynamoDB does not find the item with the given key?

If DynamoDB returns no item at Step 4, AppSync will format a response with null data for that query field, indicating the item was not found.

How does AppSync format the DynamoDB response back into GraphQL?

At Step 5, AppSync takes the raw DynamoDB item and wraps it into the GraphQL response structure expected by the client, matching the requested fields.

Visual Quiz - 3 Questions

Look at the execution_table, what DynamoDB operation does AppSync map the getBook GraphQL query to?

A UpdateItem

B PutItem

C GetItem

D DeleteItem

💡 Hint

Check Step 3 in the execution_table where the mapping happens.

At which step does DynamoDB return the requested item?

A Step 2

B Step 4

C Step 3

D Step 5

💡 Hint

Look for the step where DynamoDB executes GetItem and returns data.

If the client requested an additional field 'publishedYear', where would this affect the execution flow?

A Step 2 and Step 5

B Step 1 only

C Step 4 only

D Step 3 only

💡 Hint

Consider parsing the query and formatting the response steps.

Concept Snapshot

AppSync receives GraphQL requests and translates them into DynamoDB operations.
It parses the query, maps it to DynamoDB GetItem/PutItem/etc., executes it, then formats the response.
This allows clients to use GraphQL to interact with DynamoDB data easily.
AppSync handles the translation and response formatting automatically.
DynamoDB operations depend on the GraphQL query type (query, mutation).

Full Transcript

This visual execution shows how AppSync works with DynamoDB using GraphQL. The client sends a GraphQL query to AppSync. AppSync parses the query to understand what data is requested. It then maps the GraphQL query to a DynamoDB operation, such as GetItem for fetching data. DynamoDB executes the operation and returns the data. AppSync formats this data into the GraphQL response structure and sends it back to the client. The process ends when the client receives the response. Key moments include understanding why parsing is needed, what happens if data is missing, and how responses are formatted. The quiz tests knowledge of these steps and their order.