Questions tagged with 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 am trying to fetch 0.5 million records at once using API->lambda. I am executing this using nodejs and while fetching records programmatically using SQL query my API times out as it redshift...
1
answers
0
votes
403
views
asked 3 months agolg...
Hello All!
Would like to Importing data from Amazon S3 into an RDS for PostgreSQL DB instance, but something is wrong from my side:
ERROR: HTTP -1. curlCode: 28, Timeout was reached
CONTEXT: SQL...
2
answers
0
votes
508
views
asked 3 months agolg...
In Amazon Redshift, the general syntax for creating a procedure is as follows:
```
CREATE [ OR REPLACE ] PROCEDURE sp_procedure_name
( [ [ argname ] [ argmode ] argtype [, ...] ] )
[ NONATOMIC...
2
answers
0
votes
352
views
asked 3 months agolg...
We have some Timestream tables of what I think you could call "metadata" to help us correspond data with devices, customers, etc. Here is an example of a table used to track our hardware...
1
answers
0
votes
244
views
asked 3 months agolg...
I am restoring a native on premise backup from a client into our AWS RDS SQL Server instance. In order to verify the TDE certificate was installed correctly, I attempted the restore without the...
2
answers
0
votes
297
views
asked 3 months agolg...
## Summary
- AWS released new data plane APIs for the Neptune Graph Database engine, in February 2024.
- The data plane APIs, such as **GetEngineStatus**, do not contain any input parameters to...
1
answers
0
votes
234
views
asked 3 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
504
views
asked 3 months agolg...
We are migrating from Redshift to Redshift Serverless to lower costs. I would like to have ongoing replication from RS to RS Serverless so that they are in sync and we can do blue/green rollout by...
2
answers
0
votes
565
views
asked 3 months agolg...
I moved my RDS to a private subnet. But now I cannot connect to the DB using pgadmin locally. What is the best practice to manage a RDS?
2
answers
0
votes
359
views
asked 3 months agolg...
Hello,
So I am currently working on a game REST API (node.js)and would like to know why does error with "Error retrieving data from database" appear and how can i fix it? I made research and tried...
2
answers
0
votes
218
views
asked 3 months agolg...
Does auto sortkeys option really help with good performance if i have unpredictable order by and join condition on table also if it helps does it incure more resources to shuffle the table every time...
1
answers
0
votes
181
views
asked 3 months agolg...
Good Day,
I am trying to following the instructions detailed here (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments.html) to update my MariaDB from Type R4 to R5...
1
answers
0
votes
261
views
asked 3 months agolg...