SELECT with Snowflake functions - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SELECT statement do in Snowflake?

The SELECT statement retrieves data from one or more tables or views in Snowflake. It allows you to specify which columns to show and can include functions to transform or calculate data.

beginner

How do you use the CURRENT_DATE() function in a SELECT statement?

You can use CURRENT_DATE() to get today's date. For example: <br>SELECT CURRENT_DATE; returns the current date in the session's time zone.

beginner

What is the purpose of the UPPER() function in Snowflake SELECT queries?

UPPER() converts all letters in a string to uppercase. For example: <br>SELECT UPPER('hello'); returns 'HELLO'.

intermediate

Explain how the DATEADD() function works in Snowflake.

DATEADD() adds a specified amount of time to a date or timestamp. For example: <br>SELECT DATEADD(day, 5, CURRENT_DATE()); adds 5 days to today’s date.

intermediate

What does the COALESCE() function do in a SELECT statement?

COALESCE() returns the first non-null value from a list of expressions. It helps handle missing data by providing a fallback value.

Which function returns the current timestamp in Snowflake?

A CURRENT_TIMESTAMP()

B NOW()

C GETDATE()

D TODAY()

CURRENT_TIMESTAMP() returns the current date and time in Snowflake.

What does this query return? <br>SELECT LENGTH('Snowflake');

A The number of characters in 'Snowflake'

B The word 'Snowflake'

C An error

D The position of 'f' in 'Snowflake'

LENGTH() returns the number of characters in the string.

How do you add 10 days to the current date in Snowflake?

A DATE_PLUS(CURRENT_DATE(), 10)

B ADD_DAYS(CURRENT_DATE(), 10)

C DATEADD(day, 10, CURRENT_DATE())

D CURRENT_DATE() + 10

DATEADD() is the correct function to add days to a date.

Which function converts a string to lowercase in Snowflake?

A MINUSCULE()

B DOWNCASE()

C TOLOWER()

D LOWER()

LOWER() converts all letters in a string to lowercase.

What will COALESCE(NULL, 'Snowflake', 'Cloud') return?

A NULL

B 'Snowflake'

C 'Cloud'

D An error

COALESCE returns the first non-null value, which is 'Snowflake'.

Describe how to use SELECT with functions in Snowflake to manipulate data.

Think about how you can change or calculate data directly in your SELECT statement.

Explain how Snowflake handles null values in SELECT queries using functions.

Consider how to provide fallback values when data is missing.