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 .
I am in the same use case but using AWS Redshift, incase you are still stuck kindly let me know.
What are you data sources?
Which Data Warehouse platform are you using, Snowflake I assume?
Let me know where I can pick up from.