Chapter 7 – Basic SQL Functions

“When I was 14, I thought my parents were the stupidest people in the world. When I was 21, I was amazed at how much they learned in seven years.”

- Mark Twain

Finding the Current Schema on the Leader Node

image

The CURRENT_SCHEMA function is a leader-node only function. In this example, the query does not reference a table, so it runs exclusively on the leader node in order to show the schema. Our Current_Schema is the public schema.

Getting Things Setup in Your Search Path

image

set search_path to '$user', 'public', 'sql_class', ...

Get Amazon Redshift: A Columnar Database SQL and Architecture now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.