SnowPro™ Core Certification Companion: Hands-on Preparation and Practice

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

M. FerleSnowPro™ Core Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9078-1_11

11. SQL Scripting and Snowpark

Maja Ferle¹  

(1)

Ljubljana, Slovenia

 

In addition to querying data using SQL, Snowflake supports working with data programmatically in the form of writing procedural blocks of code, creating stored procedures and functions, and creating API calls.

This chapter reviews Snowflake scripting and Snowpark, two features for working with data programmatically in Snowflake. For the SnowPro Core exam, you don’t need to know all the details about writing code, because this is tested on the advanced exams. But you ...