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.
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
36
views
asked 2 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 3 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
218
views
asked 7 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
111
views
asked 7 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
203
views
asked 10 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
113
views
asked 12 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 12 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
39
views
asked 14 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 14 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
111
views
asked 16 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
117
views
asked 16 days agolg...
I have changed the Maximum query execution time on my Redshift Serverless and it is in Modifying status for hours. Is this the expected behavior? Is there something I can do/look into? Thank you in...
1
answers
0
votes
95
views
asked 16 days agolg...