Snowflake Archives - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

Snowflake – Query Result from Cache or Disk

October 1, 2021

Pinal Dave

SQL Tips and Tricks

Snowflake, SQL Cache, SQL Memory, SQL Server

Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.

Gouache painting of a snowflake-shaped cutout with a vermilion centre on cloth beside shears on a sewing table

Snowflake JavaScript Procedure: A Stored Procedure Template

September 30, 2021

Pinal Dave

SQL Tips and Tricks

Snowflake, SQL Server, SQL Stored Procedure

A Snowflake JavaScript procedure wraps SQL statements in JavaScript code. This post gives a clean template, shows how to call it, read a result, pass an argument and catch an error. The code follows Snowflake’s documented API and was not run on a Snowflake account.