DEV Community

Cover image for Time-saver: This IDEA plugin can help you write SparkSQL faster
DogeKing
DogeKing

Posted on

Time-saver: This IDEA plugin can help you write SparkSQL faster

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 SparkSQL. then I developed an IDEA plugin specifically for SparkSQL.
Address: https://plugins.jetbrains.com/plugin/26079-spark-sql-helper

This plugin currently supports all statements of SparkSQL version 3.5 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:

  • A58DD-DC5DC-TG47Y-9HSRR-5ZFTE
  • XZ4F7-YQR42-LKP95–66TZ4-VUUT8
  • DLWMY-E863U-P99JC-TJDMB-W8EB5
  • K56NB-GV4SS-7GAXM-PURV4-PSKBL
  • RVL57-JQ2H3-FCJGJ-P4MK9-M4J74

Top comments (0)