Glue OpenSearch connection

0

I am looking for a way to programmatically create a Glue data connection to OpenSearch. I cannot find find any info about this connection type being supported by the AWS API, SDK, CloudFormation etc ... The docs consider only the creation from the console UI.

Am I missing something?

profile picture
gefragt vor 3 Monaten535 Aufrufe
2 Antworten
1

The connection itself is generic metadata, what makes it a specific connection is the ConnectionType and ConnectionProperties.
You can list the values of a connection created via the console (e.g. aws glue get-connection --name your_connection) and then replicate the configuration programmatically

profile pictureAWS
EXPERTE
beantwortet vor 3 Monaten
  • Both the terraform AWS provider and CloudFormation require a connection type and validate it to match the API constraints. From the docs:

    ConnectionType – UTF-8 string (valid values: JDBC | SFTP | MONGODB | KAFKA | NETWORK | MARKETPLACE | CUSTOM).
    
    The type of the connection. Currently, SFTP is not supported.
    
0

For creating connections to data stores that are not explicitly supported through AWS Glue's API or SDK, one common approach is to use a custom connector or to integrate via a more generic JDBC connection if applicable. OpenSearch, being a fork of Elasticsearch, might be accessible through JDBC with the right driver and configuration. This approach would involve:

  • Finding a JDBC driver that can connect to OpenSearch.
  • Creating a custom connection in Glue that uses this JDBC driver, specifying the connection details to your OpenSearch cluster.

This process typically requires constructing the connection string manually and ensuring that your Glue jobs have the necessary permissions to access the OpenSearch cluster. This might involve setting up VPC endpoints, security groups, and IAM roles appropriately.

If this has answered your question or was helpful, accepting the answer would be greatly appreciated. Thank you!

profile picture
EXPERTE
beantwortet vor 3 Monaten
  • The JDBC solution may be an option but is out of scope. AWS supports OpenSearch connection from the console UI so it should be supported at the API and SDK level as well.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen