If condition to check number of rows without using Load RDS Data component

Matillion ETL
1

We would like to do a check if the table is empty (number of rows is 0) then load into it, otherwise, if the table contains data, then do not load into it.

How can we set a row count without using RDS Query?

 

2

Hi @farid.srouji​ you can use python script and update variable to check the table count. Then with help variable you can use it in if component and create a flow. If you need help with python script I can provide it.

3

Hi,

  1. Thank you for your advice.
  2. We solve this using Query Result To Scala.
  3. Python in Matillion is different, do you have such suggestion?

Thank you.

4

Yeah, using python in matillion make many things simple for sending mail with file from s3 like that.

 

5

if you need any help in things you can reach me out.

thank you