In the Lambda function, query the latest data catalog and security settings, automatically generate source code to build and deploy a new version of the external API’s schema and resolvers, and commit the code to AWS CodeCommit. Set up CodeCommit to automatically start a new CI/CD pipeline on AWS CodePipeline after any code commit. Use CodePipeline to build a new version of the API with AWS CodeBuild using the newly-generated source code, and use AWS CodeDeploy to deploy both the new AWS AppSync GraphQL API and the new Lambda query resolvers. Allow your GraphQL clients to securely invoke the external API over HTTPS with your chosen authentication mechanism. Active the AppSync server-side caching. Use the AppSync Lambda query resolvers to translate the GraphQL query into SQL queries supported by Amazon Athena. Run Athena jobs synchronously with the Athena-Express library, appropriately timing out and limiting the result se
