I'm trying to run a Talend Cloud Data Preparation from the Talend Studio, and I obviously need to specify an output. The reason for running it in studio is because I cannot find a way to schedule a dataprep in Talend Cloud?
Anyways; when we DO specify an output in Studio (Snowflake in this case), I see that the schema on the tDataPrepRun block has completely disregarded all datatypes on the table, so now they are all strings. This means that when the table lands in Snowflake, it's all VARCHAR's. Which will not be good enough.
I cannot use a custom schema in between either, because then Studio just complains that "cannot convert string to int" (or whatever datatype). Not even a compliance check forces it.