+3Good morning
I am deploying a specific table with history (mostly type2) to Snowflake.
However in the generated script the semicolumn is not placed correctly (after the ; some additional ‘and’ clauses are added). This results in an error creating the data cleansing procedure.
I added the script in the attachment.
Can you please have a look.
Best answer by Thomas Lind
Hi
This is a bug and will be fixed. In the meantime you can do the following to resolve it.
A workaround is to edit/modify the cleansing procedure and move the ‘;’ to the end of the WHERE clause.
You can read the customized code guide about where to do this.
+3we are on version 6698.1
+5Hi
I made a Zendesk ticket for this.
+5Hi
This is a bug and will be fixed. In the meantime you can do the following to resolve it.
A workaround is to edit/modify the cleansing procedure and move the ‘;’ to the end of the WHERE clause.
You can read the customized code guide about where to do this.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
