Looking to connect with other Matillion users who have used Python scripting to execute AWS Athena SQL instead of Redshift or Redshift/Spectrum).
Hello @R.Porter.TechnoMage
I hope you are well, I have just seen your post and wanted to share what we have seen users do in the past, this may help you achieve this.
Previously, users have achieved similar using the Database Query Component (Info here) alongside the Athena JDBC driver.
I hope you have been able to do this, would love to learn how you did!
Kind regards, Joe