Summary
User reports a syntax error when syncing with Airbyte due to the special character ‘#’ in their DynamoDB column name. The error persists even after attempting to register the column name in the reserved attribute names field.
Question
hello, I have a table in DynamoDB with a column name "Source#BpmRange#TrackId. when performing a sync with airbyte, I get errors telling me there is a syntax error near #BpmRange. When I put my column name in the reserved attribute names field, i then get this error:
software.amazon.awssdk.services.dynamodb.model.DynamoDbException: ExpressionAttributeNames contains invalid key: Syntax error; key: "#dyndb_Source#BpmRange#TrackId" (Service: DynamoDb, Status Code: 400, Request ID: C6F0G68SJFTQ12OM8K548505PBVV4KQNSO5AEMVJF66Q9ASUAAJG) 68
the special character # is obviously causing this problem. Has anyone encountered this before/ potentially made a work around?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.