Questions tagged with Amazon Redshift
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale.
Content language: English
Filter questions
Select tags to filter
Sort by
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
1095 results
Redshift currently does not support the named windows SQL syntax, where it's possible to define a common window definition for multiple windowing functions like so:
```sql
SELECT
sum(amount) OVE...
On the case, but not limited to this origin:
Origin: Aurora-postgres
Destination: Redshift
When a varchar/nvarchar length changes in the source table, it does not get applied to Redshift; it appears o...
1
answers
0
votes
69
views
asked 2 months ago
A table with approximately 1,000 rows and a primary key has been stuck in **ResyncInitiated** state for over 2 hours after triggering a refresh via `ALTER DATABASE INTEGRATION REFRESH TABLE`.
T...
3
answers
0
votes
113
views
asked 2 months ago
As Python UDF support is getting deprecated in AWS redshift, I moved a simple python UDF function into a lambda function, and setup the lambda UDF as follows (on our serverless redshift cluster)
```
...
2
answers
0
votes
87
views
asked 2 months ago
The [Unsupported PostgreSQL Functions](https://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html) page lists **IS DISTINCT FROM** as unsupported. However, it appears to wo...
1
answers
0
votes
119
views
asked 2 months ago
We are running DMS replication from **Aurora PostgreSQL 15.x** to **Redshift Provisioned (RA3)** in `eu-central-1`. After the Redshift maintenance update to **v1.0.232773 (patch 199)** on March 8, 202...
6
answers
4
votes
533
views
asked 3 months ago
I have a AWS Glue flow, my objective is to transfer data from Bigquery (using custom query) to Redshift. But following error keep exist.
*Error Category: UNCLASSIFIED_ERROR; Failed Line Number: 17; An...
1
answers
0
votes
40
views
asked 3 months ago
Seeking Guidance for JSON ingestion into AURORA?
======================================
I appreciate you looking over my query. This question pertains to the AWS AURORA environment, and I'm asking it...
2
answers
0
votes
70
views
asked 3 months ago
안녕하세요. 아래 메일 내용에 따라 인스턴스 타입을 dc2.large에서 ra3.large로 업그레이드를 진행했습니다.
그런데 몇달이 지나도록 크레딧을 받지 못하고 있습니다.
메일에 기재된 링크에 들어가도 회의에 초대받지 못하고 계속 대기만 하고 있습니다.
지난 답변에서 계약된 파트너사에 문의해보라고 하셨는데 파트너사에서도 aws측에 연락이 닿지 않고 있다...
1
answers
0
votes
37
views
asked 3 months ago
When I query the table which was created using zeroETL and is still syncing, the distinct keyword is not working as exepcted.
SELECT id FROM tabl1 where id =1234;
Above returns 2 records:
1234
1234
...
2
answers
0
votes
83
views
asked 3 months ago
When querying 1.8 million rows of data using Redshift Spectrum and using group by, the returned number of rows are far less than when querying with MySQL (RDS). I think its related to how Redshift usi...
3
answers
0
votes
57
views
asked 3 months ago
Hi everyone,
I'm facing a severe issue with Amazon Redshift where the cluster gets stuck forever in “computing next steps”, even after killing all user queries.
**Context**
* 2-node RA3 cluster
* A...
1
answers
0
votes
138
views
asked 4 months ago