Skip to main content

Good 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.

we are on version 6698.1


Hi @Roy V 

I made a Zendesk ticket for this.


Hi @Roy V 

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.


Reply