Connect to the ECS endpoint and create an external stage. Create named external stages using CREATE STAGE. A named stage object can be used to list files, load data, and unload files, among other SQL actions.
The Snowflake ‘s3compat’ identifier provides support for S3-compatible object stores such as Dell ECS.
create or replace stage ext_stage_dellecs
url='s3compat://snowflake/dellecs/iris/'
endpoint='<Dell ECS On-Prem endpoint>'
credentials=(
AWS_KEY_ID='<Dell ECS Access key>'
AWS_SECRET_KEY='<Dell ECS Secret Key>'
);
After the external stage is created, the files stored in the bucket/prefix can be listed by running the following command:
list @ext_stage_dellecs;
