Course Overview
This one-day workshop, designed for professionals creating DataFrame data solutions in Snowflake, covers key Snowpark principles, features, and programming constructs. There will be lectures, demonstrations, laboratories, and debates in this course.
Prerequisites
Requires completion of the Snowflake Essentials Data Warehousing Workshop or similar knowledge.
- Prior data warehouse experience is presumpted.
- The ability to write code in Java, Scala, or Python with a basic level of skill.
- Familiarity with Snowflake objects and essential SQL
Audience Profile
- Data Engineers
- Data Scientists
- Data Application Developers
- Database Architects
- Database Administrators
- Data Analysts with programming experience
Learning Objectives
- Describe the client-side and server-side features of Snowpark.
- Utilize a Snowpark Session object to connect to Snowflake.
- Using Snowpark DataFrame objects to query data sources.
- Use a set of DataFrame functions to perform fundamental and sophisticated data manipulations.
- Action DataFrame objects to process outcomes locally or store outcomes in Snowflake.
- Write code that is reusable and shareable as User-Defined Functions (UDFs).
Content Outline
- A technical overview of Snowpark.
- Getting the Snowpark API up and running.
- Establishing Snowflake connections and investigating various forms of authentication.
- Understanding Snowpark's DataFrames and how they operate Snowflake's elastic compute engine
- Examining various techniques for building a DataFrame object.
- Key programming ideas for Snowpark DataFrames, including as data types, schemas, and lazy evaluation.
- Creating fundamental create assertions.
- Applying column operations for filtering and transforming data
- Using scalar functions and operators
- Sorting and limiting results
- Performing aggregate and set-based operations on DataFrames
- Transforming semi-structured data in DataFrames
- Identifying the differences between and how to use DataFrame actions and transformations
- Best practices for utilizing lazy evaluation in data transformations
- Evaluating DataFrame transformations with actions that return data to the client-side
- Publishing logical DataFrame operations as views
- Creating and appending Snowflake tables with DataFrame results
- Writing a basic UDF in Snowpark
- Registering and granting access to UDFs to share code with others
FAQs
A: Snowflake Training students need...
- to bring a laptop
- a Snowflake-compatible browser
A: We recommend you attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, if you have to skip the class due to some contingency, Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
A: The learners will be enthralled as we engage them in the natural world and Oriented industry projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you a lot in your future tasks and assignments.
A: It will be an added advantage if you have any technical knowledge. However, we will arrange additional sessions to train you on the basics.
A: You can request a refund if you do not wish to enroll in the course.
A: Yes, you can.
A: We adhere to the highest Internet security standards. Any data that is kept is not disclosed to outside parties.
A: It is recommended but optional. Being acquainted with the primary course material will enable students and the trainer to move at the desired pace during classes. You can access courseware for most vendors.
A: You can buy online from the page by clicking on " Buy Now". You can view alternate payment methods on the payment options page.
A: Yes, students can pay from the course page.
A: The course completion certification will be awarded to all the professionals who have completed the training program & the project assignment given by your instructor. Using the certificate in your future job interviews will surely help you to l& your dream job.