I am testing our backup process. I created a BACKUP of my database to S3 and then used RESTORE. Everything looked good until I tried to access the database with Metabase, which returned:
java.sql.SQLSyntaxErrorException: Variable 'sql_mode' can't be set to the value of 'ALLOW_INVALID_DATES'
It should be noted that everything worked fine prior to the RESTORE. Why did this change?