Collapsible code blocks in Snowflake - How?
I have seen folks post in Reddit about the new (1 year old now) functionality of collapsing code blocks in Snowflake.. Unfortunately no one has explained how to do this to the novice user. Can someone please help with this?
this is what my worksheet looks like
Solution
Please note it is only available in Snowsight.
Note:
If you are using single line code, you would not see the collapsible option
You need to use multi-line code and hover on the left side to see the collapsible option.
"hover" or "mouseover" refers to the action of moving the mouse cursor over a specific area on the screen, such as a link, button, or image, without clicking
- DateTime2 vs DateTime in SQL Server
- Generate Dates between date ranges
- Why (and how) to split column using master..spt_values?
- Oracle-DB, Joining 3 Tables Limiting the second without using LATERAL() or nesting
- How to convert sql table into a pyspark/python data structure and return back to sql in databricks notebook
- Get rendered SQL from CodeIgniter active record script
- Materialized view in Marketing Performance DB in Azure SQL database
- mysql delete under safe mode
- SQL SELECT WHERE field contains words
- SQL Server: group dates by ranges
- Get day of week in SQL Server 2005/2008
- The table has no ID, the date is contained in two columns
- Creating an index on a table variable
- How to drop all tables except 1
- Pyspark: Select all columns except particular columns
- How do I grant read access for a user to a database in SQL Server?
- MariaDB : create database and execute sql script without '<' character from the command line cmd.exe
- Find records with only one id
- MySQL - Get the first and last day of previous week
- Implementing iteration in Standard SQL (BigQuery)
- Concatenate dataframes in a loop where some of them may have no values
- SQL update with join is only updating one column
- Nested LAG function (kind of)
- Get SQL to get all records from a usertable and those matching uids from second table or return null
- SQL query to find duplicate rows based on multiple columns
- SQL Server Add row number each group
- How to calculate FIFO in SQL using matching overlapping blocks (using JOIN instead of UNION)
- How do I spool to a CSV formatted file using SQLPLUS?
- what is a foreign key and why you use it?
- What is semi-join in database?