Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

I am trying to run AWS GLUE connection through cloud formation but getting this error, please below for details

I am running AWS Glue connection code but getting an error. Please help me into this.

    "Resources": {
        "CFGLUEConnect": {
            "Type": "AWS::Glue::Connection",
            "Properties": {
                "ConnectionInput": {
                    "ConnectionType": "JDBC",
                    "Name": "TestGauravCF",
                    "MatchCriteria": ["",""],
                    "ConnectionProperties": {
                        "HOST": "gauravcfglue.cdztfiss7nlo.us-east-.rds.amazonaws.com",
                        "PORT": "5432",
                        "USERNAME": "gauravcf",
                        "PASSWORD": "saraswati",
                        "JDBC_CONNECTION_URL": "jdbc:postgresql://gauravcfglue.cdztfiss7nlo.us-east-2.rds.amazonaws.com:5432/gauravcf",
                        "JDBC_ENFORCE_SSL": "false"
                    },
                    "PhysicalConnectionRequirements": {
                        "AvailabilityZone": "us-east-2b",
                        "SecurityGroupIdList": [
                            "sg-0dd0a465",
                            "sg-728c5219",
                            "sg-28a3f742"
                        ],
                        "SubnetId": "subnet-bc3f1bc7"
                    }
                },
                "CatalogId": {
                    "Ref": "AWS::AccountId"
                }
            },
            "Metadata": {
                "AWS::CloudFormation::Designer": {
                    "id": "42035d15-dbf7-42f5-9e76-4a025414477c"
                }
            }
        }
    }
}

The error is:

"Validation for connection properties failed (Service: AWSGlue; Status Code: 400; Error Code: InvalidInputException; Request ID: 59944865-f88c-11e8-8ef8-dd0e0e1454dd)"

Comments