AWS Glue and MS JDBC connection string for multiSubnetFailover and applicationIntent.

Hi,

The support of JDBC connections in Glue is limited to some db servers only. Here is the list: https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-connect-jdbc-home.html

Are you in one of those supported use cases ?

Also look at section "Use custom JDBC driver" on this page to get concrete examples of working connection strings

Best,

Didier

Thanks, Didier.

I had simply grabbed the latest, 12.6.2, so downgrading that to 9.4.0 was a good suggestion.

Still running into the case where ";applicationIntent=ReadOnly" and/or ";multiSubnetFailover=true" causes:

An error occurred while calling o253.getSource. : java.io.InvalidObjectException: JDBC connection URL jdbc:sqlserver://listener.domain.local:1433;databaseName=database;applicationName=AWSGlue;applicationIntent=ReadOnly is not supported.

applicationName seems to be supported. jdbc:sqlserver://listener.domain.local:1433;databaseName=database;applicationName=AWSGlue; works great, for example.

I did read that not all custom driver features would be supported, but I haven't seen anything that indicates what those supported/unsupported might be. This could simply be a case that applicationIntent and multiSubnetFailover are not supported in Glue despite being supported by the custom driver.

Any idea where I might find that documentation?

Cheers! Bryan