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
123
views
asked 16 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
129
views
asked 17 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
581
views
asked 17 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
217
views
asked 17 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
219
views
asked 17 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
770
views
asked 18 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
105
views
asked 18 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
220
views
asked 19 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
70
views
asked 19 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
161
views
asked 20 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
108
views
asked 20 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
197
views
asked 23 days agolg...