I´m want to use Glue to extract data from an RDS PostgresDB, transform/clean it and load into an S3 Bucket so I can use Athena and Quicksight to visualize the data and create reports.
I´m currently authoring the Glue job for the data cleanup (remove NULL values and such things). But I can see no easy way to preview the job script results. Running the job takes at least 10 minutes to start. Is this supposed to be the workflow here? Am I missing anything?
I´m new to the whole BI/data stuff. Maybe I´m following the wrong approach here. I want to visualize data from RDS in Quicksight and need to do some data cleanup first. Any other approaches that make sense for this scenario.