Questions tagged with Database

Benefit from the broadest selection of purpose-built databases for all your application needs

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.

1692 results
I am building a data warehouse which will ingest data from source databases (self hosted on ec2 and RDS) hosted in multiple VPCs. What is the best way to access the source databases in different VPCs...
Accepted AnswerAmazon VPCDatabase
2
answers
0
votes
40
views
AWS
asked 9 days ago
#### **Issue Summary** We are experiencing an issue with our AWS RDS PostgreSQL database (Postgres version 16 upgraded to 17 a while ago - likely when the problem started) where rows in a specific tab...
2
answers
0
votes
38
views
profile picture
asked 9 days ago
What are the conditions that cause private IP address changes in Amazon RDS? The following site explains the conditions under which RDS IP addresses can change: https://repost.aws/knowledge-center/rd...
1
answers
0
votes
30
views
asked 11 days ago
I want to create an external table to copy s3 data int htat table for the use of redshift spectrum. The specified location includes parquet and mp4 files. I only want to copy the parquet files. And ...
2
answers
0
votes
23
views
asked 16 days ago
Hi all, I have created foreign data wrappers for both RDS PostgreSQL and RDS SQL Server databases and can successfully read from these, so my issue does not relate at all to the connections here. Wha...
1
answers
0
votes
48
views
asked 17 days ago
we have a manufacturing client and they have 20 distributors. Each of them needs to have inventory and financial accounting management ERP. So we need to keep a separate Database for them. In the f...
1
answers
0
votes
25
views
asked 18 days ago
I have an RDS Oracle reserved instance (1 yr, all upfront) with db.r5.8xlarge class. I want to downgrade it to db.r5.4xlarge due to less usage during the next renewal. Can I upgrade it back to db.r5.8...
2
answers
0
votes
35
views
asked 18 days ago
i need to do beginsWith on the account and folder hierarchy paths. Example: accountHierarchyPath: account1#account2#account3 pageHierarchyPath: folder1#folder2#folder3 i would like to do beginsWith a...
1
answers
0
votes
22
views
asked 20 days ago
I have a temporary table created with a name based on a numeric ID. This table is sometimes created with a 0 as the leading character of the digits in the table name such as: "schema_name"."tmp_012345...
1
answers
0
votes
26
views
asked 22 days ago
I have created RDS instance which has public access but unable to connect it using pgAdmin, I have attached security group which has port 5432 open, getting connection timeout issue message in pgAdmin...
1
answers
0
votes
52
views
asked 22 days ago
I have created a DMS task that replicated a table along with changes to S3 - but the CDC files lack the column name. I have the AddColumnName set to true, and my initial table load file has the column...
3
answers
0
votes
39
views
asked 22 days ago
Hi, I am a total newbie to DocumentDB or MongoDB. Unfortunately, need to check on everything that get send my way :-) One of our clients thinks the DocumentDB is 'bloated', fragmented or has lots of ...
1
answers
-1
votes
44
views
asked 23 days ago