Null Handling In Snowflake | Snowflake Data Loading Consideration | Ch-09

[@nivedhaumamaheswaran2087]

Hi Sir. I have cleared my snow pro core certification last week. Your videos were very useful, especially practice test playlist. I got so many questions from that.. Thank you sooooo much for preparing snow pro core series. I am super happy now ☺️☺️

[@DataEngineering]

Great job and thanks a lot for the feedback...it helps me a lot to create more contents...

[@hunsursriprasad8508]

Sir: Thanks a lot for creating this wonderful and informative series. You have covered all practical aspects of data engineering in this series. Please keep producing such wonderful videos. I have one small request: I have been desperately looking for the data files you have used in these exercises. I could not find them in the description. I also checked your website and did not find them. Can you please include a link to the data files so that learners like me can try out the lessons you have created? This is my humble, and respectful request.

[@rishi150511]

Hello brother, great. I saw your video .really great and simple and easily untestable. But i can't find the code area link in your description below. Can you share me the code link

[@selvas5043]

Super explanation. Thank you

[@DataEngineering]

You are welcome

[@a2zhi976]

I from hive and Teradata background . there also we load data from files to stage table and than to prod tables. all these sqls we create in one or two files -example stage_emp.btq, stage_emp_2_emp.btq ( which is form same stage to main table) , both the scripts are called in unixscript or ./stage_emp.btq stage_emp_2_emp.btq . how can i achieve smiliar to this in snowflake.

[@sunshadow9704]

Thank you man. The video is right to the point.

[@DataEngineering]

Glad it helped

[@a2zhi976]

Can you please tell how we can load stage to main table in batch mode .. in production we can not run snowflake edition

[@DataEngineering]

When you say "Batch Mode", what you do mean by that... and stage is external or internal? 1. When you run the copy command, it internally remember which all files are copied 2. So next time, new files are arrived... only those files will be copied as new chunk or batch and old files will not be loaded 3. or you can delete all the old files before new file arrives using remove @my_stage command.

[@vinaykumar_DE]

Your videos are really good I want work flow explanation for a snowflake developer for the interview purpose

[@DataEngineering]

will add them soon..

[@LusyPatel]

The content above is informative, But can u make a video on using the file on the internal stage directly and not copying the csv file into any table and making the changes just by queryng on the internal stage

[@DataEngineering]

Why don't you watch ch-11 of snowflake external table, that can be helpful. kzbin.info/www/bejne/rWqlgqaFoa-Wa9U

[@ashadzaman7104]

bro make a video about Talend for RDBMS to Snowflake for CDC , if you have any suggestions please provide me i want to study

[@DataEngineering]

sure.. not in my immediate list.. but will see

[@vinaykumar_DE]

i want file format options explanation (escape,escape_unenclosed_field, skip_BOM etc )

[@DataEngineering]

will review and make a video in future.

[@bikkiobaiah4688]

Hi sir, haven't upload anything related to project..???

[@DataEngineering]

Will upload soon

[@kiranjit4u]

Moral of the story is if \\N bydefault snowflake treats as null

[@DataEngineering]

right..