Any edit of the transformation tables will delete and recreate the table from scratch except if all these conditions are met:
destination columns are unchanged
the query is unchanged
the destination table name is unchanged
the primary key is unchanged
In the transformation section, you have a status column for each transformation table.
VALIDATION: the table is not created yet, some checks are made to make sure everything is okay (loading time, …)
INACTIVE : no refresh scheduled for now, it is considered as up to date
WAITING: the transformation has to be preformed, but either the number of current transformation running is too high already to start (max concurrent transformation = 5), or there are some transformations that need to be performed first (if A is dependent on B, A will have the WAITING status until B is finished)
RUNNING: it is currently being refreshed
FAILURE: there is an issue, you might check the job logs to find out what happened.
You can see in the default folder a dashboard called “Job Logs”. It will enable you to make sure your transformation table is created and refreshed.
The action_code you need to check is UPDATE_TRANSFORMATION_TABLE.
The status can be either SUCCESS either FAILURE.
In case of failure, you can find the FAILURE MESSAGE to get more details