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 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
730
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
471
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
404
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
772
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
473
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
157
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
311
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
645
views
asked 9 months agolg...
I am using Amazon Redshift database, version is PostgreSQL 8.0.2.
I am implementing a functionality which needs to get all session details.
In PostgreSQL, running the query **SELECT * FROM...
2
answers
0
votes
1265
views
asked 9 months agolg...
This question relates to AWS Redshift and permissions. Currently, for [views](https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_VIEW.html) in Redshift, permissions to underlying tables in the...
2
answers
0
votes
316
views
asked 9 months agolg...
Getting error from Athena Redshift connector "Error: Runtime exited with error: signal: killed"lg...
Lambda dies after 25-30 seconds with no other messages than "Error: Runtime exited with error: signal: killed". Attempted to expand memory and storage limits for Lambda to the max, no luck. Please...
1
answers
0
votes
518
views
asked 10 months agolg...
Hi there,
I need help,
We are loading tables from glue data catalogs into a Redshift Serverless with 8 RPUs.
All works ok with small tables, but when we try with a 1.5 million records tables (like 300...
1
answers
0
votes
449
views
asked 10 months agolg...