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.
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
306
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
321
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
395
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
533
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
2301
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
384
views
asked 5 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
367
views
asked 5 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
426
views
asked 5 months agolg...
not able to drop the group in redshift database facing the error
group "XXXX" cannot be dropped because permission dependency is found
3
answers
0
votes
352
views
asked 5 months agolg...
The Zero ETL Integration for replicating data to Redshift from Aurora PostgreSQL is currently in "Preview", as [this post specifies...
1
answers
0
votes
272
views
asked 5 months agolg...
Hello,
Currently SCT doesn't support Redshift as target with Db2 LUW as source database. Could you share what solutions are available for schema conversion for Redshift?
0
answers
0
votes
166
views
asked 5 months agolg...
Hi,
Last weekend 20/01/2024, after automatic maintenance upgrade of our provisioned redshift cluster (in eu-west-1a) to version 1.0.61678, all our LOAD commands started to fail. Also queries to...
1
answers
0
votes
239
views
asked 5 months agolg...