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.
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
216
views
asked 19 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
336
views
asked 21 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
202
views
asked 23 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
104
views
asked 23 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
126
views
asked 25 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
95
views
asked 25 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
124
views
asked a month 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
130
views
asked a month 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
111
views
asked a month agolg...
I need to find the difference between two timestamp range. I tried using DATEDIFF but not getting the exact result. Below is the query I am using:
```
select
rtrim(datediff(hour,'2024-05-15...
1
answers
0
votes
311
views
asked a month agolg...
I've been trying to test out Iceberg tables with Amazon Redshift Spectrum and have come across a major issue.
Here is my setup:
1. I create an iceberg table via spark (emr 7.0) and insert data across...
0
answers
1
votes
485
views
asked a month agolg...
when I followed this document https://docs.amazonaws.cn/en_us/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-plugin_name-option to connect redshift with IdpTokenAuthPlugin, I got an...
0
answers
0
votes
421
views
asked a month agolg...