This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Cannot update incremental table due to EXECUTE IMMEDIATE procedure

Posted on 07-17-2023 11:57 PM
toyoshi
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Does anyone have same issue and know solution for this?

  • I get this message when I execute an incremental type sqlx file:  "reason:"invalidQuery" location:"query" message:"Syntax error: Illegal escape sequence: \\. at [144:44]": invalid argument"
  • I executed this sqlx file almost every day but I had never gotten this error until yesterday. (And I don't make any changes on since then)
  • I found that the error occurs inside EXECUTE IMMEDIATE procedure, which doesn't exist in my sqlx file but in "Query" log generated after execution. So I think it has something to do with some updates on dataform yesterday.
  • I don't get this error message when executing it with "Run with full refresh". And also I found that EXECUTE IMMEDIATE is not used for "Run with full refresh". So for sure there is something wrong with this procedure.

Dataform version : 2.6.0

3 5 767
Topic Labels
Reply
5 REPLIES 5