🔥 Create an AWS Bedrock Agent to Query Athena Data
Learn how to build a powerful data querying system using AWS Bedrock Agent, Amazon Athena, and API Gateway. In this step-by-step tutorial, we'll create a solution that allows you to query your data using natural language!
What you'll learn:
✅ Set up S3 buckets and Athena workgroups using CloudFormation
✅ Create and configure tables in the Glue Data Catalog
✅ Deploy an API Gateway and Lambda function
✅ Build a Bedrock Agent to handle natural language queries
✅ Connect everything together for seamless data access
🛠 Prerequisites:
- AWS Account
- Basic understanding of AWS services
- Basic SQL knowledge
📚 Resources:
ℹ️ Full source code: https://github.com/johnny-chivers/AWS-Bedrock-Agent-Athena
SUPPORT THE CHANNEL:
☕ Buy Me A Coffee: https://www.buymeacoffee.com/johnnychivers
🖥️ My VPN: https://go.nordvpn.net/aff_c?offer_id=612&aff_id=74288&url_id=14830
▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
00:00 - Intro
00:31 - Download Code From GitHub
01:03 - What we are going to build
01:33 - What is Amazon Bedrock?
02:05 - What is Amazon Bedrock Agents?
02:37 - Prompt example
03:18 - Chain of through
03:28 - Word Of Warning
04:00 - Cost of Tutorial
04:25 - One Last time - download the GitHub
04:32 - Setup work
04:33 - Create S3 Bucket and Athena Workgroup
05:56 - Upload Objects to S3
07:49 - Create Tables in Athena
11:43 - Create APIs and Lambda Function
14:09 - How the Function Code Works
15:58 - Building A Amazon Bedrock Agent
18:13 - Action Group
19:41 - Prompting The Agent
20:30 - Chain Of Thought Reasoning
21:43 - Another Prompt
22:18 - Exploring Chain Of Thought
25:45 - Outro
OTHER USEFUL LINKS:
ℹ️ My Website: https://johnnychivers.co.uk
🔗 Linkedin: https://www.linkedin.com/in/johnny-chivers/
😎 About me
I have spent the last decade being immersed in the world of big data working as a consultant for some the globe's biggest companies.My journey into the world of data was not the most conventional. I started my career working as performance analyst in professional sport at the top level's of both rugby and football. I then transitioned into a career in data and computing. This journey culminated in the study of a Masters degree in Software.