Syntax Check for Snowflake

Toad Data Studio
1

Toad is reporting a syntax error for a Snowflake SQL but the syntax is correct:

image
image925×299 18.1 KB

Any suggestions for how I can correct the check or format the SQL to pass the check?

Thanks
Jack

2

Gotta ask... are you running the latest version of TDP? e.g. 6.2 at the moment...
If not, please upgrade and re-test, as there were quite a few fixes in the 6.1.x releases.

Also, make sure that there are no special (undisplayable) characters right after that comma in line 65.

Otherwise, if this SQL executes successfully against Snowflake in another app, please open a Support ticket.

3

This is Toad Data Studio - which is on version 1.0.023331

4

BTW, I've had similar issues with SnowFlake queries. I have found that most of these go away if I check the option to use quoted identifiers. See snap below... I wonder if that might help?

image
image737×538 52.4 KB

5

Thanks for the suggestion - I will give it a try.