Questions in Analytics
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.
I'm trying to upgrade the mysql instance from 5.7.44 to 8 and up. I have a smaller scale "test" db with the same configuration as my production db. Last week I tried and managed to get the test side...
1
answers
0
votes
100
views
asked 9 days agolg...
Hi,
I am planning to use the Redshift Data API for running SQL commands on our Redshift cluster. I've looked through the AWS Redshift pricing page but couldn't find specific details about the costs...
1
answers
0
votes
94
views
asked 9 days agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
0
answers
0
votes
73
views
asked 9 days agolg...
Is it technically possible and secure to establish an ODBC connection to the RDS that is in the public subnet over the internet? I couldn't find AWS documentation regarding this question, so I would...
3
answers
0
votes
115
views
asked 9 days agolg...
I have created the QuickSight in ap-southeast-1 originally but there were some feature not available, thus closed the QuickSight in ap-southeast-1 and recreate in us-east-1.
But then all the weird...
3
answers
0
votes
132
views
asked 9 days agolg...
I have a client who has observed the following symptoms:
What could be the reason behind the intermittent variations in replication lag observed by a customer utilizing RDS Oracle with a read replica...
1
answers
0
votes
81
views
asked 9 days agolg...
Does the AWS/Redshift team have an update on when COPY JOB will be generally available? We have been anticipating it for over a year now, but it seems like the preview keeps being extended. Would it...
0
answers
0
votes
69
views
asked 9 days agolg...
I've attempted to connect multiple ways through multiple tools. According to the [AWS Aurora documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/database-authentication.html),...
1
answers
0
votes
136
views
asked 9 days agolg...
I have an EMR workspace under which I have 4 Jupyter notebooks created on which PySpark code blocks are run.
I want to get the last execution code block time across all 4 notebooks to determine the...
1
answers
0
votes
115
views
asked 9 days agolg...
Does cloudsearch support relative date range, similar to what opensearch has https://opensearch.org/docs/latest/query-dsl/term/range/#relative-dates
1
answers
0
votes
47
views
asked 9 days agolg...
I can access the RDS by ssh-ing into the EC2 instance, and passing the url and password to psql.
When I try to access the RDS via the docker container running on the EC2 using the same url and...
2
answers
0
votes
118
views
asked 10 days agolg...
I've been attempting to do an Aurora 2 to 3 in place upgrade on our database cluster and it refuses because of a routinesSyntaxCheck failure on some of our custom routines in our DB. There are indeed...
1
answers
0
votes
246
views
asked 10 days agolg...