Support default user session settings

[Olaktal]

Hello

Using Redshift Spectrum, we'd like all users to be able to parse json so we need to enable the following session settings to all users:

ALTER USER XXXX SET json_serialization_enable TO true;
ALTER USER XXXX SET json_serialization_parse_nested_strings TO true;
ALTER USER XXXX SET enable_case_sensitive_identifier TO true;

Right now we do it manually but we would like to handle it with your module but it seems like it cannot be handle with the resource redshift_user.
Is there any workaround ? If not, is anyone able to develop this feature please ? 🙏

Thanks !
Vincent

[Olaktal]

FYI the session settings seem to be stored in the following column

select useconfig, * from pg_user