Issue with Calling Stored Procedure and Accessing Temp Tables in Redshift

Hi Community,

I am facing an issue while working with Redshift Live Connection and would appreciate your insights.

Here’s the situation:

• I have a stored procedure in Redshift that stores data into temporary tables when executed.
• To connect to Redshift, I am calling this stored procedure via a custom query and then attempting to run a SELECT query on the temporary tables created by the procedure.

The problem is:
The Redshift connector seems unable to handle this setup, and I am unsure if I am calling the stored procedure correctly.

Here’s how I am calling the procedure:

CALL my_stored_procedure();
SELECT * FROM temp_table_created_by_procedure;

Questions:

1. Am I calling the stored procedure in the right way to access the temp tables?
2. Is there a better approach to achieve this functionality, or are there limitations with the Redshift connector when working with temp tables created in stored procedures?

Any advice, best practices, or alternative methods would be greatly appreciated!

Thank you!