Parquet Reader Supports AWS S3 Region-Specific Bucket URLs
Details
| Detail name | Value |
|---|---|
| Changelog Number | 27065 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 2025.1.0 |
| Fix Versions | Exasol 2025.1.3, Exasol 2025.2.0 |
| Resolution Date | 2025-09-17 |
Description
The Parquet Reader fails to read files from AWS S3 when the bucket region is explicitly provided in the connection configuration. This results in an error during the IMPORT FROM PARQUET operation.
When specifying a region such as eu-central-1 in the S3 bucket connection URL, the following error is encountered:
[Code: 0, SQL State: 42636] ETL-2217: AWS S3 provided bucket region (eu-central-1) is invalid. (Session: ******)
Workaround
To bypass this issue, users can avoid explicitly providing the region in the connection setup:
- Using the S3 URL without region:
- Using the S3 protocol directly:
CREATE OR REPLACE CONNECTION s3_conn TO 'https://test.s3.amazonaws.com'; IMPORT INTO iris FROM PARQUET AT s3_conn FILE 'demo.parquet';
CREATE OR REPLACE CONNECTION s3_conn TO 's3://test'; IMPORT INTO iris FROM PARQUET AT s3_conn FILE 'demo.parquet';
Both approaches successfully bypass the issue until the fix is applied.
Fix
This issue has now been fixed. The Parquet Reader has been updated to correctly handle region-specific bucket URLs for AWS S3. Users can now explicitly define the region in their connection setup without encountering errors:
CREATE OR REPLACE CONNECTION s3_conn TO 'https://test.s3.eu-central-1.amazonaws.com'; IMPORT INTO iris FROM PARQUET AT s3_conn FILE 'demo.parquet';
The update ensures full compatibility with AWS S3 region-specific configurations, allowing seamless import operations across all supported regions.
