Support Snowflake SQL Pivot Command

Hi All,

a lot of new Snowflake commands do not work within the Query Console of the Database plugin.

The following SQL code snippet ist taken from
PIVOT | Snowflake Documentation
It works in Snowflake's IDE Snowsight, but not in Pycharm. 

I am using professional Edition version 2024.1..

Please note, that i know multiple other commands, that are not being executed or highlighted by Pycharm.
I would love, if Pycharm would do regular updates forthe  Snowflake SQL dialect.

 

 

CREATE OR REPLACE TEMP TABLE quarterly_sales(
  empid INT,
  amount INT,
  quarter TEXT)
  AS SELECT * FROM VALUES
    (1, 10000, '2023_Q1'),
    (1, 400, '2023_Q1'),
    (2, 4500, '2023_Q1'),
    (2, 35000, '2023_Q1'),
    (1, 5000, '2023_Q2'),
    (1, 3000, '2023_Q2'),
    (2, 200, '2023_Q2'),
    (2, 90500, '2023_Q2'),
    (1, 6000, '2023_Q3'),
    (1, 5000, '2023_Q3'),
    (2, 2500, '2023_Q3'),
    (2, 9500, '2023_Q3'),
    (1, 8000, '2023_Q4'),
    (1, 10000, '2023_Q4'),
    (2, 800, '2023_Q4'),
    (2, 4500, '2023_Q4');


SELECT *
  FROM quarterly_sales
    PIVOT(SUM(amount) FOR quarter IN (ANY ORDER BY quarter))
  ORDER BY empid;
0

I updated to the newest pycharm Version, still not working

 

PyCharm 2024.1.2 (Professional Edition)
Build #PY-241.17011.127, built on May 28, 2024

Subscription is active until December 31, 2024.
Runtime version: 17.0.11+1-b1207.24 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Windows 11.0
GC: G1 Young Generation, G1 Old Generation
Memory: 1970M
Cores: 8
Registry:
  ide.experimental.ui=true
Non-Bundled Plugins:
  com.godwin.json.parser (1.7.1)
  Key Promoter X (2024.1.0)
  com.intellij.plugins.vscodekeymap (241.14494.150)
  net.seesharpsoft.intellij.plugins.csv (3.3.0-241)
  Gitflow-Fix (0.7.13)
  izhangzhihao.rainbow.brackets (2024.2.3-241)
  com.github.dinbtechit.vscodetheme (1.10.10)
0
Hi Eric,

We have reported this issue here:

https://youtrack.jetbrains.com/issue/DBE-20895/Highlight-PIVOT-including-other-function-parameters-correctly

Please follow the ticket to stay updated on the progress.
1

请先登录再写评论。