Do you know the History of Data Science? READ MORE

Problem using TRUNCATE or WRITE_TRUNCATE with Dataïku

AurélienB
Level 1
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 

0 Kudos
1 Reply
KeijiY
Dataiker
Dataiker

Hello,

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

0 Kudos
A banner prompting to get Dataiku DSS