Hi ,
All my .csv files will be placed in the AWS S3 Bucket .
I need to read and load data to the staging area of snowflake database ,Could you please detail the transformation process elaborately to go ahead with the development .
The reason i am asking is in snowflake they are using the copy command to copy the files with url and loading into the staging area ,hence i am not pretty sure how to do this in iIcs and what are the factors need to be considered during source mapping process . Would appreciate if you could throw some light on this .