I often find my development efficiency affected by lacking a good Grammar-checking tool during big data development. Common issues include:

• Missing commas, semicolons, or parentheses
• Omitting certain keywords within CASE WHEN statements
• Overlooking some keywords in nested queries
• ……

These problems become quite common once SQL statements get lengthy.

so I wanted a tool to provide an IDE-like experience while writing FlinkSQL. then I developed an IDEA plugin specifically for FlinkSQL.

Address: https://plugins.jetbrains.com/plugin/25912-flink-sql-helper

This plugin currently supports all statements of FlinkSQL version 1.20 Its main features include grammar checking, code formatting, and code completion.

Let me introduce the features of this plugin.

Grammar check

SQL Format

Code Completion Proposals

Refactorings

Finally, I will provide a one-month activation code(valid until December 31, 2024). I hope everyone enjoys using it:

• 88YTG-UYMBT-UAF7E-NZN48-MNBZ3
• 3H52G-Y33JM-Q9QS6-7KLBL-PY5QE
• FSQNR-UP5X7-6F5WN-M54YJ-QXEF8
• Z7FJJ-X2XS8-MB2FF-BG43S-M4QW2
• HDHYN-AEZSS-CFGC8-KAV2V-MXLAM