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 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
48
views
asked 18 hours 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
119
views
asked a day 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
46
views
asked a day 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
49
views
asked 4 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
30
views
asked 5 days agolg...
Hi Team,
I am working on building a Data Architecture that will enable end customers to view the data through a frontend UI and also the internal users to query and play with the data in the...
2
answers
0
votes
237
views
asked 10 days agolg...
When creating the temporary table to perform the MERGE in Redshift, I get the error "**String length exceeds DDL length.**" I am using visual ETL. How can I make Redshift use the maximum length for a...
2
answers
0
votes
126
views
asked 10 days agolg...
When I was trying to create external schema, there is an error of unauthorization.
```
create external schema eth
from data catalog
database 'eth'
iam_role...
1
answers
0
votes
228
views
asked 12 days agolg...
Hi,
I’m experiencing high CPU usage after creating a Redshift cluster of the RA3 type, which has 2 nodes.
The cluster is about a terabyte in size and was created from a snapshot.
Now, the CPU usage...
Accepted AnswerAmazon Redshift
2
answers
0
votes
124
views
asked 14 days agolg...
I have two materialized views in redshift.
The first uses an outer join, and thus is not eligible for incremental refresh. We'll call this lookup_view.
The second view joins lookup_view to another...
0
answers
0
votes
40
views
asked 15 days agolg...
ERROR: function convert_timezone("unknown", "unknown", timestamp with time zone) does not existlg...
I have a column with datatype "timestamp with time zone" in UTC. I want to convert it to EST while accounting for daylight savings time. If we call the column [col1], I have tried the query as...
1
answers
0
votes
50
views
asked 16 days agolg...
Hi.. in case of using redshift multi AZ cluster, Is it possible to run a scheduled query on cluster maintanence time ?
1
answers
0
votes
54
views
asked 16 days agolg...