Snowflake is a modern cloud data platform that boasts instant elasticity, secure data sharing and per-second pricing across multiple clouds. Its ability to natively load and use SQL to query semi-structured and structured data within a single system simplifies your data engineering.

To help you better understand the ins and outs of using Snowflake and its unique features, we’ve developed a demo series called Sirius About Snowflake.

In early 2019, Snowflake announced the general availability of JavaScript-based stored procedures. This procedural scripting language brings great flexibility to Snowflake. Conveniently, stored procedures are available in every edition of Snowflake.

Watch our newest video to learn about exception handling, Snowflake stored procedure restrictions, JavaScript try/catch blocks, and binding variables.

To complete this demo, you will need to use this code.

Stay tuned for the next video in our Sirius About Snowflake demo series. Have questions? Contact us.

Sirius provides Snowflake consulting, professional and managed services for data platform modernization, data migration, and achieving more insight from your data. We can answer any questions you have about Snowflake and help you better understand how to use its features.

Related: Sirius About Snowflake Demo: How to Use Query Tags