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.
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
7
views
asked 19 minutes 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
55
views
asked 10 hours 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...
0
answers
0
votes
229
views
asked 5 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
147
views
asked 5 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
80
views
asked 6 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
56
views
asked 7 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
127
views
asked 7 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
81
views
asked 8 days 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...
0
answers
0
votes
230
views
asked 9 days 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
103
views
asked 11 days 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
122
views
asked 11 days agolg...
Hi Minds,
I have an use-case to stream data from Kafka to Redshift. My Kafkas are hosted in Kubernetes in a AWS account(Account B) and not using MSK, how do I stream that to my Redshift Managed...
0
answers
0
votes
90
views
asked 11 days agolg...