SnowPro Advanced Data Engineer

Snowpark DataFrame construction and transformations are lazy, so they do not execute a database query or require a virtual warehouse until an action evaluates the DataFrame. Calling a stored procedure with session.call() executes the procedure; a procedure that queries database data uses the caller’s current warehouse, and queries require a running warehouse. With USE_CACHED_RESULT set to false, the query cannot satisfy its result from the persisted result cache.