I run an automation task that incudes a 'Create table as select...' statement, however the automation log is showing 0 rows.
The 0 rows returned is because the statement is a DDL statement not a query i.e. CREATE, DROP etc
To show how many rows have been added as part of the CREATE TABLE ... AS SELECT you can add an additional statement to the script i.e.
Select * from tablename
This will display the number of rows in the log.