MongoDB Atlas Connection - AWS Glue

Question

**When I'm trying to import a collection from MongoDB Atlas to AWS Glue using a MongoDB connection, I get the following error :**

Session failure.
InvalidInputException - Unable to resolve any valid connection (Service: AWSGlueJobExecutor; Status Code: 400; Error Code: InvalidInputException; Request ID: 2e7885ad-a3d4-460c-a876-9921f905830d; Proxy: null)
Error details
Request id: 3ef5ee61-7035-4adb-a527-e49f5069341a
Status code: 400

**I have followed the documentation regarding the url :**

Connection URL : mongodb+srv://proj1.z1qzqz6.mongodb.net/MVP1
Database : MVP1
Collection : Projects
Partition size (MB) : 10
Partition key : _id

In MongoDB I have whiytelisted all IP addresses and I have confirmed that I'm using the right username and password in my connection.

Osvaldo Marte · Answer

`
Session failure. InvalidInputException - Unable to resolve any valid connection (Service: AWSGlueJobExecutor; Status Code: 400; Error Code: InvalidInputException; Request ID: 2e7885ad-a3d4-460c-a876-9921f905830d; Proxy: null) Error details Request id: 3ef5ee61-7035-4adb-a527-e49f5069341a Status code: 400
`
This typically means that the information or parameters provided in the request did not meet the expected format or values required by AWS Glue.

When attempting to access a collection within MongoDB Atlas, your configuration settings should resemble the following:

```python
mongo_uri = "mongodb+srv://proj1.z1qzqz6.mongodb.net:27017/MVP1"

read_mongo_options = {
    "uri": mongo_uri,
    "database": "MVP1",
    "collection": "Projects",
    "username": "mongodbUsername",
    "password": "mongodbPassword",
    "partitioner": "MongoSamplePartitioner",
    "partitionerOptions": {
        "partitionSizeMB": "10",
        "partitionKey": "_id"
    }
}
```

Additionally, ensure that your Glue permission policy includes the `glue:GetJobRun*` action to maintain proper access and functionality.

Hari · Answer

Hi , 
I'm also facing the same error what you got, have you found any solution to it. if any reply soon please ...

MongoDB Atlas Connection - AWS Glue

Añade tu respuesta

Contenido relevante