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.
How do I add a sort / dist key to the glue dynamicframe writer into redshift?
1
answers
0
votes
192
views
asked 4 months agolg...
Hi,
when running an UNLOAD command on Amazon Redshift (or Redshift Serverless) with a SELECT statement attached to it.
Is the query benefiting the result caching mechanism available in Amazon...
1
answers
0
votes
165
views
asked 4 months agolg...
Hi,
I am trying to establish a connection between my desktop version of Power BI and my Provisioned Redshift cluster in the London Region but I receive a timeout error.
My cluster is publicly ...
2
answers
0
votes
209
views
asked 4 months agolg...
Hi there!
It was necessary for one user to restrict access to data in a table at the row level. I created an RLS policy and attached it to a role that is defined for only one user.
`CREATE RLS POLICY...
2
answers
0
votes
206
views
asked 4 months agolg...
Hello , I created datashare between serverless redshift workgroup and a provisioned redshift cluster ,
`
```
-- serverless
CREATE DATASHARE aggregated_tables
SET PUBLICACCESSIBLE = TRUE ;
ALTER...
2
answers
0
votes
385
views
asked 4 months agolg...
In a new pipeline we are adding to our product, we are collecting a bunch of data from different sources with something similar to keywords. The collected data is mainly text with associated metadata....
0
answers
0
votes
145
views
asked 4 months agolg...
Recently, I started using AWS Redshift to query my Apache Hudi format data. And Hudi's time travel query fit my business well. So I wonder if AWS Redshift support Hudi time travel query?
1
answers
0
votes
370
views
asked 4 months agolg...
Making a local invoke:
```shell
!sam local invoke "export-redshift-s3" --event event.json
```
Returns a 200 response, indicating the lambda function was correctly executed:
```shell
{"statusCode":...
3
answers
0
votes
294
views
asked 4 months agolg...
I am an admin of our Redshift cluster. Is there a way for me to view (unshared) queries that have been saved by my Redshift users - especially decommissioned ones? I am worried that following the...
1
answers
0
votes
314
views
asked 4 months agolg...
If a connect using query Editor V2 with IAM role, i am able to query catalog. But if i am trying to connect with database user, i am not able to do it.
Also how to i connect with a python client.
2
answers
0
votes
372
views
asked 4 months agolg...
We use the scheduler from Redshift query editor v2 to run a SP every 5 minutes. The SP typically completes in 1-2 minutes. Occasionally the SP takes > 5 minutes due to various reasons (CPU, I/O spike,...
4
answers
0
votes
521
views
asked 4 months agolg...
I need to optimize costs on my AWS account, and one of the things I want to do is to reserve a node for my redshift cluster. `dc2.large` instance is more than enough for me, however I am unable to...
1
answers
1
votes
2202
views
asked 4 months agolg...