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

SonarQube
,
1

Env specifications:

Analyzing on SonarQube server 8.9.8
SonarScanner 4.6.2.2472
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
 2: 
 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

2

Hi Mohit,

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

 
Ann

3

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

4

Hi,

I’m not aware of any plans, either.

 
Ann