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.
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
660
views
asked 10 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
1301
views
asked 10 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
327
views
asked 10 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
549
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
458
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
701
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
585
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
132
views
asked 10 months agolg...
Hi,
We are experiencing a bug where materialized views are pulling in 'old' data that does not match the query syntax after refreshing on a schedule for ~4 months.
**Context**
We have a set of...
1
answers
0
votes
265
views
asked 10 months agolg...
Hi,
I'm using Redshift Serverless for the first time and would like to know if (like redshift cluster), we can pause and restore the cluster.
Regards,
Accepted AnswerAmazon Redshift
2
answers
0
votes
688
views
asked 10 months agolg...
There is a known bug in json_extract_path_text spelled out at https://stackoverflow.com/a/76303424. Why has it not been fixed?
1
answers
1
votes
223
views
asked 10 months agolg...
IHAC who is building its analytical platform on Redshift. One of their data source is Oracle RDS and they tend to replicate all the data and change of its 900 table to Redshift. The initial design...
1
answers
0
votes
369
views
asked 10 months agolg...