We are looking to implement AWS Glue Databrew for our analysts to have more control over datasets they want to create and then use. When testing, I have found that I can have the output go to Redshift and create a new table every time the job runs, but as you can imagine this will get messy. Is there a setting for Redshift output that will update an existing table in Redshift instead of creating a new one everytime?
When Redshift is the output option, there is no settings button to change from create new table to replace. When s3 is the output option, the settings button reappears. Settings pop-up that appears when you press the settings button that appears with s3.
