Sounds very similar to what we're dealing with, although never turned to Glue to try and resolve our challenge. Ended up going with an ETL as a service (Alooma

Sounds very similar to what we're dealing with, although never turned to Glue to try and resolve our challenge. Ended up going with an ETL as a service (Alooma and now transitioning to ETLWorks) to extract and load our data into Snowflake.