Questions in Database
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I need to find the difference between two timestamp range. I tried using DATEDIFF but not getting the exact result. Below is the query I am using:
```
select
rtrim(datediff(hour,'2024-05-15...
1
answers
0
votes
244
views
asked 7 days agolg...
I'm having the same issue. Data is stored in below format in s3 as JSON array with partitions
S3 path - s3://fleet-fuelcard-data-import-dev/lambda/fuelsoft-morgan/660306/2024/Apr/03-Apr-2024.json....
1
answers
0
votes
37
views
asked 7 days agolg...
It is mentioned in the user guide Managing an RDS Proxy (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-changing-db-user-password) that we to modify a proxy...
0
answers
0
votes
78
views
asked 8 days agolg...
I have deployed opensearch serverless collection. The collection type is VectorSearch. I have also defined all the security policies, like data access policies, encryption policy (Using KMS key),...
0
answers
0
votes
69
views
asked 8 days agolg...
My team is facing DDB throttling issue recently and we learned that [each partition on the table can serve up to 3,000 read request...
2
answers
0
votes
403
views
asked 8 days agolg...
An error occurred in RDSADMIN.RDS_FILE_UTIL when executing the following SQL during Oracle.
Could you please tell me the cause of the error and how to deal with it?
SQL statement:
> SELECT *
FROM...
1
answers
0
votes
132
views
asked 8 days agolg...
We have an existing ECS Cluster, and inside it, there's a service with a task definition container. The database host is stated in task definition. I created a new database, but now it is private (new...
3
answers
0
votes
211
views
asked 8 days agolg...
Hello AWS developers,
Please I would like to know, is migrating already existing RDS instances to IPV6 easy or complex?
If it's fairly easy, then please can I get an easy step by step...
1
answers
0
votes
128
views
asked 9 days agolg...
I have a situation where all attributes in a table are being deleted except for the PK and the attribute I did put against. After Python Lambda executes a put all attributes except for the OK and...
1
answers
0
votes
452
views
asked 9 days agolg...
I have created multiple databases, each database has its username and password. A secret is created in secretsmanager to store username and password for each database. Also RDS proxy is associated...
1
answers
0
votes
87
views
asked 9 days agolg...
Greetings,
We have been using only MS-CDC for ongoing replication and had the ECA IgnoreMSReplication turned on.
In order to determine the feasibility of using MS-REPLICATION as an alternative some...
1
answers
0
votes
208
views
asked 9 days agolg...
I am developing a real-time chat application using AWS Streaming APIs, Amazon Lex, Amazon Connect, etc. I need a functionality where if a customer does not reply within a specific time frame, their...
2
answers
0
votes
205
views
asked 9 days agolg...