IntelliJ IDE does not recognize some task/procedure functionality in Snowflake
The $$ and BEGIN is used in procedures and tasks, but in Datagrip and Pycharm (the ones I've tested) the $$ is treated as a commenting function, making all code as comment instead of actual code.
This disables the use of automatic code formatting for procedures, making the code a lot harder to interpret/read.
Example where $$ comments out following code:
When commenting out $$:
Commenting out $$ does enable code interpretation, but then issues with the BEGIN command remains.
The interpreter dialect is set to Snowflake
请先登录再写评论。
https://youtrack.jetbrains.com/issue/DBE-22254/Support-syntax-highlighting-inside-code-block
https://youtrack.jetbrains.com/issue/DBE-15998/Create-procedure-returns-EOF-error-for-BEGIN-END-statements
https://youtrack.jetbrains.com/issue/DBE-21925/Snowflake-create-procedure-syntax
Yes, they are related (but not entirely the same in detail) to the same operations. Are there any plans on fixing this in a future release? I could not see any indications of such from the reported issues you are referring to.
Kristian
Ok. Thank you!