Snowflake
Snowflake, Powered for Insights: Learn with DataReportive.
This tutorial walks you through Snowflake from basics to advanced reporting. Discover how to structure, query, and optimize your data to fuel smarter dashboards, reports, and analytics—directly aligned with real-world use cases from the DataReportive platform.
Database Management
How to Add a Default Value to a ColumnHow to Add a Column
How to Add a NOT NULL Constraint
How to Alter Sequence
How to Create a Table
How to Create a View
How to Create an Index
How to Drop a Column
How to Drop a Table
How to Drop a View
How to Drop an Index
How to Duplicate a Table
How to Remove a Default Value to a Column
How to Remove a NOT NULL Constraint
How to Rename a Column
How to Rename a Table
How to Truncate a Table
Dates and Times
How to Convert UTC to Local Time ZoneHow to Group by Time
How to Query Date and Time
How to Round Timestamps
Analysis
How to Do Type CastingHow to Avoid Gaps in Data
How to Calculate Cumulative Sum/Running Total
How to Calculate Percentiles
How to Compare Two Values When One is NULL
How to Get First Row Per Group
How to Have Multiple Counts
How to Upload CSV
How to Query a JSON Object
How to Use Coalesce
How to Write a Case Statement
How to Write a Common Table Expression