Skip to main content
Solved

Error deploying historic table to Snowflake

  • September 9, 2024
  • 3 replies
  • 40 views

Roy V
Problem Solver
Forum|alt.badge.img+2
  • Problem Solver
  • 56 replies

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.

Best answer by Thomas Lind

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.

View original
Did this topic help you find an answer to your question?

3 replies

Roy V
Problem Solver
Forum|alt.badge.img+2
  • Author
  • Problem Solver
  • 56 replies
  • September 9, 2024

we are on version 6698.1


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • September 9, 2024

Hi @Roy V 

I made a Zendesk ticket for this.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • September 10, 2024

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings