Snowflake Snowpipe REST API
Snowpipe REST API lets users define a list of files to ingest into Snowflake and fetch reports of the load history by making REST API calls.
Concepts
Continuous Data Loading and Monitoring using Snowpipe
Learn how to load files from external storage using the Snowpipe and monitor the load status of the files in Snowflake.
Introduction to Snowflake Snowpipe on AWS
A step by step guide on automating continuous data loading into Snowflake through Snowpipe on AWS S3.
Execute multiple SQL statements in a single Snowflake API request
Learn how to submit an API request containing multiple statements to execute to the Snowflake SQL REST API using Postman.
Introduction to Snowflake SQL REST API using Postman
Snowflake SQL REST API allows users to interact with Snowflake through HTTP requests, making it easy to integrate with other systems.
HOW TO: Generate JWT Token for Snowflake Key Pair Authentication?
Learn what JWT token is, how to generate it and pre-requisites to generate it for Snowflake Key Pair Authentication.
Key Pair Authentication in Snowflake
Snowflake supports Key Pair authentication which uses a combination of public-private key pair for enhanced security.
Caller’s and Owner’s Rights in Snowflake Stored Procedures
The stored procedures in Snowflake runs either with caller’s or owner’s rights which defines the privileges with which the procedure executes.
Exceptions in Snowflake Stored Procedures
Snowflake allows catching exceptions and their error information that occur in stored procedures by defining exceptions.
RESULTSET in Snowflake Stored Procedures
Snowflake allows storing the result set of a SELECT statement and return them as output in the form a table using RESULTSET.