Questions tagged with Amazon Redshift
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 am using some syetem tables like svv_roles, svv_user_grants, svv_role_grants, SVV_ALL_SCHEMAS, SVV_SCHEMA_PRIVILEGES, etc. But as a regular user I am not able to see all the content which superuser...
3
answers
0
votes
63
views
asked a day agolg...
I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would...
1
answers
0
votes
32
views
asked a day agolg...
Hi
I am trying to make a Redshift serverless workgroup publicly accessible but I am unable to achieve this..
I have tried every article I've found
I've made an api gateway, which is inside a subnet...
3
answers
0
votes
51
views
asked 3 days agolg...
I have an application which uses Java JDBC Spring as a backend framework, I've connected my application to RDS MySQL I've tested the results it is able to provide the results faster but when I tested...
2
answers
0
votes
77
views
asked 8 days agolg...
Hello everyone,
I have an Amazon RDS database and want to set up an Amazon Redshift database. I need to replicate (migrate) data automatically from RDS to Redshift on a daily basis. How to achieve...
1
answers
0
votes
101
views
asked 8 days agolg...
Hi Experts,
I have a requirement to get data from SAP Datasphere to amazon redshift. can any of you guide me in how to do this? I read in a blog that we need to use amazon S3 for that, but I am...
1
answers
0
votes
485
views
asked 8 days agolg...
Details;
I am using adminetluser while connecting to the cluster. adminetluser is a super user and also the owner of the resultant table and the view that I am invoking refresh on.
I am using...
0
answers
0
votes
145
views
asked 9 days agolg...
I can't delete Redshift cluster.
Cluster identifier
us-tf-dbaws
Could you please remove it for me or stop the resizing process?
Accepted AnswerAmazon Redshift
1
answers
0
votes
137
views
asked 11 days agolg...
Hi Team,
I am trying to run SQL statements in Redshift by triggering using EventBridge on S3 file arrival. I am able to run SQLs using Data API but how ever I want to pass the event details to...
1
answers
0
votes
565
views
asked 11 days agolg...
I'm encountering an error when trying to create a Redshift cluster using an IAM user. The error message I receive is:
**InvalidParameterValue
Redshift cannot access the secret**
The IAM user...
1
answers
0
votes
127
views
asked 11 days agolg...
Hi,
I am facing an issue of Redshift default admin. Security hub reports: This control checks whether a Redshift cluster has changed the Admin username from its default value. This control will fail...
1
answers
0
votes
141
views
asked 14 days agolg...
I have a Redshift table with approx. 25 million records. I need to add a new column to it using ALTER TABLE ... ADD COLUMN ... but I'm finding this to be very slow.
Given RS is a columnar database,...
1
answers
0
votes
112
views
asked 15 days agolg...