call AWS SES API from AWS API Gateway without AWS Lambda

To send production email through Amazon SES, you can use the Simple Mail Transfer Protocol (SMTP) interface or the Amazon SES API

You can call the API in the following ways:

• Make direct HTTPS requests—This is the most advanced method, because you have to manually handle authentication and signing of your requests, and then manually construct the requests.

• Use an AWS SDK—AWS SDKs make it easy to access the APIs for several AWS services, including Amazon SES. When you use an SDK, it takes care of authentication, request signing, retry logic, error handling, and other low-level functions so that you can focus on building applications , lambda perhaps is doing this for you.

• Use a command line interface—The AWS Command Line Interface is the command line tool for Amazon SES. We also offer the AWS Tools for Windows PowerShell for those who script in the PowerShell environment.

if you remove lambda you may want to see Make direct HTTPS requests and if API gateway integration with AWS services will work. A POC can be done to test out.

So, this is probabaly technically possible.

The API Gateway supports the AWS Service integration type which lets you directly integrate with other AWS services by invoking API actions.

This can be challenging since there are certain parameters (destination, source, message body, etc) that you need to ensure are correct and are transformed from whatever format Snowflake is using to what the API is expecting.

Is there any reason you are not wanting to use a Lambda? It would simplify this flow dramatically in my opinion.

References

• AWS API Gateway Docs - Set up an API integration request
• AWS API - SES SendEmail