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.
**Requirement**: Store geospatial data in Redshift and use Quicksight, allowing users to select various data layers for visualization on a base map.
Question 1: Is Redshift the optimal solution for...
1
answers
0
votes
96
views
asked 9 days agolg...
Hi All,
Before adding this question i have seen couple of responses for similar use cases but could not figure out the answers as im beginner in SQL coding. Im trying to query the table...
1
answers
0
votes
107
views
asked 9 days agolg...
I created an aurora-mysql8.0 DB instance parameter group. But I couldn't attach it to the DB instance (with mysql engine 8.0.35) in the same region.
Basically, when I "Modify" the instance, under the...
3
answers
0
votes
367
views
asked 10 days agolg...
In the Console, Create Parameter Group, I am creating an new Parameter group Using Engine Type: Microsoft SQL Server Standard Edition for Custom RDS, and Parameter Group Family:...
1
answers
0
votes
205
views
asked 10 days agolg...
IHAC running MSSQL 2016 SE in an AWS RDS instance, the customer application requires this permissions on the Master database: Create DB, create DB backup, “grant view”, any...
0
answers
0
votes
215
views
asked 10 days agolg...
Hi!
We've been trying to set up a pub/sub on RDS postgresql and it is failing with an error we were not able to understand.
Publisher is a Aurora postgresql 16.1 database, subscriber is also a...
1
answers
0
votes
355
views
asked 10 days agolg...
I've successfully used RDS Oracle EFS Integration using an EFS located in the same AWS Account as the RDS Database. However, I would like to be able to use an EFS created in another AWS Account under...
1
answers
0
votes
88
views
asked 11 days agolg...
Hello, I am relatively new to Glue and encountering some challenges with Glue ETL.
Our setup involves a datalake that retrieves data from a backend database as its source. This datalake is...
1
answers
0
votes
200
views
asked 11 days agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
58
views
asked 12 days agolg...
Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
1
answers
0
votes
130
views
asked 12 days agolg...
I've been getting a slew of INSUFFICIENT errors from CloudFront in the last week.
I'm attempting to use Athena to discover what is happening with these 5xx Error Rates. I have a database already...
3
answers
0
votes
99
views
asked 13 days agolg...
l have created a test mysql database but l am failing to connect using mysql navicat. l am getting this error.
2002 - Can't connect to server on...
1
answers
0
votes
180
views
asked 15 days agolg...