One Star

tRedshiftUnload - Creates Empty Name S3 Object and Multiple Empty Files

Hi All,

Trying to figure out how to configure this tool further or if it is possible to do so.

I would like to prevent the tool from creating an empty name S3 Object regardless of what I put into the S3 Settings of the tool. My example shows that I am successfully creating content out on S3. But see the screenshots of my S3 Settings and the S3 buckets. I would like the tool to not create empty files or the empty directory name. My query in this sample returns 1 record of two fields. 

 

Any ideas?

 

 

1 REPLY
Ten Stars

Re: tRedshiftUnload - Creates Empty Name S3 Object and Multiple Empty Files

You can check number of rows (0 or more) before unload data

 

tRedshiftInput (schema - single column cnt (INTEGER) )

SELECT 
      CASE WHEN EXIT (SELECT .....) THEN
     1
ELSE
     0
END as cnt

than use runIf trigger

if row1.cnt == 1 -> Unload data

 

EXISTS work very fast - it stop work after first funded rows

-----------