Hello Team, I am trying to use a merge statement to merge data from the glue catalog to redshift tabes. The requirement is to merge records and have a filter clause For example: Here where the clause does not work MERGE INTO target_table USING WHERE source_table.column = 'value' ON ... -------------------------------------------- I also tried using and as a predicate but it merged the record with id 0001230 MERGE INTO TARGET TABLE USING #temp_table src ON TARGET.id = src.id and src.id != '0001230' WHEN MATCHED THEN UPDATE SET how should I add a filter in the merge statement?

MERGE Statement with FILTER

Hello Team, I am trying to use a merge statement to merge data from the glue catalog to redshift tabes. The requirement is to merge records and have a filter clause

For example: Here where the clause does not work MERGE INTO target_table USING <glue catalog table - which gets copied into temp table> WHERE source_table.column = 'value' ON ...

I also tried using and as a predicate but it merged the record with id 0001230

MERGE INTO TARGET TABLE USING #temp_table src ON TARGET.id = src.id and src.id != '0001230' WHEN MATCHED THEN UPDATE SET

how should I add a filter in the merge statement?

주제

분석

태그

AWS Glue 아마존 Redshift

언어

English

rePost-User-5744318

질문됨 3달 전138회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hi,

Currently Redshift MERGE statements do not allow for the source table to be a view, subquery, or CTE (created by a WITH statement). If you need to perform some filtering on the source table before applying the MERGE you will need to create a permanent or temporary table to be used as the source.

Alternatively you can use UPDATE and INSERT statements.

전문가

Sean Beath

답변함 3달 전

-1

I would just use a WITH clause before the merge to filter the source table before the merge.

전문가

Gonzalo Herreros

답변함 3달 전

MERGE Statement with FILTER

관련 콘텐츠