hello everyone in this particular lecture we are going to learn how to load data into a snowflake table from Amazon S3 bucket so this is the new GUI interface of snowflake if you do not have this account you must create it first so first of all what I'm going to do I'm going to go in the Google search bar I'm going to open my AWS console I'm going to type AWS in the Google search bar I'm going to click this particular link and then I'm going to sign in to the console uh okay fine I'm going to select the root user provide my email address and then the password here okay just provide the password Here click sign in this is going to take me to the AWS console and afterwards I'm going to click the S3 bucket so what I'm going to do I'm going to create a new S3 bucket and I'm going to upload a CSV file which is located in my in my computer system so this is the file that I'm going to load I'm going to upload okay look so this is CSE comma delimited file so create a new bucket provide the bucket name Bucky 2020 2010 is the name of bucket create a bucket so a new bucket has been created now go to the bucket and I'm going to upload a file upload a file add files and I'm going to upload this video games dot CSC file which I am going to load in my snowflake Target table okay the the file has been uploaded successfully in in my bucket the next step is go to the services go to the IM and I'm going to create a policy for my bucket and I'm going to go to the policy section go to the policies create a policy and json's policy is a Json document so this is my policy just copy paste this okay now here I'm going to provide the bucket name so in my case the bucket name is 2010 which I have just created so this is going to be the name now okay create click next next okay policy name policy 2010 is the policy name create policy so this is going to create my policy for my S3 bucket okay now the policy has been created successfully this is the name next I am going to create a role uh create role and AWS account and Okay click next and select the policy so this is the policy I'm going to create a role for my policy this one click next and provide the role name 2010 is the role name okay click create role so role has been created successfully afterwards I'm going to go to the role and I have to copy this Arn I need this yearn but first of all what I'm going to do next I'm going to create a new worksheet in Snowflake and I have to make sure that this is the rule in the snowflake is account admin it is set to account admin this one compute underscore wh is to default Warehouse okay now first of all let me just select no database selected I have to select a database snowflake let me just select the snowflake database so these two databases are already present are default databases when you're going to create a new snowflake account so from the from this database I am going to create a warehouse so warehouse and snowflake provides the required resources such as CPU memory and temporary storage to perform the DML operations so let me just copy paste these three queries and let me just paste here in my worksheet snowflake so I'm going to create a new Warehouse dwh underscore wh is the name of my warehouse execute it has been executed successfully now DBT underscore DB is the name of my database create this and database name and the schema name is prod it has been created successfully afterwards I am going to create a new integration object so the purpose of integration object is that it helps you to connect to the AWS bucket so I'm going to copy paste these commands here this command here and so while creating this integration object I need to provide these two information okay Arn so this Arn I'm going to get it from here let me just provide it here copy paste and bucket name is 2010 is the bucket name okay object underscore 2010 is the integration object run execute create it has been created successfully afterwards I am going to use this describe command describe command to get the information so I'm going to get two things from this command I'm going to show you first let me just execute this sorry I have to use this integration object let me just paste here run okay bucket name is Bucky 2020 2010 which is my bucket name and I need the external ID and the user Arn so first of all let me just select my external ID which I'm going to use here so external ID I'm going to use in my trust relationship section edit the trust policy and I have to copy this trust policy here let me first copy this and let me just paste this here let me just copy and paste here get policy so the policy has been updated successfully so afterwards I am going to create a new CSV format file format so I'm going to go in my worksheet create a format the format name is CSV underscore format Type S file is CSV it is comma delimited file skip header it header equals to 1 it means that I am not going to include the header Row in my final Target table so just execute this command so execute it successfully the file format has been created so next I'm going to create the stage area the purpose of this area is that a state specifies where data files are stored so that the data in the files can be loaded in into a table so let me just use this command okay stage area let me just give the stage area name and object the object name is this one bucket name is 2010 is the bucket name file format is this CSV format execute this and this has been executed successfully the last step is that I have to create a table and then have to use the copy into command to load the data load the file in my final Target table so I don't have this table in my database I am going to create it replace table has been created let me show you my database this is the database okay and let me show you this is the schema prod and this one is my target table okay the last step is to use the copy into command to load the file data in in my final Target table so I will use this command and 2010 is the name of stage areas no stage okay okay file has been loaded successfully Rose loaded 998 let me check again how many rows are in my CSV file so let me just count the number so 998 there are 998 rows in my CSV file which have been loaded successfully these roles have been loaded successfully now let me just query the top 10 rows of my table product table so the warehouse I have selected this DWS underscore wh which is my whereas which I've just created database as I am in database DBT DB prod okay now execute this select command look data has been loaded successfully so hope you understood this concept thank you so much and have a great learning