- Newest
- Most votes
- Most comments
Hello,
Unfortunately Glue connections to MySQL 8.0 are currently not supported. As of now, the driver we use in Glue does not support MySQL 8. Please refer this link as to know what JDBC drivers are supported by Glue - https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-connect.html#aws-glue-programming-etl-connect-jdbc
There is currently no way to specify your own JDBC driver for crawlers. However, there's a workaround available with Glue ETL jobs, where you can use your own JDBC drivers by uploading a MySQL 8 compatible driver to S3 - https://aws.amazon.com/about-aws/whats-new/2019/11/aws-glue-now-enables-you-to-bring-your-own-jdbc-drivers-to-your-glue-spark-etl-jobs/
Please open a support ticket with Glue team for any further questions and for us to troubleshoot the issue further.
Additionally Glue 3.0 ETL job has Mysql 8 driver inbuilt in environment , So using AWS Glue 3.0 version you can read and write data to MYSQL 8 directly without providing any driver manually.
Appendix B: JDBC driver upgrades : https://docs.aws.amazon.com/glue/latest/dg/migrating-version-30.html
Relevant content
- asked 2 years ago
- asked a year ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated a year ago