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.
Which is the AWS API to use for retrieving data about oracle version if I've already found with DescribeDBInstances the engine version:
Engine Version = 19.0.0.0.ru-2022-10.rur-2022-10.r1
2
answers
0
votes
368
views
asked 2 months agolg...
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
393
views
asked 2 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
485
views
asked 2 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
337
views
asked 2 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
234
views
asked 2 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
283
views
asked 2 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
219
views
asked 2 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
462
views
asked 2 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
546
views
asked 2 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
351
views
asked 2 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
209
views
asked 2 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
172
views
asked 2 months agolg...