sqitch icon indicating copy to clipboard operation
sqitch copied to clipboard

Published 20 hours ago • verified publisher icon sqitchers

Redshift Support

Open jvice opened this issue 4 years ago • 3 comments

Does sqitch currently have support for Redshift? If not, are there future plans to add support?

jvice avatar Jul 01 '21 19:07 jvice

Not explicitly. Have you tried it? The Postgres engine might work.

theory avatar Jul 02 '21 22:07 theory

@theory I recently tried postgre engine with redshift. One of first sqls it tried and failed is using array_agg function which does not exist on redshift.

ERROR:  syntax error at or near "array_agg"
LINE 13:         , ARRAY(SELECT * FROM UNNEST( array_agg(t.tag) ...

halilduygulu avatar Apr 20 '22 14:04 halilduygulu

Ah, so Sqitch does not currently support RedShift. Some initial work was done in #300, but it would need to be updated and a method for testing it added. Happy to get a contribution like that!

theory avatar Apr 20 '22 15:04 theory