Lab complete!
Now that you have completed this lab, make sure to update your Well-Architected review if you have implemented these changes in your workload.
Click here to access the Well-Architected Tool
The final step is to setup the sub account to automatically scan the S3 folders each morning using a Glue Crawler, and update a local Athena database.
1 - Login to the sub account as an IAM user with the required permissions, and go into the Glue console.
2 - Add a Crawler with the following details:
**.json, **.yml, **.sql, **.csv, **.gz, **.zip (1 per line)
3 - Create a new role for the crawler to use
4 - Create a daily schedule to update the tables each morning before you come into work
5 - Create a new database
6 - Review the crawler configuration and finish:
7 - Run the crawler, and check that it has added tables.
8 - Go into Athena and execute a preview query to verify access and the data.
You have now given the sub account access to their specific CUR files as extracted from the Management/Payer CUR file. This will be automatically updated on any new versions delivered, or any new months delivered.
Now that you have completed this lab, make sure to update your Well-Architected review if you have implemented these changes in your workload.
Click here to access the Well-Architected Tool