Invalid Syntax with SnowFlake lIve Connect

Fred Rahmanian

• July 20, 2020 04:06

We are using live connect with SnowFlake and on some of the queries we see the following error

SQL compilation error: syntax error line 1 at position 7,920 unexpected 'limit'.

Looking at the query generated it contains ' LIMIT 5000 OFFSET 0 limit 0' at the end of the query

Any idea why it is generating bad SQL? 

TIA,

FR

1

• 

  Limor Fledel

  • July 21, 2020 20:31
  • Edited

  Hello Fred,

  Could you please submit a ticket through https://www.sisense.com/support/ so we will help you to resolve this case?

  Thanks in advance,

  Limor

  0

Please sign in to leave a comment.