1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Redshift
Connected

Exercise

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.

Instructions 1/2

undefined XP
  • 1
    • Use the SUBSTR() function to extract a substring from 'datacamp' starting at position 4, aliasing as extract.
  • 2
    • Use SUBSTR() on the public_intro_redshift.idaho_monitoring_location table's waterusedescription field starting at 5. Run the code and inspect the results.
    • Replace SUBSTR with the correct SUBSTRING function.