Problem using TRUNCATE or WRITE_TRUNCATE with Dataïku
Hello,
I face a problem when running my SQL scenario step with a "TRUNCATE" sql statement.
Please find attached the sql code with my truncate statement (in scenario step) & the error message.
Does that mean that "TRUNCATE" statement is not supported in a step of "execute sql" scenario?
Thanks in advance for your answer
Answers
-
Keiji Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 52 DataikerHello,
I executed the similar SQL for truncating and inserting in my environment, but I successfully executed the SQL and I could not reproduce the error you are facing.
As we need more information to investigate the error, could you please open a support ticket by sending an email to support@dataiku.com with your scenario’s diagnosis logs which can be downloaded by clicking the “Download diagnosis” link on the “Last runs” tab of the “Scenarios” page on DSS.
By the way, if your table is registered and managed as a dataset you can use the “Clear” step for clearing your table’s data instead of writing a TRUNCATE statement in the “Execute SQL” step. This way would make your scenario simpler. Could you elaborate your use case so that we can find other options to achieve your goals efficiently?
Best regards,
Keiji