-
Hello Felipe Diego, RyanDymek, and to22,
Good day!
Thank you all for the valuable input and for taking the time to share your insights and documentation. I apologize for the confusion caused by my previous explanation. Upon reviewing the Amazon Redshift documentation you provided, it is clear that my initial understanding was incorrect.
The pg_table_def table as correctly pointed out, resides exclusively on the leader node in Redshift, and so does the current_schema() function. The query in question should not result in an error under normal circumstances, and the behavior described in the previous answer was inaccurate. Both the pg_table_def table and the current_schema() function are indeed leader node–only elements, and should operate without issue in the scenario mentioned.
I appreciate your patience, and I would like to assure you that we will be updating this question and its answer to reflect the correct behavior of Redshift in such cases, ensuring alignment with the official AWS documentation. This correction will help avoid any confusion in the future when learners review this material.
Once again, thank you for your thorough feedback, and should you have any further queries or suggestions, please don’t hesitate to reach out.
Best regards,
Neil @ Tutorials Dojo
