Edward Q. Bridges ebridges

Prompt: Implement Event-Driven ECS Fargate Trigger from S3 Upload

🎯 Goal

Build an AWS infrastructure pattern using Terraform and Python that executes a containerized Python ingestion script in ECS Fargate whenever a new file is uploaded to an S3 bucket. The ingestion script processes a CSV file and writes to a database.

🔧 Implementation Summary

S3 Upload → EventBridge

Enable S3 event notifications via EventBridge when new .csv files are uploaded to a specific bucket and prefix.

Python language features

Standard control structures

Conditional statements

if statement

if condition:
	# code to execute if condition is true

if-else statement

Priorities

First

TASK FROM "work/aetion"
WHERE contains(tags, "#todo/11") and !completed
GROUP BY file.link
SORT file.ctime DESC

Topic

Agenda

<% tp.file.cursor() %>

Attendees

creation date
<% tp.file.creation_date() %>

← [[<% tp.date.now('YYYY-MM-DD-ddd', -1) %>]] | [[<% tp.date.now('YYYY-MM-DD-ddd', 1) %>]] →

<% tp.date.now('YYYY-MM-DD-ddd') %>

	"""
	Bedrock Knowledge Base Ingestion Agent

	This agent syncs building code data from the PostgreSQL database to AWS Bedrock Knowledge Base (YSASCPLSVW).
	It handles metadata transformation, content formatting, and maintains consistency between systems.
	"""

	import json
	import logging
	import boto3

	variable assessment_bucket_name {
	description = "Name of technical assessment"
	type = string
	default = "sre-interview"
	}

	locals {
	bucket_name = format("${var.assessment_bucket_name}")
	}

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Read CSV file with JS</title>
	</head>

	<body>
	<script src="https://cdn.jsdelivr.net/npm/[email protected]/papaparse.min.js"></script>

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>QR Code Generator</title>
	</head>
	<body style="font-family: Arial, sans-serif; text-align: center; margin: 50px;">
	<h1>QR Code Generator</h1>
	<form id="qrForm">

	venv
	cohort-cases