#01 | What is Snowpark in Snowflake

[@user-fo2ex1uh3k]

The easiest-to-understand video about Snowpark. Thank you

[@DataEngineering]

Glad it was helpful!

[@br2478]

This is the best video so far describing what Snowpark is, thank you for sharing 🙏🏼

[@DataEngineering]

Glad it was helpful!

[@anilkumark3573]

I thought of asking you about the snowpark, But you started, Good to see sir

[@DataEngineering]

Yes, thanks

[@ksrajavel]

Thanks! - 13 Feb 2024 - 08:41 PM IST

[@MrMadankumar]

Great effort in educating people with your videos. Can’t appreciate your effort enough with words. I have been watching all your playlists and I must say I’m hooked up to your channel so much. Thanks again for these wonderful knowledge sharing videos

[@DataEngineering]

So nice of you

[@deepak010]

Very informative video having information which are not easily available over internet. Loved the first episode, eagerly waiting for following episodes.

[@DataEngineering]

Thanks a ton

[@kamleshbhandari8680]

Perfect compilation of information. Thank you.

[@DataEngineering]

Thanks for your note..

[@subramanyams3742]

Great content again. Thanks alot. Eagerly waiting for all the 15 episodes. I have seen snowflake videos many times and learnt a lot and still watching. Can we expect one snowspark video every week? 🙂

[@DataEngineering]

glad .. you liked all my videos... will try to publish one video every week...

[@shriyankarath5388]

Very nice video playlists Sir. I am learning everyday from your videos. It would be much helpful if you also upload videos on Data structure and algorith using python

[@DataEngineering]

Thanks for your note.. for now my focus is on Snowflake..

[@willywooca]

If I'm a SQL developer familiar with writing SQL, does that mean I can just write my code in SQL without needing to use Snowpark?

[@everythingintamil-9781]

How to extract the .gz file from stage to snowflake folder ? and how you maintaining the .csv files in separate folder in snowflake. Thanks

[@pritammukherjee7498]

Great content. Thanks.

[@DataEngineering]

Glad you liked it!

[@ashokkumar-vu3vd]

I am almost done with the snowflake video series. I have started giving interviews but as far as I understand there are very less calls for snowflake right now. Can we expect a good amount of interview calls at least from mid of May and June. Could you pls share ur thoughts on this. Thanks in advance.

[@DataEngineering]

Snowflake is a cloud data warehouse platform.. and you must have data warehouse knowledge or data engineering knowledge alongside snowflake.. else it will be hard to get a call... it also depends on what is your current year of experience ...

[@sanishthomas2858]

Very great knowledge..but even being in uk z there is calls for snowflake.. you should know our tools too to crack the jobs..

[@ndz7372]

Thank you sir!

[@DataEngineering]

Welcome

[@sardesaisantosh]

Are you the same tutor who had udemy course on aws redshift and related

[@DataEngineering]

No.. here is my udemy contents These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/

[@subhojyotiganguly5013]

Great video.. But question 1.when data present in snowflake the easiest wat to trasform the data using sql.why we need snowpark here? 2.can we use snowpark as a ETL like Talend or iics(taking the data from other rdbms table or file system) or this just for elt?

[@DataEngineering]

There are couple of reason 1. A team is migrating their work from PySpark or Spark to Snowpark, then you can use the same set of code without writing a fresh SQL statement and save tons of effort. 2. Having a DevOps based ETL development in some strict environment is more easy for Python based tool than using SQL 3. If your team is not good with SQL, then programming is the best approach (this will surprise you, but there are many who are very good in programming but poor in SQL) 4. Programming gives lot of code re-usability and library integration and much more easy to work than working with large SQLs. Follow my channel and I am going to publish a video that will talk about end to end ETL using Snowpark for data engineers.

[@subhojyotiganguly5013]

@Data Engineering Simplified thank you . What do you suggest? How important DBT is to work on snowflake, creating data model.

[@DataEngineering]

@@subhojyotiganguly5013 dbt is getting very popular and yes, you can certainly used dbt. DBT is one of the future tool becoming very popular alongside snowflake.

[@user-ev3mq2cx8t]

Where your snowflake is installed or can you explain how can i integrate snowflake and snowpark in my local windows system

[@DataEngineering]

If you are using python, then you need to have python 3.8.x (not higher version, else it will not work) and then use pip to install your snowflake-python-snowpark library and it will automatically be available for use. Once it is done, you can use session api to connect (I am releasing a video on this soon)

[@abhisheksrivastava5204]

Hi How much syllabus covered Snowflake Advanced Data engineer certification

[@DataEngineering]

A lot + including scenario based questions..

[@subramanyams3742]

@@DataEngineering Could you please share the play list link here for snowflake advanced certification. not able to find from your channel.

[@abhisheksrivastava5204]

where to find this code ?

[@DataEngineering]

Please check this medium blog for code.. medium.com/@data-engineering-simplified/588b19591b47