Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

Snowflake

Basics

How to Insert Data in Snowflake How to Update Data in Snowflake How to Delete Data in Snowflake

Database Management

How to Add a Default Value to a Column in Snowflake How to Add a Column in Snowflake How to Add a NOT NULL Constraint in Snowflake How to Alter Sequence in Snowflake How to Create a Table in Snowflake How to Create a View in Snowflake How to Create an Index in Snowflake How to Drop a Column in Snowflake How to Drop a Table in Snowflake How to Drop a View in Snowflake How to Drop an Index in Snowflake How to Duplicate a Table in Snowflake How to Remove a Default Value to a Column in Snowflake How to Remove a NOT NULL Constraint in Snowflake How to Rename a Column in Snowflake How to Rename a Table in Snowflake How to Truncate a Table in Snowflake

Dates and Times

How to Convert UTC to Local Time Zone in Snowflake How to Group by Time in Snowflake How to Query Date and Time in Snowflake How to Round Timestamps in Snowflake

Analysis

How to Avoid Gaps in Data in Snowflake How to Calculate Cumulative Sum/Running Total in Snowflake How to Calculate Percentiles in Snowflake How to Compare Two Values When One is NULL in Snowflake How to Do Type Casting in Snowflake How to Get First Row Per Group in Snowflake How to Have Multiple Counts in Snowflake How to Import a CSV in Snowflake How to Query a JSON Object in Snowflake How to Use Coalesce in Snowflake How to Write a Case Statement in Snowflake How to Write a Common Table Expression in Snowflake

Ready for a modern SQL editor?

Get started for free

Cta