Data Types and Functions in Snowflake
Learn Snowflake data types, text, number and date functions, user-defined functions, semi-structured data, CTEs and pivots in interactive SQL exercises.
Snowflake stores text, numbers, timestamps and semi-structured records, and each type supports its own operations. You learn how Snowflake defines and stores each kind of value, convert strings into timestamps, reshape values with built-in and custom functions, and then flatten nested records and pivot query results into tables ready for reports and analysis.
What You Will Achieve
- Pick a suitable data type for each column when creating a table, and convert strings into timestamps
- Clean and combine text values, run calculations and summary measures, and work out intervals between dates
- Write your own user-defined function to apply custom logic, such as ranking records by a measure
- Pull top-level and nested fields out of semi-structured data and pivot query results into a report-ready table
Program Overview
Snowflake Text, Numeric and Datetime Types
Covers how Snowflake stores text, numbers and dates, with precision, scale and time zones along the way.
- Defining text columns and reading column details
- Numeric types, precision and scale
- Building datetime values and handling time zones
- Converting strings to timestamps
Manipulating Data with Functions and UDFs
Works through built-in functions for text, numbers and timestamps, then custom functions, using gym membership data.
- TRIM, SPLIT and CONCAT on text
- Arithmetic, comparison operators, SUM and AVG
- Extracting timestamp parts and date intervals with DATEDIFF
- User-defined functions (UDFs)
Semi-Structured Data, CTEs and Pivoting
Closes with VARIANT data, multiple common table expressions and the PIVOT keyword for shaping results.
- VARIANT data with dot and bracket notation
- Retrieving nested values
- Building multiple common table expressions
- Pivoted tables with PIVOT
Certificate Awarded (Paid)
Job Outlook
These skills are used in analytics and data engineering work that runs on Snowflake, where columns need the right types and raw or nested records need cleaning before they feed reports.
Good for: SQL users who already query Snowflake and want firmer control over its data types, built-in functions and semi-structured data.
Keep in mind: The semi-structured lessons work with VARIANT fields read through dot and bracket notation, and most exercises query gym member, membership and workout tables.
Bottom line: A focused run through Snowflake’s type system and functions that finishes with the shaping tools analysts reach for most: nested data, CTEs and pivots.
Frequently Asked Questions
Which Snowflake functions do the exercises use?
The lessons work with TRIM, SPLIT and CONCAT for text; arithmetic, comparison operators, SUM and AVG for numbers; and DATEDIFF plus timestamp extraction for dates. A later lesson has you write your own user-defined function.
How does the course handle semi-structured data?
It treats semi-structured values as VARIANT data and shows how to read top-level and nested fields with dot-notation and bracket-notation, then uses the results to build descriptions of gym members.
What dataset do the practice exercises use?
Most exercises draw on a gym setting: member details, check-ins, membership prices, workouts and calories burned. The same tables return in the datetime, function, CTE and pivot lessons, so later queries build on data you already know.
Are time zones part of the datetime lessons?
Yes. The datetime lessons include building datetime values, a lesson on time zones and converting strings into timestamps, before later lessons extract parts such as the year or hour and measure the time between two dates.


There are no reviews yet.