Hi,
I don't have much expertise with EventBridge + Glue Workflow.
I do have an AWS DMS configured to migrate our database to a S3 Bucket, I want to perform ETL on the landed data.
I can enable the Event Notification to notify whenever a file is written on the bucket, and create EventBridge rules to filter by the S3 Key.
Is it possible to multiples EventBridge rules trigger the same Glue workflow passing different parameters? Or I should have one event bridge and glue workflow for each table ?
e.g.
1st Approach
/database/table1/file1.csv -> EventBridge Rule 1 -> Glue Workflow 1
/database/table2/file2.csv -> EventBridge Rule 2 -> Glue Workflow 2
vs
2nd Approach, different events share the same glue workflow but passing different parameters.
/database/table1/file1.csv -> EventBridge Rule 1 -> Glue Workflow
/database/table2/file2.csv -> EventBridge Rule 2 -> Glue Workflow
The glue job will perform deduplication and will do the upsert on a S3 bucket using the Apache Iceberg.