debuggingloggingsnowflake-cloud-data-platformecho

Snowflake SnowSQL debug command equivalent to echo/print

I'm discovering Snowflake, and am currently using a few SET commands to set session variables values.
Not going too much into the details (because I don't want anybody to focus on this part), I initialize 2 variables, a beginning date and then an end date based on the beginning date, which includes timezone conversions.

I was wondering if there are commands equivalent of programming languages classical echo, print, console.log, etc. that I could use to display/debug what's in these session variables. I didn't find such a thing.

Solution

  • Current value of a session variable:

    SELECT $var_name;
SHOW VARIABLES LIKE 'var_name';