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?