![]() Ryan also goes through how to submit an API request using POSTMAN as well as some useful tips and tricks. ![]() Now we go through what API endpoints to use as well as any additional fields that we should note when setting up the headers. Here we see how we can generate a JSON web token. Using SnowSQL, we learn how to easily verify the generated private key. Here we learn how to assign the public key to a Snowflake user by using the “ALTER USER” command. How to assign the Public Key to a Snowflake User: For an example of generating a JWT in Python, see the following: Setting up the Public Key for the User: Here we go through how to set up the public key which is based on the private key. You can check out the Snowflake Documentation about Key Pair Authentication here: It is more secure and more flexible than conventional password authentication. Key pair authentication is an alternative means of identifying yourself to a login server, instead of typing a password. We are going to use key pair authentication in this example. In this example, we will learn the following: Using Key Pair Authentication: Ryan also has recorded a quick video tutorial of this example which will be linked at the bottom of this post. If you’d like to read the Snowflake documents before beginning, we’ve listed the links below. Here we can really see how easy it is to call a stored procedure using the SQL API instead of traditional methods. Now, let’s move on to an example! In this example, Ryan takes us through how we would call a stored procedure. ![]() Statements with the Snowflake SQL GET command Example of the Snowflake SQL API.Statements with the Snowflake SQL PUT command.Requests are supported only from a single thread.Īlso note the following statements which are not supported:.The service does not currently support fetching results concurrently (i.e.The maximum number of rows returned in a page of results is 10,000.The maximum size of a page of results is approximately 10 MB.The SQL API has the following limitations: Unfortunately, there are some limitations and points to note when using the SQL API. You can also use this API to execute standard queries and most DDL and DML statements. Check the status of the execution of a statement.In addition to this, the Snowflake SQL API provides operations that you can use to do the following: You can use this API to develop custom applications and integrations that can perform simple queries or manage your deployment (such as provisioning users and roles, creating tables, etc.) The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database. There is also a tutorial and video to get you started! What is the Snowflake SQL API? In this post, our CTO goes through how he uses this new feature quite easily. So, if you’re looking to use Snowflake SQL API, look no further. The SQL API is all about reducing complexity and administration overheads which is a much needed feature for the data warehouse space. The Snowflake SQL API makes it possible for custom-built and third-party applications to call Snowflake’s Data Cloud through a REST application programming interface without the need for client-side drivers. Recently, cloud warehouse giant, Snowflake launched the Snowflake SQL API and we were very excited to try out this new addition!
0 Comments
Leave a Reply. |