#14 Load Data from AWS-S3 to SNOWFLAKE || S3 SNOWFLKAE INTEGRATION

Опубликовано: 18 Март 2026
на канале: Cloudlearningyard

6,959

163

Hello Everyone !

In this part we have discussed in details , How to Integrate AWS S3 to Snowflake & load data into Tables.
You will learn step by step process right from the setting up AWS account, IAM Roles & Security credentials.

In AWS we will create S3 bucket -- Folder -- Files.
In Snowflake we will required to create File Format, Stages & Storage Integration.

We have implemented both ways to load data, using credentials as well as Storage Integration.
Watch this video till end and comment if you face any challenges.

SCRIPT USED IN VIDEO BELOW :
CREATE TABLE AWS_CUSTOMERLOAD

(ID Int
,Name Varchar
,Age int
,Address varchar
,Phoneno varchar
,joiningdate date
,Runby varchar
);

SHOW FILE FORMATS; --INGEST_DATA

ALTER FILE FORMAT INGEST_DATA
SET PARSE_HEADER=FALSE
SKIP_HEADER=1;

CREATE OR REPLACE STAGE EXT_STAGE
FILE_FORMAT=INGEST_DATA
URL='s3://youtubelearningsnowflake/sourcefolder/';

SHOW STAGES;

LIST @EXT_STAGE;

COPY INTO AWS_CUSTOMERLOAD
FROM @EXT_STAGE
credentials=(aws_key_id='AKIAXEFUNHKFSVVOWX7F' aws_secret_key='WDZfGckBl3C6k3vf2Q3MqjVHlzoy++tFSa/yWceO');

SELECT * FROM AWS_CUSTOMERLOAD;

--- STORAGE INTEGRATION

Create or replace storage Integration S3_int
Type=External_stage
Storage_provider=S3
enabled=True
Storage_aws_role_arn='arn:aws:iam::490004626059:role/AWS_data_ingestion'
Storage_allowed_locations=('s3://youtubelearningsnowflake/sourcefolder/');

DESC INTEGRATION S3_int;

CREATE OR REPLACE STAGE S3_STAGE
FILE_FORMAT=INGEST_DATA
Storage_integration=S3_int
URL='s3://youtubelearningsnowflake/sourcefolder/';

LIST @S3_STAGE;

Select $1,$2,$3 from @S3_STAGE;

REMOVE @S3_STAGE;

Truncate Table AWS_CUSTOMERLOAD;

COPY INTO AWS_CUSTOMERLOAD
FROM @S3_STAGE;

Select * from AWS_CUSTOMERLOAD;

#snowflake #snowflaketutorial , S3 to Snowflake Integration, AWS S3 to Snowflake load, Connect AWS S3 to Snowflake. Snowflake AWS S3 Integration