AWS Crawler Throwing Connection Error When Glue Connection Test Passes

Question

I'm hitting an error on AWS and oogle has not been much help thus far. Here is the problem I have. I have setup a connection in Glue to my Oracle RDS. When I test the connection it passes. When I run the Crawler it fails with the following error:

ERROR : Error crawling database my_oracle_db:
SQLException:
SQLState: 08006
Error Code: 17002
Message: IO Error: Invalid connection string format, a valid format is: "host:port:sid" 

I have manually altered the JDBC connection string so that the / between port and SID is replaced with : I did test the connection both ways, and the test passed. What could be causing the error to get thrown?

Answer 1

The "include path" field must be filled with the database name followed by "/%" when it is not SSL

In my case, the database name is DATABASE_NAME

More detail here