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
- Reorder rows in a MySQL table
- Need to truncate a timestamp and add a minute to it in SQL
- Shortcut for Question marks in preparedStatement for parameterized query
- Correctly Migrate Postgres least() Behavior to BigQuery
- Dealing with single quotes in excel vba sql queries
- Data is Null. This method or property cannot be called on Null values
- Redshift GROUP BY ALL syntax not supported
- How to simulate GREATEST() in Sybase ASE?
- Retrieve data from 3 tables with 2 conditions
- How to LOCK with READ COMMITTED SNAPSHOT
- How to save the result of a condition (IF) into a variable?
- SQL query to get students who have enrolled in English or Urdu course but not in both
- Mysql Where Calculate
- MySql reuse alias for WHERE clause
- Filter by distance in the same query that calculates it with MySQL?
- Age calculation not working
- MYSQL using alias in the WHERE clause
- WHERE clause to filter times that are under an hour
- Unknown column for calculate field in MySQL
- Calculated column in where-clause - performance
- mysql calculation results in WHERE clause
- Getting previous column values in a new column
- Why do we always prefer using parameters in SQL statements?
- SQL Statement using Where clause with multiple values
- I am getting the following error when I am inserting a all the lines of a very large log file into ms sql server 2008
- how to see generated sql from a linq query
- Snowflake PARSE_JSON pattern match for keys
- Get a result set flagging where there is a history going back 3 months
- Chaining joins in SQL based on dynamic table
- what are the alternative methods to replace SSRS Subscription?