All topics
Data warehouse / 33 guides
Snowflake
SQL patterns, warehouses, stored procedures and account usage queries.
Everyday queries
- How to DELETE with JOIN in Snowflake
- How to remove duplicates from a table in Snowflake
- Drop table in Snowflake if exists
- How to rename a column in Snowflake
- How to UPDATE a table with JOIN in Snowflake
- How to describe a table structure in Snowflake
- Query warehouse, database and schema
- How to perform an INSERT/UPDATE on match/unmatch in Snowflake
- How to find the credit usage of the last 7 days
- How to find the list of warehouses and the credit consumption in the last 7 days
- How to find the average daily space used for storage in the last 7 days
- How to find running queries and kill them
- How to find the most expensive query executed
- How to change the output format of DateTime in a session
- Add a column to an existing table
- How to create a Javascript function and call it in Snowflake
- How to suspend a warehouse in Snowflake
- How to resume a warehouse in Snowflake
- How you can resize a warehouse in Snowflake
- How to create a warehouse in Snowflake (initially suspended)
- How to use a warehouse in Snowflake
- How to drop a warehouse in Snowflake
- How to get information and the results of the last executed query