- Newest
- Most votes
- Most comments
Reading through the snowflake documentation, I am not sure how the data in snowflake (that is hosted in AWS) can be exposed via API gateway. Could you please share the documentation that mentioned how this can be done?
I am aware of using external functions that are hosted in AWS. Here is the reference: https://docs.snowflake.com/en/sql-reference/external-functions-creating-aws-ui.html. This rather talks about how to define an external function (similar to defining an UDF). The UDF is defined in Snowflake and uses Snowflake compute while the external function uses AWS compute/resources.
API Gateway cannot directly integrate with AWS-hosted Snowflake. When we select the "AWS Service" in integration Request of an API, only the services mentioned in the "AWS Service" dropdown list can be integrated directly with API gateway. So, a Lambda function would be needed between the API Gateway and Snowflake.
Relevant content
- asked 3 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 9 months ago
Hi there,
Thanks for your response. I'm looking here: https://docs.snowflake.com/en/sql-reference/sql/create-api-integration.html. Perhaps I did not word my question very clearly. I believe that just as one can have a solution with an API Gateway proxying to a Lambda function, which in turn could communicate with a backend service (ex: SQS), it is also very possible for the API Gateway to communicate directly with the SQS service via its API.
Now take the scenario above and replace the SQS service with AWS-hosted Snowflake. It should be possible for the API Gateway to communicate directly with Snowflake via API without the requirement of a lambda function between the API Gateway and Snowflake, correct? Or am I mistaken in this assumption? According to the capabilities of the API Gateway, it is able to expose all services' APIs directly, as well as http endpoints.
Thanks.