Data Types and Functions in Snowflake

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Data Manipulation in Snowflake
DataCamp details
  • Chapters: 3
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: data-types-functions-snowflake Category: Tags: , , , Brand:

Learn Snowflake data types, text, number and date functions, user-defined functions, semi-structured data, CTEs and pivots in interactive SQL exercises.

At a glance
Duration3 hrs
LevelIntermediate
CertificateCertificate of Completion
LanguageEnglish
Taught byJake Roach
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

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.


Our take

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.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Data Types and Functions in Snowflake
    Data Types and Functions in Snowflake
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0