Can the SonarQube PL/SQL or T-SQL parser be used for the Redshift SQL dialect?

Env specifications:

Analyzing on SonarQube server 8.9.8
Java 11.0.11 AdoptOpenJDK (64-bit)
Linux 4.18.0-372.16.1.el8_6.x86_64 amd64

Query : We are attempting to scan a project based on the Redshift SQL dialect from SonarQube. Initially, the default PL/SQL scanner was used, but it only managed to scan a few views (2-3 SQL files out of 81). The majority of the files were not parsed by the scanner.

In an attempt to address this issue, I switched the parsing and tried using T-SQL. I made the following changes in the settings:

  1. For PL/SQL: Changed *.sql to *.plsql.
  2. For T-SQL: Changed *.tsql to *.sql,*.tsql.

As a result, more files were parsed this time. However, not all of the code was fully scanned, and numerous warnings were encountered while scanning database views and procedures.

WARN: Unable to parse file '/storedprocedures/applicant.sql' : Parse error at line 1 column 11:

 1: create or replace procedure mysch.sapplicant(inbatchdate date)
 2:     language plpgsql as

WARN: Unable to parse file '/src/views/summary.sql' : Parse error at line 3 column 11:

 1: -- noinspection AnnotatorForFile,Annotator
 3: create or replace view mysch.summary as

Please suggest how to tackle this situation. Is there any external plugin available which solve the purpose?

Thanks in advance.
Mohit M

Hi Mohit,

Sorry, but I’m not aware of any direct support for Redshift.


Thanks for your reply, Do you know if this is in the future roadmap?


I’m not aware of any plans, either.