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.
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
301
views
asked 20 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
456
views
asked 20 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
407
views
asked 20 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
83
views
asked 22 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
406
views
asked 22 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
88
views
asked 22 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...
2
answers
0
votes
277
views
asked 24 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
381
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
149
views
asked a month 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...
1
answers
0
votes
132
views
asked a month agolg...
I have created Redshift data source from Athena Console using Lambda Connector.
while giving configurations in Lambda connector, we need to give Redshift JDBC URL which is supporting the following...
1
answers
0
votes
175
views
asked a month agolg...
Hi All,
Before adding this question i have seen couple of responses for similar use cases but could not figure out the answers as im beginner in SQL coding. Im trying to query the table...
1
answers
0
votes
382
views
asked a month agolg...