Good Morning,
What I am trying to accomplish is to have a Cloudwatch rule that is scheduled to run daily that will go into an Athena database and create a new partition in several tables for that day using a constant target input. It is for a single database with several different tables and different s3 locations. Is it possible to set up the input using nested json and if so is this proper format--
{
"albPathFragment": "/AWSLogs/409148389496/elasticloadbalancing/",
"database": "site-reliability",
{
"table": "ha_east_rest_osp_alb",
"location": "xxxx-elblogs/Alb-Logs",
"region": "us-east-1"
},
{
"table": "ha_west_rest_osp_alb"
"location": "xxxx-elblogs-uw2/Alb-Logs",
"region": "us-west-2"
}
}
TIA,
Bill