search

sqitchers / sqitch

Sensible database change management
https://sqitch.org
MIT License
2.78k stars 214 forks source link

Redshift Support #580

Open jvice opened 3 years ago

jvice commented 3 years ago

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

theory commented 3 years ago

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

halilduygulu commented 2 years ago

@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) ...
theory commented 2 years ago

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!