I'm trying to run a federated redshift query on a schema tied to an RDS instance (data encrypted at REST, but the connection doesn't require SSL encrpytion.
For any query I send, I get this error:
Connection to remote MySQL server was not encrypted.
My Schema looks like this:
CREATE EXTERNAL SCHEMA mysql_1
FROM MYSQL
DATABASE 'users'
URI 'X.X.X.X' PORT 3306
IAM_ROLE 'xxxxxxx'
SECRET_ARN 'xxxx'
Found no documentation on how I can specify the encryption, or disable it.
- see schema CREATE statement above
