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'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
21
views
asked an hour 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
37
views
asked 3 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
20
views
asked 4 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
226
views
asked 9 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
116
views
asked 9 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
206
views
asked 11 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
114
views
asked 13 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
30
views
asked 14 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
40
views
asked 15 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
42
views
asked 15 days agolg...
Hello, I'm trying to connect to my Redshift Serveless, but I get the following error:
![Inserisci qui la descrizione dell'immagine](/media/postImages/original/IMmcBN2A5TS-SwtB4e0Yn8gw)
I'm using...
1
answers
0
votes
112
views
asked 17 days agolg...
What is Mac equivalent of ADFSCredentialsProvider when connecting to Redshift from SQLWorkbenchlg...
I am attempting to connect to Redshift from a Mac machine using SQLWorkbench. I am able to make the connection from a Windows machine by providing plugin_name as
```
plugin_name...
1
answers
0
votes
118
views
asked 17 days agolg...