Hi All, I just found Airbyte yesterday as I need t...
# ask-community-for-troubleshooting
k
Hi All, I just found Airbyte yesterday as I need to sync a MS SQL DB to AWS Dynamo DB. I have MSSQL connected no issue but can not get the connection to DynamoDB to work. Any pointers? I'm running the docker image locally just for testing purposes.
m
@Kyle Hancock please downgrade Dynamodb version to 0.1.1
k
Thanks @Marcos Marx (Airbyte),I downgraded but now I receive the below error:
Copy code
The connection tests failed.
Could not connect to the DynamoDB table with the provided configuration. Unable to unmarshall exception response with the unmarshallers provided (Service: AmazonDynamoDBv2; Status Code: 400; Error Code: UnrecognizedClientException; Request ID: 761PRG5C47I0697T11PNU5KTBJVV4KQNSO5AEMVJF66Q9ASUAAJG; Proxy: null)
m
can you check your credentials? and make sure the db table
airbyte_sync
is created?
k
Reviewed everything found I was using the wrong region. However after correcting I'm still getting that same error. Does the partition key in DynamoDB need to be set to something specific? (throwing out guess here, thanks so much for helping)
👍 1
For anyone that finds this later I was able to connect using an IAM user that I created instead of the access key and secret associated with my normal creds.