Alternative to a sql stored procedure in Amazon Redshift
Hello All, We are new to Amazon Redshift and we are planning to migrate the data(procs, cubes etc) from SQL Server to Redshift. I have gone through some articles and found that Redshift does not allow stored procedures. If that is the case my SSRS reports will fail. How do I handle the stored procedures in Redshift? Thanks.
It rather depends on what your stored procedures are doing. If they are just selecting data, then you could [CREATE a VIEW]; you also have the option of creating python-based scalar functions. Failing that, it rather appears that you'll just have to redesign your reports to use different queries. :
Stored procedure result is not just a selecting rows from table. It is more likely some sort manipulation and get the data into temp table, assign some values. How can we achieve this functionality in Redshift objects or any other alternatives? Does it support in python-based scalar function?