sabir-akhadov-localstack opened a new pull request, #2474:
URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2474
Snowflake's `ALTER EXTERNAL VOLUME` did not parse:
```sql
ALTER EXTERNAL VOLUME my_vol ADD STORAGE_LOCATION = (
NAME = 'loc2' STORAGE_PROVIDER = 'S3' STORAGE_BASE_URL =
's3://bucket2/');
ALTER EXTERNAL VOLUME my_vol SET ALLOW_WRITES = TRUE;
ALTER EXTERNAL VOLUME my_vol REMOVE STORAGE_LOCATION 'loc1';
```
This adds an `AlterExternalVolume` statement with the three documented
operations (`ADD STORAGE_LOCATION`, `SET ALLOW_WRITES`, `REMOVE
STORAGE_LOCATION`). The added storage location reuses the same generic
`KeyValueOptions` parsing as `CREATE EXTERNAL VOLUME`. All statements
round-trip.
See the [Snowflake `ALTER EXTERNAL VOLUME`
docs](https://docs.snowflake.com/en/sql-reference/sql/alter-external-volume).
Split out of #2397 per review feedback, alongside the CREATE/DROP (#2397),
DESC (#2472), and SHOW (#2473) PRs.
**Stacked on #2397** (it reuses the storage-location parsing helper
introduced there) — only the last commit is new. Kept as a draft until #2397
merges, then it will be rebased.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
