Amazon Redshift SQL Parser Support in GSP¶
Explore the Amazon Redshift SQL Parser product page
This page documents the SQL syntax support for Amazon Redshift in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests Redshift syntax against 90 documented constructs grouped into 10 categories, each cross-referenced to the documentation that defines it (87 distinct source pages).
Parse coverage¶
Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Redshift documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.
| Constructs fully parsed | Individual statements parsed | |
|---|---|---|
| All constructs | 88 of 90 (98%) | 148 of 150 (99%) |
| SELECT (queries) | 17 of 17 (100%) | 22 of 22 (100%) |
| DML (INSERT / UPDATE / DELETE / MERGE) | 3 of 3 (100%) | 6 of 6 (100%) |
| Stored procedures | 3 of 3 (100%) | 3 of 3 (100%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.
Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview
All 90 constructs¶
| Construct | Category | Parses | Specified in |
|---|---|---|---|
CANCEL |
all 1 | AWS docs | |
CLOSE |
all 1 | AWS docs | |
COMMENT |
all 3 | AWS docs | |
COMMIT |
all 3 | AWS docs | |
COPY |
all 2 | AWS docs | |
DECLARE |
all 1 | AWS docs | |
DELETE |
all 3 | AWS docs | |
DESC DATASHARE |
all 2 | AWS docs | |
INSERT |
all 1 | AWS docs | |
PREPARE |
all 2 | AWS docs | |
REFRESH MATERIALIZED VIEW |
all 1 | AWS docs | |
RESET |
all 2 | AWS docs | |
ROLLBACK |
all 1 | AWS docs | |
SELECT INTO |
all 2 | AWS docs | |
SET |
all 2 | AWS docs | |
SET SESSION AUTHORIZATION |
all 3 | AWS docs | |
SHOW |
all 1 | AWS docs | |
TRUNCATE |
all 1 | AWS docs | |
UNLOAD |
all 1 | AWS docs | |
UPDATE |
all 2 | AWS docs | |
VACUUM |
all 2 | AWS docs | |
ALTER DATABASE |
ALTER | all 2 | AWS docs |
ALTER DATASHARE |
ALTER | all 3 | AWS docs |
ALTER DEFAULT PRIVILEGES |
ALTER | 2 of 3 | AWS docs |
ALTER GROUP |
ALTER | all 2 | AWS docs |
ALTER MATERIALIZED VIEW |
ALTER | all 1 | AWS docs |
ALTER PROCEDURE |
ALTER | all 2 | AWS docs |
ALTER SCHEMA |
ALTER | all 4 | AWS docs |
ALTER TABLE |
ALTER | all 2 | AWS docs |
ALTER TABLE APPEND |
ALTER | all 2 | AWS docs |
ALTER USER |
ALTER | all 3 | AWS docs |
ANALYZE COMPRESSION |
ANALYZE | all 1 | AWS docs |
CREATE DATABASE |
CREATE | all 2 | AWS docs |
CREATE DATASHARE |
CREATE | all 1 | AWS docs |
CREATE EXTERNAL FUNCTION |
CREATE | all 1 | AWS docs |
CREATE EXTERNAL SCHEMA |
CREATE | all 2 | AWS docs |
CREATE EXTERNAL TABLE |
CREATE | all 1 | AWS docs |
CREATE FUNCTION |
CREATE | all 1 | AWS docs |
CREATE GROUP |
CREATE | all 1 | AWS docs |
CREATE LIBRARY |
CREATE | all 2 | AWS docs |
CREATE MATERIALIZED VIEW |
CREATE | all 1 | AWS docs |
CREATE MODEL |
CREATE | all 1 | AWS docs |
CREATE PROCEDURE |
CREATE | all 1 | AWS docs |
CREATE SCHEMA |
CREATE | all 3 | AWS docs |
CREATE TABLE |
CREATE | all 2 | AWS docs |
CREATE USER |
CREATE | all 2 | AWS docs |
CREATE VIEW |
CREATE | all 2 | third-party reference |
CREATE TABLE AS |
CREATE TABLE | all 2 | AWS docs |
ANALYZE |
DDL | all 4 | AWS docs |
BEGIN |
DDL | all 2 | AWS docs |
CALL |
DDL | all 1 | AWS docs |
DEALLOCATE |
DDL | all 1 | AWS docs |
DROP FUNCTION |
DDL | all 2 | AWS docs |
END |
DDL | all 3 | AWS docs |
EXECUTE |
DDL | 0 of 1 | AWS docs |
EXPLAIN |
DDL | all 1 | AWS docs |
FETCH |
DDL | all 1 | AWS docs |
GRANT |
DDL | all 2 | AWS docs |
LOCK |
DDL | all 1 | AWS docs |
REVOKE |
DDL | all 3 | AWS docs |
ABORT |
DML | all 1 | AWS docs |
SELECT |
DML | all 1 | AWS docs |
DROP DATABASE |
DROP | all 1 | AWS docs |
DROP GROUP |
DROP | all 1 | AWS docs |
DROP LIBRARY |
DROP | all 1 | AWS docs |
DROP MATERIALIZED VIEW |
DROP | all 1 | AWS docs |
DROP MODEL |
DROP | all 1 | AWS docs |
DROP PROCEDURE |
DROP | all 1 | AWS docs |
DROP SCHEMA |
DROP | all 4 | AWS docs |
DROP TABLE |
DROP | all 2 | AWS docs |
DROP USER |
DROP | all 3 | AWS docs |
DROP VIEW |
DROP | all 1 | AWS docs |
SELECT Correlated subqueries |
SELECT | all 1 | AWS docs |
SELECT DISTINCT |
SELECT | all 2 | AWS docs |
SELECT EXCEPT |
SELECT | all 1 | AWS docs |
SELECT FROM |
SELECT | all 1 | AWS docs |
SELECT GROUP BY |
SELECT | all 1 | AWS docs |
SELECT HAVING |
SELECT | all 1 | AWS docs |
SELECT INTERSECT |
SELECT | all 2 | AWS docs |
SELECT JOIN |
SELECT | all 1 | AWS docs |
SELECT ORDER BY |
Select | all 2 | AWS docs |
SELECT Subquery |
SELECT | all 1 | AWS docs |
SELECT TOP |
SELECT | all 2 | AWS docs |
SELECT UNION |
SELECT | all 1 | AWS docs |
SELECT UNION ALL |
SELECT | all 1 | AWS docs |
SELECT WHERE |
SELECT | all 1 | AWS docs |
SELECT WITH |
SELECT | all 1 | AWS docs |
SHOW DATASHARES |
SHOW | all 2 | AWS docs |
SHOW MODEL |
SHOW | all 1 | AWS docs |
SHOW PROCEDURE |
SHOW | all 1 | AWS docs |
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- Redshift-specific functions and data types
- Distribution and sort key specifications
- Window functions and analytical queries
- COPY and UNLOAD operations
- Stored procedures and user-defined functions