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.
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
763
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
469
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
305
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
643
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
1250
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
315
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
504
views
asked 9 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
447
views
asked 10 months agolg...
The issue is related to the [recently introduced](https://aws.amazon.com/about-aws/whats-new/2023/07/amazon-redshift-qualify-clause-select-sql-statement/) QUALIFY clause.
For some reason QUALIFY does...
Accepted AnswerAmazon Redshift
1
answers
0
votes
668
views
asked 10 months agolg...
Hi all,
I have 2 AWS accounts (say staging ETL and staging redshift).
1. In the staging redshift account, I have set up a AWS Redshift Serverless workgroup+namespace
2. In the staging ETL account, I...
1
answers
0
votes
569
views
asked 10 months agolg...
Hello, we have an S3 bucket with various CSV files and an AWS Glue crawler to update the Data Catalog and finally an AWS Glue job to move the data to RedShift. The handling of data and target table is...
0
answers
0
votes
130
views
asked 10 months agolg...