apache / apache/datafusion-sqlparser-rs

Redshift COPY Support

Open
#1,777 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

Redshift Copy SQL has multiple parameters that are not supported (for example Authorization parameter IAM_ROLE)

https://docs.aws.amazon.com/redshift/latest/dg/r_COPY-alphabetical-parm-list.html

```
COPY schema.table
FROM 's3://bucket-example/folder/file.csv'
IAM_ROLE 'arn:aws:iam::123456789012:role/my_iam_role'
DELIMTER ','
FORMAT AS CSV
GZIP
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the Rust SQL parser entry point for COPY statements and compare its supported parameters with the AWS Redshift COPY parameter list linked in the issue. Add coverage for IAM_ROLE and the other requested parameters shown by that comparison, then verify that the example statement parses successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, rust, sql
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.