Build Snowflake AI Query Automation Agent

I want to have a 25 tables in snowflake under 3 different schemas with 10 in 1 schema another 10 in another schema and another 5 in 1 schema. I want have data in these 25 tables with 2 columns. Will provide additional details on the columns and how data should be.

I want to have a custom claude like custom gpt to execute the queries that I give using snowfalke. and it need to generate 3 sets of queries for each custom schema based on the tables list generated in the initially executed query. I will provide the details how the queries should be.

I want to have eks cluster to execute all this meaning connect to snowflake and run inital queries . Process the 3 sets of queries that were dynamically generated by custom claude and send it the snowflake and the output should be 3 excel sheets sent to the ms outlook ans as well as these should be sent to a location in the aws s3 bucket under a date folder.

For this I need to build an agent
technical stack:
python
claude
snowflake
aws eks