stored-proceduresamazon-redshiftaginity

Unable to create a Stored procedure in Redshift Aginity and aginity pro

Trying to create the stored procedure in redshift aginity workbench but it through an error like 'unterminated dollar-quoted string at or near "$$ '

In amazon, they already gave the solution for this https://docs.aws.amazon.com/redshift/latest/dg/stored-procedure-create.html

particular client tool only supported to create the stored procedure. I want to conform aginity don't have the option to create this? and Which is the best tool to create stored-procedure?

CREATE OR REPLACE PROCEDURE staging.test_sp1(f1 int, f2 varchar)
AS $$
BEGIN
  RAISE INFO 'f1 = %, f2 = %', f1, f2;
END;
$$ LANGUAGE plpgsql;
Solution

  • You can create RedShift stored procedures in Aginity Pro by using Run Batch. Full support will be in the 9/16 release.