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 created a Materialised view on Redshift on top of Kinesis Streaming Ingestion with Auto Refresh Yes I set the retention period of my Kinesis Data Stream to 1 day. Even after 2 days I can able to see...
1
answers
0
votes
478
views
asked 9 months agolg...
**How to install python packages dependencies which supports user defined package for Glue Spark job? **
For example, I have used redshift_connector package inside my custom package. In my Spark job,...
2
answers
0
votes
553
views
asked 9 months agolg...
While designing tables for Enterprise Data Warehouse (EDW), I found some instructions, for example https://docs.aws.amazon.com/redshift/latest/dg/c_designing-tables-best-practices.html. But, I concern...
1
answers
0
votes
423
views
asked 9 months agolg...
I want to set query_group when run statements using BatchExecuteStatement.
the batch sqls to run is
```
set query_group to 'group_label';
call sp_abc();
reset query_group;
```
sp_abc will call 2...
Accepted AnswerAmazon Redshift
1
answers
0
votes
244
views
asked 9 months agolg...
I have for example two tables with the same data.
```
CREATE TABLE version1 (
col1 INTEGER ENCODE AZ64,
col2 INTEGER ENCODE ZSTD,
);
CREATE TABLE version2 (
col1 INTEGER NOT NULL DEFAULT 0...
Accepted AnswerAmazon Redshift
2
answers
0
votes
695
views
asked 9 months agolg...
I created an external schema (for glue data catalog and subsequent s3 data) in Redshift Serverless using query editor v2.
For the IAM role I used 'SESSION' to make sure that all the users that are...
1
answers
0
votes
443
views
asked 9 months agolg...
Unable to install External python librarires(e.g.redshift_connector==2.0.913) in AWS Glue Spark Job through Job Parameters option "--additional-python-modules" .
1
answers
0
votes
392
views
asked 9 months agolg...
We have a DMS CDC task. Source Mongo, destination Redshift. It's been running fine for months.
When we stop and restart, several tables load, but others don't. There are no errors being logged in...
2
answers
0
votes
737
views
asked 9 months agolg...
1. I want to know whether redshift spectrum supports caching if yes how it could be useful in cost reduction. I know that redshift spectrum incur cost of about 5$ for TB of data scanning from S3. If...
1
answers
0
votes
456
views
asked 9 months agolg...
Is there some kind of way to tell AWS services like Step Functions, Glue, and Redshift to use UTC exclusively, and simply not display local time anywhere?
Time zone display in AWS is an indecipherable...
0
answers
0
votes
156
views
asked 9 months agolg...
Can I run Glue crawler on redshift data to identify if there is any new data inserted or updated in redshift?
2
answers
0
votes
296
views
asked 9 months agolg...
Our Redshift WLM is setup on Auto configuration, But when we are executing the same query directly on redshift, it is executing.
java.sql.SQLException: [Amazon](500310) Invalid operation: Cannot...
Accepted AnswerAmazon Redshift
1
answers
0
votes
618
views
asked 9 months agolg...