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.
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
358
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
250
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
305
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
246
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
516
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
573
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
367
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
222
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
186
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
269
views
asked 3 months agolg...
I'm following the guide for analytic practice in here: https://aws.amazon.com/getting-started/hands-on/visualize-data-amazon-rds-sql-server-using-amazon-quicksight/?ref=gsrchandson&id=itprohandson
In...
1
answers
0
votes
178
views
asked 3 months agolg...
I have a running rds instance and here aws takes automated rds snapshots daily automatically and the retention period is one day. so in this case I have only latest snapshots but I need to get one...
1
answers
0
votes
222
views
asked 3 months agolg...