Create VOLUME to Access AWS S3 Data:

Prerequisites:

After the STORAGE CONNECTION is created, you can create a VOLUME object to access object storage data.

CREATE EXTERNAL VOLUME aws_s3_volume_arn LOCATION 's3://cz-udf-user/' USING CONNECTION aws_bj_conn_arn DIRECTORY = ( ENABLE=true ) RECURSIVE = true;

View Detailed Information of Created VOLUME Objects

DESC VOLUME aws_s3_volume_arn

Access S3 to View Files Under the VOLUME Path

SHOW VOLUME DIRECTORY aws_s3_volume_arn;

Store the file metadata of the VOLUME directory to Lakehouse and view it

ALTER VOLUME aws_s3_volume_arn refresh; SELECT * FROM DIRECTORY(VOLUME aws_s3_volume_arn);