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’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...
0
answers
0
votes
84
views
asked 2 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
15
views
asked 2 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
21
views
asked 4 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
25
views
asked 4 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
73
views
asked 6 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...
0
answers
0
votes
96
views
asked 6 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
75
views
asked 6 days 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
261
views
asked 11 days 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
200
views
asked 11 days 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
258
views
asked 11 days agolg...
**Question:**
To whom it may concern,
We have encountered a discrepancy in the behavior of result cache management between Amazon Redshift provisioned clusters and Redshift Serverless instances. Our...
1
answers
0
votes
70
views
asked 12 days agolg...
I got the error when write glue dynamic data frame to redshift table .
The code I have used :-
my_conn_op={
"dbtable":"public.xxxx",
...
0
answers
0
votes
152
views
asked 13 days agolg...