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 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
201
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
382
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
368
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
293
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
312
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
370
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
519
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
0
votes
2167
views
asked 4 months agolg...
I try to create a materialized view based on an external table in the glue data catalog.
Quering the Schema and tables of the data catalog work like expected. Also the creation of normal views...
1
answers
0
votes
345
views
asked 4 months agolg...
Hi,
I am considering Glue to connect to a third party application's database (Oracle) and bring a data set (in excess of 1M rows) obtained by joining multiple tables at source end. The destination...
1
answers
0
votes
361
views
asked 4 months agolg...
I am trying to read data from redshift schema_a and write its output into another redshfit table in schema_b. Below is the code I am using to read from...
3
answers
0
votes
403
views
asked 4 months agolg...