Leader specific functions
Leader nodes have special functions that run only on them, a common source of errors. For example, you should always use the SUBSTRING function and avoid SUBSTR. Let's experiment and see why.
This exercise is part of the course
Introduction to Redshift
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Use SUBSTR on 'datacamp' starting at 4 as extract
SELECT ___('___', ___) AS ___;