Questions tagged with Amazon DynamoDB
Content language: English
Sort by most recent
Hi!
I need to store in dynamoDB information related to users. That information will be queried (I need milliseconds response time) by month and year (separately), so I was thinking of different approaches here. First of all, I was thinking of:
- Partition key: the unique identifier for the customer (for example: 3322)
- SortKey: the year (numeric, for example: 2023)
- Create an index using the partition key and the month (numeric, for example: 01)
But I was also doubting about using just a single partitionkey with the syntax: customerid+_Mmonth+_Yyear. For example, if the customerid is 3322, january 2023 would be stored as:
*partitionkey = 3322_M01_Y2023*
In this case no sort key would be needed. My main concern here is whether it will be efficient to query by "partition key ends with Y2023" when searching by year or "partitionkey contains M01" when searching by month.
Which approach should I follow?
Thank you for your help!
Hey,
In the last 24 hours we see some of our lambda's that interact with DynamoDB fail due to DNS resolving error:
{"errno":-3008,"code":"ENOTFOUND","syscall":"getaddrinfo","hostname":"dynamodb.us-east-1.amazonaws.com","$metadata":{"attempts":1,"totalRetryDelay":0}}
Did somebody encounter this issue or have any leads? it doesn't seem to be a DNS throttling as the invocation count of this lambda during the time when the error occurred was very low.
While using cognito signin using external social identity providers like google, signin at first attempt not getting access token and so I am not able to signin. if we try second time , is able to login.
Hi everyone,
I just developed my own django app, in which I use AWS SDK boto3 to use DynamoDB and SNS in my code. Everything worked well on my local machine. I then deployed my app on AWS and my app is running well.
On my web browser, I access my app and when I perform operations that triggers DynamoDB and SNS services, then the app crashed with Internal Server Error(500).
I read some AWS documentation and it says that by default DynamoDB is communicated via HTTPS via internet.
I tried to add inbound rules to my EC2 with a hope to connect to DynamoDB, unfortunately it didn't work.
I would like to ask how we can set up connection between my EC2 and DynamoDB and SNS? I don't need VPC Endpoint, I just need a connection via Internet.
Do I add inbound rules on my EC2's sescurity group, public subnet route table?
OR
I need to add inbound rules on the load balancer?
Thanks a lot for your help
$0.50 per rule per month for CW-Rule-DynamoDB in Asia Pacific (Seoul) <- i payed at here
Money continues to be paid out of unused cloudwatches. Why? And how to solve it?
**Context**: My app needs to load data from a 'Users' table on the backend. In order to do this, when User-X signs in, I make GraphQL calls to that table to find the user.
**Problem**: Amplify only checks 1000 records at a time. If it finds User-X in the first 1000, it will return me his data. If not, I have to make another API call to the server, and look for User-X in the next 1000 records. And so on.
**Reference**: https://docs.amplify.aws/lib/graphqlapi/query-data/q/platform/android/#list-items
**Why this is a problem**: Paginating in this way via multiple API calls to the back is obviously not optimal, since the latency of my app will increase proportionately to my userbase.
**Question**: I am sure there must be a more efficient way to do this. Any thoughts?
Hi @Everyone,
Could someone enlighten me?
1. How does the concept of Index in DynamoDB from the concept of INdex Relational DBs?
2. Can I partition tables like in transactional DB in DynamoDB?
3. Are aggregation operations possible to do using a NoSQL like DynamoDB?
Thank you in advance for the answers
Highly appreciate the clarifications.
Application : Android
Backend : AWS Amplify
Issue : AWS Amplify Scaling and GraphQL Pagination
In Splash Screen, i am getting the userID using Amplify.Auth?.currentUser?.userId and using that userID, I am fetching User information saved in User table using amplify-framework [GraphQLRequest(ModelQuery.list)](https://docs.amplify.aws/lib/graphqlapi/query-data/q/platform/android/)
So, the issue is for the users around the selected AWS region for the amplify, the Splash page loading is fine. However, for the users who are far, the experience on Splash and others sections of the App is not good while loading the data (which i think is currently it due to the pagination thing in the GraphQL API)
So my questions are :
1. What can i do better to reduce the API calls using GraphQL API in context of AWS amplify
2. How can i deploy the AWS amplify application/backend in multiple AWS regions.
Hello,
I ask these questions because I couldn't found much information about used case or best answers about migration MongoDB to DynamoDB.
- Does DynamoDB support ObjectId, which is used as a unique key in existing MongoDB, in a similar form?
- Is it a good way to store partition keys by dividing them by geographical criteria when designing a global table?
- If I want to build a DynamoDB table as a global table, is the Global Secondary Index an essential part of the design?
- Should the sort key be used for all items that are subject to the query conditions among queries that query the collection in the existing MongoDB?
It will be so helpful if you guys give some advice of those questions or commend
Thank you so much
Hello everyone and thank you in advance for any guidance,
First off, I'm a n00b with AWS who's task is to get real time pricing information to the website product builder as selections are being made.. think of it as a car builder.. First pick frame (click) Total $9,999 base... now click on the wheels you like Total changes to $12,500 in real time etc etc
We currently have a working REST API that sends all our data from Airtable(where we store and maintain all data and pricing) to DynamoDB via lambda
What path would be most efficient to pull this off via webhook(?) API (will be sending a json with all the parts and wanting this to pull data then calculate a price by doing some multiplication ie quantity needed x price per pulled from the db?
Thanks again
Current situation:
I have an API Gateway referencing some Lambdas, and some Lambdas querying a DynamoDB instance.
All created and handled manually via the AWS web console. There's no cloudformation template.
--
^ I want to be able to have that locally too using CDK:
I want to apply some healthy developer procedures and create a CDK file system locally, for testing, manage deployment, manage versioning via github or whatever aws has to offer in that field (didn't get to that part yet).
I noticed that there is 0% information on how to do that. most tutorials follow a situation where
1, i am creating a cdk from scratch,
2. or already have a cloudformation structure.
Do i just init a cdk and name services the same as my current services to "take over them"? or will they get re-written ( = total disaster).
Is there a way to export a code sample for each service i currently have and connect them with each other?
I don't know where to start doing that and there is totally no information about that anywhere
Please help me figure our the best proper way to do that.
I'm using **Amazon pinpoint service** to send an email with attachment.
**It is working fine while sending pdf as the attachment but I'm facing some issue with excel as attachment.** The issue is that we are able to receive email in inbox but while trying to open the attachment excel it is showing as file is corrupted and its trying to repair. PFA for more details.
The same file is working fine and we are able to open when we download that file into our desktop. We are using [ExcelJs](https://www.npmjs.com/package/exceljs) library to generate excel file and then we are uploading them to AWS S3 bucket. We are even able to download our excel file from S3 and its working fine without any issue. But the problem is coming only when we are sending this file through the amazon pinpoint service.