I need to expose snowflake table data as an API. But snowflake doesn't provide REST API to achieve this.
How do I achieve this?
I need to expose snowflake table data as an API. But snowflake doesn't provide REST API to achieve this.
How do I achieve this?
You will need to implement something yourself. A common approach an application that RESTfully listens for queries over HTTP, uses the Snowflake JDBC driver to retrieve the data, then encodes it into JSON and responds. Here is a generic example: https://github.com/hellofiremind/jdbc-sql-rest