If you have come across following error, particularly on AWS RDS MySQL, follow this article for the solution.
Unexpected error running Liquibase: Migration failed for changeset Functions/json_transform2/20250415161546_create_function_json_transform2.sql::20250415161546_create_function_my_custom_function….
Reason: liquibase.exception.DatabaseException: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
1. Login to AWS RDS and select database instance
2. From the left menu, choose parameter groups
3. Select create parameter group and create one
4. Once created, Edit the parameter group, search ‘trust’ and update value from 0 to 1. Save changes.
5. Select DB Instance, and choose reboot from the Actions menu
You’re done. The issue should resolve on reboot.
