I would like to the following script to be the transformation script:

SELECT
Genotyping_Original."participant id"
FROM study.Genotyping_Original as Genotyping_Original
WHERE NOT EXISTS
(
SELECT *
FROM genotype_etl.genotyping_original as GenoETL
WHERE
Genotyping_Original."participant id" = GenoETL."participant id"
)

However, it is always not giving me the correct results.

I think it's because there are two queries being referenced: study.Genotpying_Original and genotype_etl.genotyping_original . So it seems that it is not able to get information from genotype_etl.genotyping_original .

genotype_etl.genotyping_original is a schema and table that i create in the same transform.module package.

I look forward to your expertise.

Thanks,
Marcia