Data Transformation Using the Snowpark API

Snowflake    |    Expert
  • 12 videos | 1h 49m 4s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
The Snowpark API is a framework for writing code in Python, Java, or Scala to work with Snowflake. The Snowpark libraries make it very easy to programmatically implement complex data transformations on Snowflake data using DataFrames. In this course, learn how to use Snowpark with Snowflake, build and execute Snowpark handlers, create and query Snowflake tables, perform data transformations, and use external libraries in Snowpark handlers. Next, discover how to connect to Snowflake from a Jupyter Notebook, create and query tables with Snowpark APIs, handle DataFrames in Snowpark, and implement the commands on DataFrame objects. Finally, explore how to perform DataFrame joins and set operations, leverage views in Snowpark with Snowpark APIs, work with semi-structured Snowpark data, and gain insights by creating and querying tables with semi-structured JSON data. Upon course completion, you will be able to use the Snowpark API with Snowflake.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recognize snowpark as a framework to work with snowflake using python, java, or scala code
    Create and execute snowpark handlers with different names and return types
    Create and query snowflake tables using snowpark
    Perform data transformations equivalent to sql queries with group_by and order_by clauses in snowpark
    Make standard anaconda libraries and custom python code available within a snowpark handler
  • Connect to snowflake from jupyter notebook and create and query tables using snowpark apis
    Implement the snowpark equivalents of select, from, where, group by, and order by on dataframe objects
    Implement union, intersect, and difference operations and joins on snowpark dataframes
    Use the snowpark apis to create views from any dataframe object
    Create a table with semi-structured json data and query it using snowpark
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 58s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 51s
    Upon completion of this video, you will be able to recognize Snowpark as a framework to work with Snowflake using Python, Java, or Scala code. FREE ACCESS
  • Locked
    3.  Executing a Snowpark Handler
    11m 19s
    During this video, you will learn how to create and execute Snowpark handlers with different names and return types. FREE ACCESS
  • Locked
    4.  Creating and Querying Snowflake Tables from Snowpark
    11m 53s
    In this video, discover how to create and query Snowflake tables using Snowpark. FREE ACCESS
  • Locked
    5.  Transforming Data and Working with Stages
    10m 56s
    Find out how to perform data transformations equivalent to SQL queries with group_by and order_by clauses in Snowpark. FREE ACCESS
  • Locked
    6.  Using External Libraries in Snowpark Handlers
    11m 4s
    In this video, you will learn how to make standard Anaconda libraries and custom Python code available within a Snowpark handler. FREE ACCESS
  • Locked
    7.  Using Snowpark from an Anaconda Jupyter Notebook
    9m 47s
    After completing this video, you will be able to connect to Snowflake from Jupyter Notebook and create and query tables using Snowpark APIs. FREE ACCESS
  • Locked
    8.  Selecting, Filtering, and Aggregating DataFrames
    11m 36s
    Learn how to implement the Snowpark equivalents of SELECT, FROM, WHERE, GROUP BY, and ORDER BY on DataFrame objects. FREE ACCESS
  • Locked
    9.  Performing Joins and Set Operations on DataFrames
    9m 54s
    In this video, find out how to implement union, intersect, and difference operations and joins on Snowpark DataFrames. FREE ACCESS
  • Locked
    10.  Leveraging Views in Snowpark
    6m 10s
    During this video, discover how to use the Snowpark APIs to create views from any DataFrame object. FREE ACCESS
  • Locked
    11.  Working with Semi-structured Data in Snowpark
    11m 44s
    Upon completion of this video, you will be able to create a table with semi-structured JSON data and query it using Snowpark. FREE ACCESS
  • Locked
    12.  Course Summary
    1m 53s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Getting Started with Snowflake: Using the Snowflake Data Platform
Rating 4.7 of 400 users Rating 4.7 of 400 users (400)
Course Continuous Data Pipelines and Dynamic Tables in Snowflake
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Processing Data: Integrating Kafka with Apache Spark
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)