Empty Source DB to target, but inspect data is showing 1 null record

CloverDX Platform
1

I have a straightforward transformation. Customer table for example is empty in the backend (MS SQL Server) I just used select all in Customer table on DBExecute to DatabaseWriter, but in edge it showing 1 row of NULL values?

How to eliminate that? maybe filter or a configuration in DBExecute?

2

Yes, you can filter out the null values using the Filter component by using an expression similar to this:

!isnull($in.0.field1)

However, it is important to note that neither DBexecute nor DatabaseWriter are designed to execute SELECT statements. It is recommended to use DatabaseReader for SELECT statements which should not produce additional null records even if the source table is empty.

Regards,