Snowflake How-To Guides

Practical Snowflake answers with statements you can copy and run.

• How to Create a Table in Snowflake
• How to Rename a Table in Snowflake
• How to Rename a Column in Snowflake
• How to Add a Column in Snowflake (ALTER TABLE)
• How to Drop a Column in Snowflake
• How to Insert Data in Snowflake
• How to Update Rows in Snowflake
• How to Delete Rows in Snowflake
• How to Truncate a Table in Snowflake
• How to Duplicate a Table in Snowflake
• How to Create a View in Snowflake
• How to Drop a Table in Snowflake (and Undrop It)
• How to List Tables in Snowflake
• How to Cast a Column in Snowflake
• How to Get the Current Date and Time in Snowflake
• How to Upsert in Snowflake with MERGE
• How to Create a Schema in Snowflake
• How to Add a Comment to a Table in Snowflake
• How to Change a Column Type in Snowflake
• How to Use QUALIFY in Snowflake
• How to Describe a Table in Snowflake
• How to Remove Duplicates in Snowflake
• How to Flatten JSON in Snowflake
• How to Split a String in Snowflake
• How to Use DATEDIFF in Snowflake
• How to Convert Timezones in Snowflake
• How to Pivot Rows to Columns in Snowflake
• How to Create a Sequence in Snowflake
• How to Grant SELECT on a Table in Snowflake
• How to Use LISTAGG in Snowflake