The way you aligned your explanation with the snowflake environment is simply outstanding. Its just go wit the flow, so easy to understand & grasp. Simply superb. Keep doing the good work.
data was not loaded in the tables through snowpipe and im try to troubleshoot using same approach that you have mentioned in the video ..."Query processed no results" this is im getting ...anyone have any idea about this
The explanation and ppts all are very helpful, Janardhan. But I have one doubt, at 23:08 we know one file is pending to upload as you have uploaded 3rd file which has some error in file format. But in pipe_status, pendingFilecount is still showing 0 not 1. Why it is showing 0 instead of 1? Can you please let me know?
Before the identify why the files were not processed and fix the issue, the files will be processed immediately. Or you can simply execute the copy command inside the pipe definition.
Hi Sir , Even though you changed file format in step 1 , How snowpipe Successfully loaded it ? the which you loaded in s3 bucket has field delimiter is ' , ' but in file format in snowflake you changed to ' | ' then how snowpipe load it Successfully ?(lastReceivedTimeStamp and lastForwadedtimeStamp are similar based on this I thought file was loaded successful)
Simply super & awesome explanation ,each and every video in the snowflake playlist .....
The way you aligned your explanation with the snowflake environment is simply outstanding. Its just go wit the flow, so easy to understand & grasp. Simply superb. Keep doing the good work.
Thank you Janardhan, For giving this wonderfull knowledge on snipipe like spoon feeding,Expecting the same in future,Godd luck.
I have finded good snowflake channel really it was very helpful Thank you
Thanks for sharing good knowledge 😍sir
data was not loaded in the tables through snowpipe and im try to troubleshoot using same approach that you have mentioned in the video ..."Query processed no results" this is im getting ...anyone have any idea about this
That means your setup is correct, but seems issue with query, please check the query
Hi bro,Really this video is very useful ,Thanks for that,can you make video for troubleshooting bulk loading from AWS to snowflake
The explanation and ppts all are very helpful, Janardhan. But I have one doubt, at 23:08 we know one file is pending to upload as you have uploaded 3rd file which has some error in file format. But in pipe_status, pendingFilecount is still showing 0 not 1. Why it is showing 0 instead of 1? Can you please let me know?
How manually process in prod if few files not processed
Before the identify why the files were not processed and fix the issue, the files will be processed immediately. Or you can simply execute the copy command inside the pipe definition.
Sir please can u help me everything is fine bt iam getting like pipe is in cloned state, though i hv done alter pipe too
reach me on jana.snowflake2@gmail.com
hi, is there any way to see which rows causing the error while loading the data
yes, by using copy option VALIDATION_MODE = RETURN_ERRORS you can see the error records. Watch my Copy Options video for more details.
Hi Sir , Even though you changed file format in step 1 , How snowpipe Successfully loaded it ? the which you loaded in s3 bucket has field delimiter is ' , ' but in file format in snowflake you changed to ' | ' then how snowpipe load it Successfully ?(lastReceivedTimeStamp and lastForwadedtimeStamp are similar based on this I thought file was loaded successful)
Watch and listen carefully, you will understand, answer is there in that video itself
The third file is not loades if you see, only the rows were parsed.
Sir can you mention topic wise lessons ,from installtion after what like that can you mention step by step
You can follow the playlist