Zero date value prohibited while querying through Athena Federated Query to MySQL

Hi fam,

I am using an Athena Federated Query to MySQL as database connection in Metabase. In MySQL we can have zero date. But in Metabase I get this error:

[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:***] executed in context[S3SpillLocation{bucket='***', key='***', directory=true}] with message[java.sql.SQLException: Zero date value prohibited] [Execution ID: c8012456-ba01-45ad-8ab4-dcb2f8a5934e]

How can I fix this issue?

I tried the following in connection string:


It did not fix the issue.