Unable to process files from S3 in SNOWFLAKE PROC
Needed some help in creating the below PROC. my goal is to copy the latest todays data from s3 files and load into tables. Few error handling i have added, like when file is not present then it would add it into log table, when file is present but load into table failed, i have marked entry in log, when its success the same has been added into log table. But its unable to do so. I am facing error while calling the proc.