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.
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
115
views
asked 18 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
120
views
asked 18 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
101
views
asked 18 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
304
views
asked 23 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
471
views
asked 23 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
409
views
asked 24 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
89
views
asked 25 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
428
views
asked 25 days agolg...
I need to union together the results of two queries - we'll call them Query A and Query B. Their outputs have matching column structures and data types, so nothing special should need to be done to...
0
answers
0
votes
89
views
asked a month agolg...
I am trying to set-up a Redshift connection using dBeaver CE. I am trying to use the Configuration file option as described in the linked [AWS Doc Using a Configuration...
2
answers
0
votes
293
views
asked a month agolg...
**Requirement**: Store geospatial data in Redshift and use Quicksight, allowing users to select various data layers for visualization on a base map.
Question 1: Is Redshift the optimal solution for...
1
answers
0
votes
384
views
asked a month agolg...
Hello world!
Is it possible to Enable or Disable Scheduled queries through aws cli (powershell) or python? I know about Query editor v2, but I need to automate this task.
1
answers
0
votes
153
views
asked a month agolg...