Generating a CSV Report from a DynamoDB Table

Libraries: If you want this lab, consider one of these libraries.
Cloud
Data

Generating a CSV Report from a DynamoDB Table

In this lab, you will walk through the creation of a Lambda function that can read the first 1000 items from your DynamoDB table and export them as a CSV into your S3 bucket. You will have to grant your Lambda function the appropriate permissions to be able to access both the database and the S3 bucket. If you are not interested in learning about the code, you can copy the code from the GitHub repository provided and only complete the permissions part of the lab. You can find the Lambda code and the JSON permissions file in the **Additional Resources** section of the lab.

Get started Contact sales

Lab Info

Level

Intermediate

Last updated

Sep 22, 2025

Duration

1h 0m

Challenge

Copy Your S3 Bucket's Amazon Resource Name
- Navigate to the S3 service.
- Click on the S3 bucket created for the lab.
- Record the bucket's Amazon Resource Name (ARN).
Challenge

Create a Lambda Function That Reads 1000 Lines from Your DynamoDB Table and Exports Them to a CSV File in Your S3 Bucket
- Navigate to the Lambda service.
- Create a new function with a Python runtime (or the runtime of your choice).
- Write and deploy the code needed to scan 1000 items from your DynamoDB table.
Challenge

Give Your Lambda Function Permissions to Read from Your DynamoDB Table and Write to Your S3 Bucket
- From your Lambda function, navigate to the Configuration tab.
- From the Permissions view, create a new policy for the Lambda's execution role.
- Write a policy that grants your Lambda function Write access to your S3 bucket and Read access from your DynamoDB table.
- Attach this new permissions policy to your Lambda execution role.
Challenge

Test Your Lambda Function and Verify That the CSV File Is Created in Your S3 Bucket
- Navigate back to your Lambda function.
- From the Test tab, execute a test, which should now succeed.
- Navigate to your S3 bucket and verify the presence of the generated CSV file.
Challenge

Add Items to Your DynamoDB Table
- Navigate to the DynamoDB service.
- Navigate to the DynamoDB table created for this lab.
- From the Explore table items interface, add 3 or more items to your DynamoDB table to test the solution.

About the author

Pluralsight Skills

Pluralsight Skills gives leaders confidence they have the skills needed to execute technology strategy. Technology teams can benchmark expertise across roles, speed up release cycles and build reliable, secure products. By leveraging our expert content, skill assessments and one-of-a-kind analytics, keep up with the pace of change, put the right people on the right projects and boost productivity. It's the most effective path to developing tech skills at scale.

Real skill practice before real-world application

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Learn by doing

Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.

Follow your guide

All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.

Turn time into mastery

On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.