tpch: load amazon-redshift sample data error

[BohuTANG]

Summary

 CREATE TABLE IF NOT EXISTS nation (
    n_nationkey INTEGER not null,
    n_name STRING not null,
    n_regionkey INTEGER not null,
    n_comment STRING
  );

COPY INTO nation FROM 's3://redshift-downloads/TPC-H/2.18/10GB/nation.tbl' file_format =(TYPE = CSV, field_delimiter = '|');

Snowflake is ok. Databend returns:

copy INTO nation
FROM
  's3://redshift-downloads/TPC-H/2.18/10GB/nation.tbl' file_format =(TYPE = CSV, field_delimiter = '|')

error happens after fetched 0 rows: APIError: PageError with 3002: PermissionDenied (persistent) at stat, context: { service: s3, path: TPC-H/2.18/10GB/nation.tbl } => no valid credential found, please check configuration or try again

The tpch raw data note is here: https://github.com/awslabs/amazon-redshift-utils/blob/master/src/CloudDataWarehouseBenchmark/Cloud-DWB-Derived-from-TPCH/10GB/ddl.sql#L114

[Xuanwo]

Please add allow_anonymous='true' to allow sending query without credentials.

For example:

copy INTO nation
FROM
  's3://redshift-downloads/TPC-H/2.18/10GB/nation.tbl' CONNECTION = (allow_anonymous='true' region='us-east-1') file_format =(TYPE = CSV field_delimiter = '|');