Not updating data and not adding new fields

[PKPK90]

My script below, I just discovered that it is not updating my final SalesData and after adding some new columns to the code it is not available from the app and even it is not available to see in data load editor. There is not error during refresh.

SET ThousandSep=',';
...
LIB CONNECT TO 'Snowflake Dev:Snowflake DEV';

SalesData_NotClean:
SQL SELECT
ST.SALESID AS SALESID,
ST.SALESNAME AS SALESNAME,
ST.RESERVATION AS RESERVATION,
ST.CUSTACCOUNT AS CUSTACCOUNT,
ST.INVOICEACCOUNT AS INVOICEACCOUNT,
Date(ST.DELIVERYDATE) AS DELIVERYDATE_X,
ST.URL AS URL,
ST.PURCHORDERFORMNUM AS PURCHORDERFORMNUM,
ST.SALESGROUP AS SALESGROUP,
...

FROM
PROD.SRC.AXAPTA_SALESTABLE ST
JOIN
.....;

Concatenate(SalesData_NotClean)
SQL SELECT
ST.SALESID AS SALESID,
ST.SALESNAME AS SALESNAME,
ST.RESERVATION AS RESERVATION,
ST.CUSTACCOUNT AS CUSTACCOUNT,
ST.INVOICEACCOUNT AS INVOICEACCOUNT,
Date(ST.DELIVERYDATE) AS DELIVERYDATE_X,
ST.URL AS URL,
ST.PURCHORDERFORMNUM AS PURCHORDERFORMNUM,
ST.SALESGROUP AS SALESGROUP,
...

FROM
PROD.SRC.ONEAX_SALESTABLE ST
JOIN
...

SalesData:
LOAD
*,
Date(Floor(DELIVERYDATE_X), 'YYYY-MM-DD') AS DELIVERYDATE,
Date(Floor(FIXEDDUEDATE_X), 'YYYY-MM-DD') AS FIXEDDUEDATE,
....

RESIDENT SalesData_NotClean;

DROP TABLE SalesData_NotClean;

TAG FIELD DELIVERYDATE WITH '$date';
TAG FIELD FIXEDDUEDATE WITH '$date';
TAG FIELD RECEIPTDATEREQUESTED WITH '$date';
...

[rubenmarin]

Hi, first I would try to comment everything since "SalesData:", setting /* before that row, and cheking if the query is returning the expected data.

I don't see anything wrong after that "SalesData:" row... This sholuldn't do an autoconcatenation because of the new fields, but just in case you can try setting a NoConcatenate:

SalesData:
Noconcatenate LOAD