Redshift limitations


There does not seem to be official support for Redshift in Datagrip although much of the functionality works.  Things malfunctioning seem  to be:

1. SQL editor doesn't understand Redshift-specific syntax like listagg, diststyle

2. if a query is executed from the sql editor and it fails, any subsequent queries will also fail until a 'rollback' command is run first.  Then queries work again.

3. Editing data in tables doesn't seem to work even if Auto-commit is checked.

Is official Redshift support coming?

cheers, jeff


Please sign in to leave a comment.