NB. All the fields will be considered as text. You can force the format into timestamp if you mention “timestamp” in the column name.
CAST(my_date as date) as this_is_my_date
In the transformation table, this_is_my_date will be under format “text”.
CAST(my_date as date) as this_is_my_date_timestamp
In the transformation table, this_is_my_date_timestamp will be under format “timestamp”.
Any edit of the transformation tables will delete and recreate the table from scratch.
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