Can AWS Athena DynamoDB Connector not able to scan DynamoDB tables with Upper Case letters in their name?
I am facing a strange behaviour when using AWS Athena DynamoDB Connector. It seems to me that the connector does not read/scan DynamoDB tables named in Upper Case letters (e.g. MY_CARS).
Hear me out here..
I have 1 test DynamoDB table called 'country' (all lower case) and I configured Athena DynamoDB connector to read and query against this table. All is good so far and I am able to query the 'country' table using Athena SQL Query.
Now I create another DynamoDB table and called it 'MY_CARS' (all upper case) and when I went back to the Athena SQL Query, I got the following error:
Has anyone faced this issue? you can see the error message is using 'my_cars' (lower case) while my table is name is 'MY_CARS' so it is failing to get the table metadata because DynamoDB tables are case sensitive and obviously I don't have a table called 'my_cars' with lower case letters.
I feel that this is a bug in the DynamoDB Connector but I want to see if anyone faced or could confirm this behaviour (or if there is a quick fix I can use).
It's not the connector thats the issue, it's how Athena works:
Acceptable characters for database names, table names, and column names in AWS Glue must be a UTF-8 string and should be in lower case. Note that Athena automatically lowers any upper case names in DDL queries when it creates databases, tables, or columns. The string must not be less than 1 or more than 255 bytes long.
- AWS CLI Create Default VPC
- Email address is not verified (AWS SES)
- RDS Proxy: PENDING_PROXY_CAPACITY and "DBProxy Target unavailable due to an internal error"
- mTLS on AWS ALBs across multiple regions
- How to debug a aws lambda function?
- AWS SAM retrieve secret value from Secret Manager with dynamic referencing
- Cloudfront redirect when signed cookies not present
- Is there a wildcard character in AWS EventBridge rules?
- Laravel file upload s3 Multipart
- Increase EC2 disk storage without losing any data
- AWS Lambda triggers SES in VPC
- Setting HTTP Headers with Lambda@Edge
- How to find an Amazon EC2 AMI if I only have the id?
- AWS Lambda - Can't set memory larger than 3008 MB
- Which one is the cheapest to use AWS RDS or my own database?
- AWS Glue Please verify role's TrustPolicy
- How to create event bus events with source 'aws.'?
- Terraform and AWS: No Configuration Files Found Error
- How to transfer the packets through NAT gateway instead of public IP?
- Is Aws well architected framework supports API's?
- Can't delete AWS internet Gateway
- Unable to Trigger Lambda function in AWS using Python code from my local setup
- How to login with AWS CLI using credentials profiles
- How to retrieve multiple endpoints using data "aws_vpc_endpoint" resource?
- When pushing to ECS, Docker image errors out with module not found error
- Is there a way to drop file extensions when using AWS CLI with --recursive?
- On-demand self-hosted AWS EC2 runner for GitHub Actions
- How to manage dev and prod environments in a SAM project with CloudFormation Stacks, API Gateway, Lambda, and other AWS services?
- EC2 Instance error telling me multiple IAM Roles are attached when I try to change it...?
- (NoSuchVersion) when calling the GetObject operation: The specified version does not exist