Forum Discussion

AdithyaR's avatar
AdithyaR
New Contributor
2 years ago

Snowflake Integration using REST API

Hello, I am trying to pull data into OneStream from Snowflake using REST Api. Does anyone know how the entire process works and worked on it before .If anyone one can give a heads-up on this it wou...
Data Integration
franciscoamores's avatar
franciscoamores
Contributor II
12 months ago

Hi,

it's also important to understand how the SQL REST API works, implications and limitations. For example, you may get data in the response and status 200 (sync pattern) or request status url and status 202 (async pattern). In the second scenario you will have to check if the request is completed (that's another REST API call) and then retrieve data when completed (that's another REST API call)

The SF SQL REST API is very well documented:

https://docs.snowflake.com/en/developer-guide/sql-api/index

https://docs.snowflake.com/en/developer-guide/sql-api/submitting-requests

https://docs.snowflake.com/en/developer-guide/sql-api/handling-responses